Inspect temp table statistics across procedure calls, compare estimates with loaded rows, and test targeted refresh and recompile fixes.
DROP IF EXISTS and CREATE OR ALTER for Iterative Deployments
Run your deployment script twice and see what survives. A short demo shows why CREATE OR ALTER keeps permissions and drop and create does not.
A T-SQL Cheat Sheet for Everyday Work
This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms
Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.
Compare Showplan: Finding What Changed Between Two Plans
Compare Showplan shows where two plans differ, but not why. Here is a small before and after example you can run yourself.
Trying New SQL Server Features Without Risk
Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.