Tag: Features

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Two Messaging Systems That Run Quietly Until They Don’t Service Broker and Database Mail are both messaging infrastructure, and both are easy to forget are even active, since SQL Server uses Service Broker internally for things like Availability Group health checks, and Database…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Two Things That Break Silently at Migration or Decommission Time Two checks that rarely matter until the exact moment they do: does this database’s collation match the server’s (and every other database it might join against), and does anything in this database reach…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Where Compression Actually Pays Off Row and page compression trade CPU for storage and I/O, and that trade is worth making on some tables and not others. The biggest, least-frequently-updated tables are usually the best candidates: maximum space and I/O savings, minimal CPU…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. Two Features, Same Risk: They Both Grow the Transaction Log Change Data Capture and Change Tracking answer a similar question, “what changed and when,” for two different audiences, ETL/replication consumers for CDC, application-level conflict detection for Change Tracking. They’re unrelated under the hood,…

🔧Part of the DBA-Tools Project, copy/paste SQL Server scripts and health checks. What’s Actually Running on a Server You Just Inherited Extended Events sessions are easy to lose track of. Someone sets one up to chase a specific problem, the problem gets fixed, and the session keeps running quietly forever. On a server you’ve just…