New
12/11/2026 Database Mirroring Network Compression: What SQL Server Documents and How to Verify It
Database mirroring sends log records to the mirror with no documented compression switch. See which DMVs verify traffic and session state.
Administration & Monitoring
Operational notes for SQL Server instances: high availability, mirroring, and blocked process reports. Find T-SQL setup steps, DMV checks, and guidance for verifying behaviour on your own server. Aimed at DBAs who maintain SQL Server 2016 and later.
2 articles
New
11/11/2026 Event Notifications Blocked Process SQL Server: End-to-End Setup
Use Event Notifications to capture blocked process reports in SQL Server. T-SQL setup for the threshold, Service Broker queue, and reading the XML.