Always-On Availability Groups Boot Camp

Always On Availability Groups (AGs) is the most popular class for those who want highly available databases in a SQL Server instance, whether it is on Windows Server or Linux. With AGs coming to Standard Edition in SQL Server 2016, it is more important than ever for everyone to understand how to plan, deploy, and administer AGs as anyone implementing SQL Server can now take advantage of this key feature.

SQLHAU^®’s immersive Always On Availability Groups Boot Camp prepares attendees for success no matter which version of SQL Server (2012 to 2017) that you are using.

Over the course of 3 days, students will learn:

• How AGs work and the most common usage patterns for both high availability and disaster recovery
• The differences between the AG variants
• How AGs are different from the other SQL Server availability features, and why AGs still matter in a world with virtualization and the public cloud
• How to design AG solutions whether they are on premises (physical or virtual) or in the public cloud including:
  • Proper Windows Server Failover Cluster or Pacemaker design for AG deployments, including how to deal with quorum
  • Network design, including how virtualized and cloud-based deployments are different
• How to deal with the Microsoft Distributed Transaction Coordinator
• How to take advantage of the additional capabilities offered by AGs such as backups and read only replicas
• When and how to take advantage of Distributed AGs
• How to monitor and troubleshoot AGs
• A preview of what is coming in SQL Server 2019
• Best practices, tips, and tricks that can be put to use immediately

No boot camp would be complete without actual experience. Each student gets their own lab environment with virtual machines to work through lab exercises specifically designed to reinforce the instructional content and experience real world scenarios. Where possible, the lab exercises offer multiple levels of difficulty since we recognize students’ experience with AGs varies.

Whether you are an accidental DBA or new to SQL Server, looking to brush up your existing skills, or just want to learn the latest and greatest around Availability, there is no better class than Always On Availability Groups Boot Camp. You will learn about AGs from one of the world’s recognized experts, authors, and presenters on SQL Server high availability, Allan Hirt, who has been using them since the private early adopter program of SQL Server 2012.