Prevent lost updates with optimistic concurrency and a rowversion token, detect zero-row conflicts, and compare short locking transactions.
Caching Query Results in the Application
Caching query results in the application can reduce repeated reads when ownership, expiry, invalidation, and memory cost are clear.
SQL SERVER – Three DMVs – sys.dm_server_memory_dumps – sys.dm_server_services – sys.dm_server_registry
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.
SQL SERVER – SQLPASS Memory Lane of 2009 and 2010
My SQLPASS memory lane: links to my notes and experiences from SQLPASS 2009 and 2010 in Seattle, shared on the last day of SQLPASS 2011.
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.