Build a practical SQL Server reference around everyday questions, with compact queries for context, objects, requests, space, and transactions.
Finding Dynamic SQL Open to Injection
Find dynamic SQL open to injection by searching module definitions for concatenation, then replace data concatenation with parameters.
Reading SQL Server Release Notes Before You Patch
Reading SQL Server Release Notes before patching helps you find known issues, fixes, behavior changes, and workload risks.
SQL SERVER – Create Check Constraint on Column
A junior developer wrote a trigger to block invalid data. A Check Constraint is simpler. My example limits PostalCode length in AdventureWorks and tests it.
A Quarterly Permission Review
A quarterly permission review checks server and database roles, new grants, orphaned users, service accounts, and owner signoff.
SQL SERVER – Find Current Identity of Table
Many developers use MAX() to find the current identity of a table. I prefer DBCC CHECKIDENT, which reports the current identity value directly.
Comparing Two Databases Without a Scoreboard
Learn how to compare databases using representative work, operational skills, recovery requirements, and costs rather than feature-count scoreboards.