Find databases below the native compatibility level, generate reviewable ALTER statements, and prepare Query Store checks safely.
Binary Collations: Byte-Order Sorting and Exact String Matches
Learn how a binary collation changes SQL Server sorting, exact string comparisons, index access, and column metadata checks.
Capturing Actual Execution Plans From a Script With SET STATISTICS XML
Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.
Listing Non-Default Server Settings From sys.configurations
Inventory non-default server settings with a versioned baseline, compare configured and active values, and keep the review read-only.
Ten SSMS Settings Worth Changing on Day One
Review ten SSMS settings for safer connections, clearer results, useful plans, and recoverable query text before starting your everyday work.
How I Know If I am DBOWNER or Not in SQL Server? – Interview Question of the Week #222
How do I know if I am DBOWNER or not in SQL Server? A DBA worried about permissions before my changes, so we ran this simple script to check db_owner membership.
Period-to-Date Totals: Today, Week, Month and Year in One Scan
Calculate period-to-date totals with shared scan boundaries, Monday-based weeks, and older date arithmetic for SQL Server reports.