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.
What you'll learn
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.
Table of contents
- Intro 3m
- Asynchronous and Synchronous Replicas 6m
- Automatic and Manual Failovers 3m
- Availability Group Failover Configuration 6m
- Flexible Failover Policy and Advanced Configuration 2m
- Configuring Read Only Replicas 5m
- Understanding Secondary Read Latency and Isolation Levels 4m
- Configuring Backup Location Models 5m
- Configuring a Listener 4m
- Read Routing URLs and Read Routing Lists 3m
- Overview of Adding AG to a Linux Cluster 3m
- Module Summary and What Remains 2m
- Monitoring and Troubleshooting 3m
- Firewalls, Ports, and Endpoints 4m
- The Availability Group Dashboard 3m
- Latency, Waits, Queues, and Bottlenecks 7m
- Instance Level Object Troubleshooting 5m
- Extended Events 5m
- Policy Based Management 7m
- RPO, RTO, Error Logs, and Health Logs 5m
- Course Summary and 2019 Feature Preview 6m
- Introduction 3m
- Distributed Availability Groups 5m
- Creating Two Availability Groups 5m
- Creating a Distributed Availability Group 6m
- Script Review and Troubleshooting 4m
- Failing Over a Distributed Availability Group 6m
- Failover Cluster Heartbeats and Networks 7m
- Heartbeat Thresholds and Cost Metrics 6m
- PowerShell to the Rescue 6m
About the author
Currently an IT leader in Denver Colorado's financial sector Russ has focused on database engineering, 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. In 2019 much of Russ' focus turned to cloud based data lakes specifically on Google BigQuery.