We provide virtual course about MasterClass: SQL Server High Availability and Disaster Recovery med Magi Naumova in english. This MasterClass focuses on advanced high availability (HA) and disaster recovery (DR) strategies for Microsoft SQL Server.
Course description:
Led by expert Magi Naumova, the course dives deep into practical techniques, architecture patterns, and real-world implementations that ensure resilient and reliable SQL Server environments. In this MasterClass, you’ll build on foundational database administration and explore how to design, configure, and maintain SQL Server systems that remain available even in the face of failures, outages, or disasters. Through case studies, demonstrations, and interactive discussions, you’ll learn how enterprise organizations approach HA and DR with confidence.
Technical Level: 300+
Versions covered:
The course covers all versions of SQL Server from 2016+ and later, including SQL Server 2022. The lab exercises will be on SQL Server 2019.
Key takeaways:
After completing this course, participants will be able to:
• Understand high availability vs. disaster recovery principles
• Design SQL Server HA/DR topologies
• Configure and manage Always On Availability Groups
• Implement failover clustering and replication strategies
• Monitor and validate HA/DR solutions
• Plan and test disaster recovery scenarios
• Understand backup strategies with minimal downtime
• Apply real-world best practices from industry experience
Course outline:
Module 1 - High availability principles:
• Participants are introduced to the theory and motivations behind HA and DR, including terminology, service level expectations, and risk analysis.
Module 2 - Always On Availability Groups:
• This section covers configuration and management of Availability Groups, including replicas, synchronization, read-only routing, and listener setup.
Module 3 - Failover clustering:
• Learn how SQL Server failover clustering works, including Windows Server Failover Clustering (WSFC), quorum models, and clustered instance setup.
Module 4 - Replication strategies:
• Explore SQL Server replication models and how they can be used as part of a DR strategy in specific scenarios
Module 5 - Backup and restore for HA/DR:
• Understand how advanced backup strategies support HA/DR objectives, including point-in-time recovery, differential, transactional backups, and backup best practices.
Module 6 - Monitoring and testing HA/DR:
• Participants learn how to monitor health and performance of HA/DR configurations and how to test failover and recovery plans without impacting production.
Module 7 - Disaster recovery planning:
• This topic focuses on DR planning workflows, documentation, testing, and communication strategies before, during, and after an outage.
Module 8 - Troubleshooting real-world scenarios:
• Through examples and case studies, participants troubleshoot common issues and learn how to respond to real HA/DR challenges.
Instructor: Magi Naumova
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field - Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valuable Professional). She has more than 20 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area.
Currently she works as a Managing Partner and Chief SQL Architect of Inspir-it AS, her own newly established Consulting Company in Norway. Margarita is a regular speaker at the largest IT events, SQLBits, SQL Saturday in Europe.
Target audience:
• SQL Server Database Administrators
• Systems Engineers
• Cloud Database Architects
• IT Infrastructure and Operations Professionals
• Anyone responsible for SQL Server uptime and reliability
Prerequisites:
Recommended:
• Experience with SQL Server administration
• Knowledge of basic SQL Server infrastructure concepts
• Familiarity with backup and restore models
Participants should be comfortable with database fundamentals
Language:
• English course material and english speaking instructor
Course material:
The course fee includes course documentation and labs