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.
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.
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.
Finding Long Open Transactions With sys.dm_tran_database_transactions
A forgotten BEGIN TRAN can pin your log for hours. Here is how to find the owner, read its age, and confirm the transaction is the reason.
Peak Concurrency: The Busiest Moment From Start and End Times
Counting sessions per day tells you nothing about overlap. Here is a small event-sweep query that finds the busiest moment, with the tie trap explained.