Find auto shrink and auto close settings, generate reviewed correction commands, inspect model, and check the effects of prior shrink work.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.
Stopping Duplicate API Requests With an Idempotency Key Table
Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.
Renaming Something Without Breaking Everything
Plan a rename database object change with dependency checks, updated callers, permission tests, and a temporary compatibility name when suitable.
Ranking Items by Rating Fairly With a Bayesian Average
Use Bayesian average in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Free Tools Worth Having on a SQL Server
Choose free SQL Server tools by the problem they solve, from SSMS and sqlcmd to Extended Events, and understand the limits before relying on them.
Why the Same Query Is Fast Then Suddenly Slow
Recognize parameter sniffing by comparing compiled values, data distribution, and reused plans, then test a remedy with its tradeoffs.