This 3/400 level, 2-day, SQL Server training class will teach you how to plan for, implement, and maintain AlwaysOn Failover Clustered Instances and AlwaysOn Availability Groups in SQL Server 2012 and higher using best practices and real-world experience.
The class will start by explaining Windows Server Failover Clustering, which is the basis of both AlwaysOn features in SQL Server; Failover Clustered Instances and Availability Groups. Then each feature will be examined in depth to understand the considerations, requirements, and best practices behind their implementation, so you can build a rock-solid high-availability and/or disaster-recovery strategy for your SQL Server workload.
High Availability is an area that is critical in today’s environment and all DBAs should be able to design and implement an appropriate availability strategy and coordinate a successful recovery after a disaster.
Instructors: Jonathan Kehayias
Module 1: Windows Server Failover Clustering Essentials
The foundation on which SQL Server AlwaysOn Failover Clustered Instances and AlwaysOn Availability Groups are built is Windows Server Failover Clustering, and in this module we’ll build a solid foundation of understanding the requirements and best practices for failover clusters within Windows. Topic covered include:
Module 2: AlwaysOn Failover Clustered Instances
Deploying a Failover Clustered Instance (FCI) for SQL Server has long been a mainstay of SQL Server high availability strategies. Whether you’ve never implemented an FCI of SQL Server, or you’ve been doing it for years, this module will cover what’s changed in SQL Server for FCIs and how to implement them as a part of an availability strategy for SQL Server. Topics covered include:
Module 3: AlwaysOn Availability Groups
Availability Groups are one of the hot topics for SQL Server thanks to a very successful marketing approach by Microsoft, starting with their introduction in SQL Server 2012. Availability Groups replace and enhance the capabilities of database mirroring, and have added new functionality with each release of SQL Server. Topics covered include:
Module 4: Implementation Case Studies
One of the best was to learn how to implement (and how not to implement!) SQL Server high availability solutions is to look at example implementations and understand the factors and decisions that lead to how things were configured. This module will use real-world case studies to highlight both successful implementations along with failed implementations (where SQLskills was brought in to mitigate the problems in the original implementation). Topics covered include:
If you have any questions not answered by our F.A.Q., please contact us.