Topics
(Move to ...)
SQL Server Health Check
Helpful tSQL
Performance Tuning
SQL Server Security
Database Maintenance
Disaster Recovery
▼
Tuesday, June 9, 2026
Patch Tuesday June 2026: Skipped SQL Server and Landed on Your Firmware
›
It is Patch Tuesday again. Microsoft shipped around 200 fixes today and three publicly disclosed zero-days, and not one of them is in...
Why Are We Still Paying for SQL Server?
›
A client asked me last week, plainly: 'Why are we still paying for SQL Server when Postgres is free?' It is a fair question, ...
Monday, June 8, 2026
Least Privilege for AI Accounts in SQL Server
›
Over the past few months, attackers have been talking Meta's new AI support bot into handing over Instagram accounts they didn...
Saturday, June 6, 2026
Globex, Globx, and GLOBEX: Fuzzy String Matching in SQL Server 2025
›
You have a customer list. Somewhere in it, 'Globex Corporation' got entered four different ways by four different people at f...
Wednesday, June 3, 2026
The AI Didn't Hack Mexico. SQL Injection Did.
›
I live in Cozumel, MX part-time. So when one person walked off with about 150GB of Mexican government data this winter — tax records,...
Tuesday, June 2, 2026
Cursed SQL: Six Queries That Run Fine Until They Don't
›
Sometimes SQL can be cursed. It runs fine in dev and makes it through testing without issue. Then it gets to production, the table gr...
3 comments:
Monday, June 1, 2026
Error 7416: When a Security Patch Breaks Your Linked Servers
›
Microsoft's May 2026 cumulative update for SQL Server 2025 (CU4, KB5089899) did two things on the same day. It closed a remote c...
2 comments:
Tuesday, May 26, 2026
SIL — Because Holding 1,000 KEY Locks Is So 2022
›
Back in September I wrote about Optimized Locking in SQL Server 2025. Two components: Transaction ID (TID) locking and Lock After Qu...
Monday, May 25, 2026
Your SQL Server 2016 Upgrade Will Succeed. Then Monday Happens.
›
SQL Server 2016 goes out of support on July 14, 2026. You know that already. What you may not know is how many seemingly successful u...
Thursday, May 21, 2026
Your JSON Column Was Never a JSON Column
›
For roughly a decade, the way you stored a JSON document in SQL Server was to not store a JSON document at all. You stored a string. ...
‹
›
Home
View web version