Tag: database mirroring

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 · 7 min read

How to Set Up Mirroring in a Workgroup Using Certificate Authentication

Learn how to set up SQL Server mirroring in a workgroup environment using certificate-based authentication, including optional witness server configuration for automatic failover.

Read article →
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 Set up DB Mirroring using T-SQL

Set up SQL Server database mirroring with T-SQL to bypass GUI edition restrictions and configure synchronous or asynchronous mirroring with a repeatable, scripted process.

Read article →
15 May 2018 · 6 min read

Synchronous Database Mirroring (High-Safety Mode)

Synchronous database mirroring ensures zero data loss by confirming every transaction on both the principal and mirror server before notifying the client. Here is how it works.

Read article →

SQL Server insights, monthly.

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