Old habits are hard to change sometimes. Time and again, regardless of what the task or query for information might be, my go-to source of information is Google. Whether on my phone or computer, my muscle memory instinctively opens a browser window or clicks into the search widget and starts typing. My “google foo” has […]
2025-03-30 (first published: 2025-03-29)
55 reads
Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]
2025-02-23 (first published: 2025-02-22)
96 reads
My last two months have been packed full of activity. I’ve had the amazing opportunity to be with PostgreSQL friends in New York, Greece, and Seattle. In between, it was a treat to be back in Pittsburgh for the first SQL Saturday since before the pandemic. The strength of the database community at each event […]
2024-11-24 (first published: 2024-11-23)
59 reads
Have you ever been stuck in some area of your life? Maybe at work? That big project. Progressing in your career. The slow query that seems impossible to make faster. Learning new skills to switch careers. Maybe outside of work? The weekend home project that’s been going on for more than a few weekends… possibly […]
2024-09-28
83 reads
Writing editorials every few weeks for a technical mailing list has been one of the more challenging responsibilities in my (nearly) two years with Redgate as an advocate working with Steve, Grant, and Louis. Each week, it’s interesting for me to see the mix of technical insights and everyday life stuff that each of us […]
2024-08-31
395 reads
We’re halfway through the Olympics, with all the usual drama – highs, lows, special interest stories - and even a surprise hero in Yusuf Dikec at the 10-meter air pistol (the memes have been strong with this one). As I was talking with my children this week, one of them asked, “So dad, what sport […]
2024-08-04 (first published: 2024-08-03)
55 reads
I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]
2024-07-20
181 reads
Last week was supposed to be my turn to curate Database Weekly and write an editorial to go along with it. Graciously, Mr. Louis Davidson (@drsql) offered to switch weeks while I was in Cambridge, England with most of the Redgate Marketing team for our yearly global gathering at HQ. As a remote worker on […]
2024-06-15
55 reads
I love honeybees. This will be my seventh year as an amateur beekeeper, and aside from family or data, there are few other topics that I could easily spend an afternoon talking to you about. They’re amazing creatures. This past winter I had to move my beehives temporarily to the apiary of a friend. With […]
2024-05-12 (first published: 2024-05-11)
80 reads
As a member of the PostgreSQL open-source community, I have been following the recent license change by Redis Labes on March 20, 2024. Redis introduced a dual license model, specifically adding the Redis Source Available License (RSAL), which prevents other vendors from providing Redis as a service without a paid subscription from Redis Labs. The […]
2024-04-13
157 reads
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers