Topics

▼
Friday, October 17, 2025

Breaking Changes & Migration Risks in SQL Server 2025

›
Breaking Changes & Migration Risks in SQL Server 2025 Every new SQL Server release comes with shiny features — but SQL Server ...
Monday, October 13, 2025

Move SQL Server Data Instantly -- ALTER TABLE SWITCH

›
Use ALTER TABLE ... SWITCH to move very large tables instantly.  Yes.  I said instantly.  ALTER TABLE .. SWITCH doesn't copy the data...
Thursday, October 9, 2025

Using AI to Write SQL: What's Real, What's Hype

›
  "Show me top customers by sales for last quarter." AI writes the query, formats it, and even adds a comment.  Look at the time y...
Friday, October 3, 2025

SQL Server Waits

›
SQL Server records every moment it spends waiting — on locks, latches, I/O, CPU coordination, memory and network calls. The DMV sys.dm_os_wa...
Saturday, September 27, 2025

TempDB Under Control in SQL Server 2025

›
TempDB has been every DBA’s troublemaker.  Runaway sort spills, hash joins gone wild, or a single session chewing up all the space until eve...
Thursday, September 25, 2025

SQL Server's Memory Grant Feedback --> The Fix That Breaks Things

›
What Is Memory Grant Feedback? Before SQL Server runs a query, it estimates how much memory it needs for sorting and joining. But what if it...
Monday, September 22, 2025

SQL Server 2022's Parameter Sensitive Plan Optimization - A Game Changer for Trading Systems

›
If there's one feature that's generating buzz in the SQL Server community right now, it's Parameter Sensitive Plan (PSP) Optimiz...

OUTER APPLY in SQL Server -- When and Why to Use It

›
OUTER APPLY is one of those SQL Server operators that can seem mysterious at first, but once you understand its power, it becomes an invalua...