Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton of fun writing these, and I hope you’re enjoying the ride through SQL Server’s haunted...
2025-11-03 (first published: 2025-10-17)
302 reads
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until they don’t. By the time someone notices an application outage or a failed backup, you’re...
2025-11-03 (first published: 2025-10-15)
332 reads
foilsick – adj. feeling ashamed after revealing a little too much of yourself to someone – allowing them too clear a view of your pettiness, your anger, your cowardice,...
2025-10-31
33 reads
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help that," said the Cat: "we’re all mad here. I’m mad. You’re mad.""How do you know...
2025-10-31 (first published: 2025-10-13)
308 reads
I had a conversation with a customer asking this question: how can I tell who called a stored procedure so I can audit the action? I decided to see...
2025-10-31 (first published: 2025-10-15)
289 reads
Trust is the currency of the data economy. Without it, even the most advanced platforms and the most ambitious strategies collapse under the weight of doubt. For Chief Data...
2025-10-30
15 reads
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This one surprised me. This is part of a series of experiments with AI systems. Looking...
2025-10-29
20 reads
For decades, enterprises have approached data management with the same mindset as someone stuffing everything into a single attic. The attic was called the data warehouse, and while it...
2025-10-29 (first published: 2025-10-09)
317 reads
If your production SQL Servers are still running 2016 (or older) you’re basically banking on inertia. Sure, it’s been stable. But that doesn’t guarantee it’ll stay safe or compliant....
2025-10-29
27 reads
Truncate Table Pitfalls
Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly. If you want the speed without the face-palm moments, here’s a practical, interview-ready guide to...
2025-10-29 (first published: 2025-10-08)
816 reads
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers