Create SQL Server 2025 Availability Groups with SSMS Wizard

SQL Server Availability Groups are great for DR and HA purposes. In this article, we look at how to setup a SQL Server 2025 Availability Group using the features in SQL Server Management Studio.

Who is Using CAGs?

Steve wants to know how many of you are using Contained Availability Groups.

SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database

Learn how you can add transactional replication to an AG to move data to an Azure SQL Database.

Changing the AG Listener

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 […]

Managing Underused Indexes in SQL Server Availability Groups – Part 2

Knowing the usage from all workloads is definitely better than focusing on only the primary or a single secondary. But what if I want to make more informed decisions, incorporating row counts, size, and index columns into this output?

Distributed Availability Group Health: T-SQL and Zabbix

Spotting synchronization disconnects between a primary and a secondary data center in a distributed availability group configuration can be hard, so here are valuable tools to help you with it

How to Measure Replication Latency in SQL Server AlwaysOn Synchronous Availability Groups

Synchronous replicas in SQL Server Availability Groups promise no data loss, but they don’t promise zero delay; under heavy load they can still fall behind. This article shows how to measure and track that hidden replication delay using SQL Server performance counters, so you can see how well your system keeps up during IO‑intensive operations and plan maintenance more safely.

Contained Availability Groups in SQL Server 2022

SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively manage the Server Level objects, such as Logins, SQL Agent jobs, etc. in an HA environment. In today's article, we will learn about this new feature of SQL Server. The Challenge of Managing Server Objects in Availability […]

Enable TDE for Databases in a SQL Server AlwaysOn Availability Group

A customer has a database that is already set up in a SQL Server Availability Group. Since this database hosts sensitive data, there is a need to encrypt the primary and all secondary replicas of the data. In this article, we will walk through how this can be done.