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.

Migrate from Linux to Windows with Availability Groups

This article describes the process to create a read-scale cross-platform SQL Server Availability Group where the primary is Linux and the secondary is Windows.

SQL Server 2022 Clusterless Distributed Availability Group

This article shows the final step of an availability group creation, specifically for a distributed clusterless one.

Secondary Query Store

AG Rules for Databases