An Availability Group is the most advanced and feature-rich approach to both high availability and disaster recovery in SQL Server. In this course, Administering Microsoft SQL Server Availability Groups, you will learn foundational knowledge and the ability to install, support, administer and troubleshoot Availability Groups. First, you will learn to establish an Always On foundation for this feature. Next, you will discover how easy it is to install Availability Groups. Finally, you will explore how to customize your installation, address specific needs, and troubleshoot unexpected issues. When you’re finished with this course, you will have the skills and knowledge of SQL Server Availability Groups needed to comfortably consider this feature for your most critical SQL Server databases and applications.
Author Name: Russ Thomas
Author Description:
Currently an IT leader in Denver Colorado’s FinTech sector Russ has focused on database engineering, modelling, administration, and BI since 1997. Russ is a passionate trainer and community volunteer presenting regularly at tech events and local user groups around the US. In 2019 much of Russ’ focus turned to cloud based data lakes specifically on Google BigQuery, and the emerging world of large language models.

Table of Contents

• Course Overview
  1min
• Exploring the Capabilities of SQL Server Availability Groups
  21mins
• Building an Always On Foundation for Availability Groups
  45mins
• Establishing an Availability Group
  24mins
• Configuring and Tuning an Availability Group
  45mins
• Monitoring and Troubleshooting SQL Server Availability Groups
  45mins
• Advanced Networking and Distributed Availability Groups
  48mins