Three new DMVs in SQL Server Denali: sys.dm_server_memory_dumps, sys.dm_server_services and sys.dm_server_registry. What they return, and a question for you.
Scheduling Patch Windows Without Surprises
Scheduling Patch Windows requires realistic restart time, failover steps, job coordination, backup checks, and clear stop rules.
Certificate-Signed Procedures That Read Server DMVs Safely
Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.
Checking for SQL Server Dump Files After a Crash
Did the server really crash, or just restart? Here is how to list dump files, read the error log and protect the evidence before anyone cleans up.
SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!
My 1900th Post and 31 million views in almost 5 years. To celebrate, a fun FAQ my wife Nupur wrote, like why I started this blog and what it was first called.
Blocking DELETE Without a WHERE Clause Using a Trigger
A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.
A Page of Rows and the Grand Total Count in One Query
One query can give a grid its ten rows and the total for the label. Here is how, plus the empty page trap that catches almost everyone.