During a demo of Redgate Monitor Enterprise to a customer, they asked about how to search for permission changes. This post examines how you can do that in Redgate...
2025-07-14 (first published: 2025-06-23)
277 reads
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend, with lots of friends, a family atmosphere, and some amazing speakers from whom I learn...
2025-06-22
23 reads
lackout – n. the sudden awareness that you’re finally over someone, noticing that the same voice that once triggered a cocktail of emotions now evokes nothing at all –...
2025-06-21
12 reads
One of the things I’ve been experimenting with in AI is taking things other people do and seeing how well the AI works. In this case, I took a...
2025-06-20
9 reads
I’ll be at SQL Bits tomorrow, Saturday Jun 20, 2025 for the final day of the conference. I wasn’t selected to speak, but since I’m in Cambridge next week...
2025-06-20
6 reads
I had someone ask me about using triggers to detect changes in their tables. This is the third post in the series. The first one Another post for me...
2025-06-18
16 reads
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
317 reads
I can’t believe I’ve been at Redgate long enough to get a third sabbatical. I’ve very lucky to have this job, still enjoy it, and get the benefit. I’ve...
2025-06-13
3 reads
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –...
2025-06-27 (first published: 2025-06-13)
435 reads
I had someone ask me about using triggers to detect changes in their tables. This is a second post looking at triggers, in this case, modifying my trigger to...
2025-06-11
64 reads
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...
$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...
$server = "YourServer" $db = "YourDatabase" $sqlFile = "C:\path\query.sql" $outFile = "C:\path\output.xlsx" # Run...
Hi everyone I have a 1000 line SQL query that is too long to...