Tag: high availability

SQL Server insights from 25+ years in the field

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

SQL Server 2022 CU27 Released - Key Fixes and What You Need to Know
21 Sep 2026 · 8 min read

SQL Server 2022 CU27 Released - Key Fixes and What You Need to Know

SQL Server 2022 CU27 (build 16.0.4295.3) delivers 41 fixes including critical security hardening, corruption prevention, and HA improvements. Here is what Australian DBAs need to act on.

Read article →
SQL Server 2025 CU9 Released - 44 Fixes Including Critical Security Patches
20 Sep 2026 · 9 min read

SQL Server 2025 CU9 Released - 44 Fixes Including Critical Security Patches

SQL Server 2025 Cumulative Update 9 delivers 44 fixes including serious security hardening across the engine, replication, and enclave components. Build 17.0.5005.3.

Read article →
Preventing SQL Server Downtime: A Practical Guide to High Availability and Expert Support
6 Jul 2026 · 6 min read

Preventing SQL Server Downtime: A Practical Guide to High Availability and Expert Support

When SQL Server goes down, every minute costs you. Learn how to diagnose the problem fast and prevent it from happening again.

Read article →
How to Set Up Mirroring in a Workgroup Using Certificate Authentication
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 →
How to Emulate an SQL Cluster Using Mirroring
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 →
How to Set up DB Mirroring using T-SQL
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 →

SQL Server insights, monthly.

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