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.
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.
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.
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.