An inactive or sleeping session may still be a useful pooled connection. A customer case prompted my earlier session-cleanup script.
Dirty Pages – How to List Dirty Pages From Memory in SQL Server? – Interview Question of the Week #223
Question: How to List Dirty Pages From Memory in SQL Server? Answer: I received question today during my SQL Server Performance Tuning Practical Workshop.
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.
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.
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.
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.







