Many of us use AI the same way every single day. Open a tab. Paste in a question. Copy the answer out. Fix what it got wrong. Then tomorrow,...
2026-09-30 (first published: 2026-09-18)
381 reads
My T-SQL Tuesday #202 entry for Marlon Ribunal's invitation on memorable SQL Server outages. Two nights I still remember minute by minute, and what I do differently because of...
2026-09-18 (first published: 2026-09-08)
319 reads
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend or a foe, from full-throated defenses to a lab built to prove me wrong.
2026-09-04 (first published: 2026-08-25)
92 reads
My T-SQL Tuesday #201 invitation. Do temp tables help performance or hurt it? I argue moving data into a #temp table is usually the wrong reflex, and invite you...
2026-08-04
104 reads
Fabric has CI/CD built in, but if you've tried to use it for database deployments, you've probably already run into its limits. It's still very much in its infancy....
2026-07-20 (first published: 2026-07-10)
241 reads
Index maintenance has always meant nightly jobs and a window you have to defend. Azure SQL’s new Automatic Index Compaction targets page density directly — so I tested it.
2026-07-10 (first published: 2026-06-30)
330 reads
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday, and everything that went right—and wrong—along the way.
2026-06-26 (first published: 2026-06-06)
186 reads
SQL Server 2025 In my previous blog post, we briefly covered the new compression being introduced in SQL Server 2025. After some...
2025-08-26
42 reads
Compression was introduced in SQL Server version 2008. While it helped, the compression ratios were frequently too low to justify the...
2025-08-13
34 reads
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
2025-07-03
39 reads
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
You can find the slides and SQL scripts for my session “Spice up your...
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hi, I have a trigger, that works fine elsewhere but is not working at...
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers