Tag: sql server 2008

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 6 min read

How to Emulate an SQL Cluster Using Mirroring

Learn how to emulate coordinated SQL cluster failover using database mirroring, covering Service Broker setup, WMI event monitoring, and T-SQL logic for pre-2012 environments.

Read article →

15 May 2018 · 6 min read

How to Fix Performance Dashboards for SQL 2008

Learn how to apply Microsoft's compatibility update to get the SQL Server 2005 Performance Dashboard working correctly against SQL Server 2008 and 2008 R2 instances.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.