Administering Microsoft SQL Server Availability Groups

In this course, you'll learn the critical skills to install, administer, support, and troubleshoot SQL Server Availability Groups. You will cover a variety of environments including Windows, Linux, and Always On, with or without a domain.
Course info
Rating
(24)
Level
Intermediate
Updated
Dec 7, 2018
Duration
3h 4m
Table of contents
Course Overview
Exploring the Capabilities of SQL Server Availability Groups
Building an Always On Foundation for Availability Groups
Establishing an Availability Group
Configuring and Tuning an Availability Group
Monitoring and Troubleshooting SQL Server Availability Groups
Description
Course info
Rating
(24)
Level
Intermediate
Updated
Dec 7, 2018
Duration
3h 4m
Description

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.

About the author
About the author

Currently an IT leader in Denver Colorado's financial sector Russ has focused on database development, modelling, administration, and BI since 1997 across the Microsoft stack. Russ is a passionate trainer and SQL community volunteer presenting regularly at PASS SQL Saturday events and local user groups around the US.

More from the author
More courses by Russ Thomas
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello everyone. My name is Russ Thomas, and welcome to this Pluralsight course, Administering Microsoft SQL Server Availability Groups. First introduced in 2012, availability groups have quickly become the most feature rich and capable solution to SQL Server disaster recovery and high availability scenarios. They also add the ability to scale your read-only workloads, offload backup overhead, and with current versions are supported in Windows, Linux, domain, and non-domain environments. In this course, we'll establish an Always On foundation on a Windows cluster. Then, we'll set up a Linux environment to showcase how flexible availability groups have become. We'll establish a multi-node cluster and show all the configurations and customizations to enable each of your replicas to perform to your exact needs and expectations. By the end of this course, you should be comfortable with most any aspect of availability groups, as well as know where to go for deeper learning and study. Now this feature just keeps getting better, so this course will also include a look into what's coming in SQL Server 2019, all while giving you the skills you need to support, troubleshoot, and monitor SQL Server availability groups right now on whatever your current platform is, be it SQL Server 2012, 14, 16, 17 or 19. I look forward to spending some time together on one of my favorite technologies, SQL Server availability groups.