The BAG Secondary

SQL Server 2016 Availability Group - Automatic Seeding with SSMS 17.x

In SQL Server 2016 the availability group automatic seeding functionality is implemented. This article will detail the steps to use of SSMS with automatic seeding and its limitations.

TDE with Automatic Database Seeding

Transparent Data Encryption on an Availability Group and Automatic Database Seeding

Add a SQL Server Database to an Existing Always On Availability Group

In this tip, Manvendra Singh will cover how to add another database to an existing Always On Availability Group.

Automatic Database Seeding

Set up and use the automatic databases seeding feature for Availability Groups.

SQL Server AlwaysOn Availability Groups Using an Azure Template

There is already a template on the Azure marketplace for setting up an AlwaysOn Availability Group. In just a few easy steps you can get a working AlwaysOn Availability Group setup, configured and running - this post describes the steps to quickly set it up.

Add new Databases to a AG Setup with PowerShell

Some short & sweet PS code to add databases on AG Node 1 to AG Node2 and snap them in.

AG Sync Folders

AlwaysON Availability Group and Jobs Part 2

This article will provide the actual implementation of the control mechanism.

AlwaysON Availability Group and Jobs Part 1

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios.