AutomatedLab, a PowerShell framework for generating basic or advanced lab environments on Azure or Hyper-V by just using a PowerShell script.

When setting up a SQL Server Always On Availability Group with a clustered user database in an entirely automated process, the traditional approach would involve manually configuring the basic environment (AD, DNS, DHCP, etc.), followed by the manual installation and configuration of Microsoft SQL Server. This method is time-consuming and requires various prerequisites to be considered before the main goal can be tackled.

Fortunately, AutomatedLab streamlines this procedure by effortlessly deploying not only basic workloads like Active Directory Domain Services but also complex ones like Microsoft SQL Server.

In this session, you will receive a brief introduction to AutomatedLab, create the necessary preconfigured virtual machines for the task, and explore three different methods of installing a Microsoft SQL Server Always On Availability Group and adding a database to it. These methods are the imperative approach utilizing dbatools, a declarative method using PowerShell DSC v2, or the alternative to install both SQL Servers through AutomatedLab and convert them into an Always On Availability Group.