Topics

▼
Saturday, April 4, 2026

Query Store Hints: Code-Free Performance Tuning

›
That query is killing your server. You know which one. You found the plan with sp_BlitzCache a couple weeks ago and spit out your cof...
Thursday, April 2, 2026

Your Nightly Index Rebuild Job May Be On Its Way Out

›
Microsoft's announcement of Automatic Index Compaction is titled 'Stop defragmenting and start living' . That is not an a...
Wednesday, April 1, 2026

Azure Is Selling You Half a Core at Full SQL Server Price

›
The Azure migration pitch is convincing. Lower overhead, no hardware refresh cycles, pay for what you use. Management loves it. The C...
Tuesday, March 31, 2026

Because 'It Seems Fine' Is Not a Strategy.

›
Most SQL Server problems do not arrive all at once. They build quietly, collect bad habits, and wait for the worst possible time to present...
Monday, March 30, 2026

Brent Added AI to sp_BlitzIndex. I Had to Try It.

›
Six posts. That's how long it took me to go from skeptic to convinced on sp_BlitzCache + ChatGPT. If you missed that series, her...
2 comments:
Thursday, March 26, 2026

Resource Governor in SQL Server 2025. A Good Change.

›
Someone runs a massive SELECT INTO #temp , tempdb fills the drive, and the entire instance freezes up dead. You get paged at 2 AM, ki...
Wednesday, March 25, 2026

SQL Server 2016: 111 Days. The Last Patch Just Dropped.

›
On March 10, Microsoft dropped a security patch for SQL Server 2016. It fixed a publicly disclosed, actively scrutinized elevation-of...
4 comments:
Tuesday, March 24, 2026

They Hid Malware in a SQL Table. A weak password and BCP Did the Rest.

›
BCP. I love it. It's a workhorse — bulk copy data in, bulk copy data out, no drama. I've used it more times than I can count...

SQL MCP Server: From Setup to Live Data

›
In a previous post, I covered what SQL MCP Server is, why it matters, and why getting the security model right is non-negotiable. If ...
2 comments: