Steps for Installing AlwaysOn Availability Groups - SQL 2019

With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made.  This article is an update to another article, and will cover the prerequisites and steps for installing AlwaysOn in your SQL Server 2019 environment. Prerequisites Before implementing your AlwaysOn Availability Group (AG), make sure […]

Non AG Aware

Make SQL Server Agent Jobs HADR Aware

Introduction Always On Availability Groups (AGs/AG...

Enabling Container Availability Groups

Availability Groups with Docker Containers

Build a SQL Server AlwaysOn environment with docker

Adding a Database with Polybase External Tables to Always On Availability Group

Learn how to ensure your PolyBase objects are accessible from all nodes in an Availability Group.

Have You Deployed an Availability Group?

Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.

A Step by Step Guide to the Availability Group (AG) Listener

Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]

The Curious Case of… very long failover times with a large ad hoc workload

In this case, the cause of the long failover time was enabling Query Store after upgrading, for a database with a large workload of ad hoc queries, meaning there was 100GB of Query Store data to load.

Building an AG