Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.
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.
The Handful of Counters That Actually Matter
Make SQL Server monitoring useful by relating waits, batch activity, memory indicators, and file latency to the same workload and observation window.
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.
Pulling Values Out of Text With REGEXP_SUBSTR and REGEXP_INSTR
Extract codes with REGEXP_SUBSTR in SQL Server 2025, locate matches, select occurrences and capture groups, and validate text boundaries.