The Connection to the Primary Replica is not Active

In this article, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group.

Step by Step Configuring a Dedicated Network for Availability Group

In this article, I will show a procedure to isolate the replication traffic from the public network.

Step by Step Configuring AlwaysOn with Log Shipping

In this article, I will show you a procedure to combine SQL Server AlwaysOn with logshipping and to make log-shipping to work even in case of failovers between availability replicas in primary site.

It Just Runs Faster - AlwaysOn Compression

Office Hours Webcast 2017/02/01

In this edition of Office Hours, Brent, Erik, and Richie discuss AlwaysOn Availability Groups, execution plans, speeding up log shipping, applying wrong service packs, their favourite high availability solutions, and more.

AG Commit Modes

Configure SQL Server AlwaysOn Availability Group on a Multi-Subnet Cluster

A “multi-subnet” environment is defined when the OS cluster used as the backbone for AlwaysOn has server nodes that are located in multiple/different subnets. Deploying SQL Server AlwaysOn Availability Groups requires a Windows Server Failover Clustering (WSFC) cluster and each availability replica of a given availability group must reside on a different node of the same WSFC cluster. This post from Manvendra Singh will help you in configuring an HA and DR solution for SQL Server AlwaysOn in multi-subnet networks.

Basic AG Secondaries

Standard Availability Groups

Maintenance Routines for AlwaysOn

How to determine what replica(s) to perform maintenance routines