SQL Server Alerts
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)
330 reads
Blog Posts
A New Word: Foilsick
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
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
"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
Prompt AI helping with Auditing
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)
286 reads
Measuring What Matters: Operationalizing Data Trust for CDOs
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
A Small LLM Fail
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
18 reads
Fabric as a Data Mesh Enabler: Rethinking Enterprise Data Distribution
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
SQL Server Versions: Out With the Old, In With the Supported
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
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)
802 reads
T-SQL Tuesday #191 Round Up
I hosted this month, late as it turns out, but we still had a few entries. Here’s a look at the blogs people published. First as always, Rob Farley...
2025-10-28
16 reads
Blogs
SQL Server Journey (Part 1)- Enterprise Database 2016
By Vinay Thakur
Continued thinking about my Journey blog where we have to look back at the...
Announcements from the Microsoft Fabric Community Conference
By James Serra
A ton of new features for Microsoft Fabric were announced at the Microsoft Fabric Community...
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026)
By SQLPals
PowerShell Remoting for SQL DBAs: WinRM + SSH Guide (Updated 2026) ...
Forums
Identities and Sequences II
Comments posted to this topic are about the item Identities and Sequences II
Using PostgreSQL as a NoSQL Store and a Search Engine
Comments posted to this topic are about the item Using PostgreSQL as a NoSQL...
Is Your Time "Free"?
Comments posted to this topic are about the item Is Your Time "Free"?
Question of the Day
Identities and Sequences II
In thinking about the differences between the identity property and a sequence object, which of these two guarantees that there are consecutive numbers (according to the increment) inserted in a single table?
See possible answers