This MasterClass focuses on advanced high availability (HA) and disaster recovery (DR) strategies for Microsoft SQL Server. 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.
About the 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.
Read more about Magi at Microsoft MVP website
High availability principles
Participants are introduced to the theory and motivations behind HA and DR, including terminology, service level expectations, and risk analysis.
Always On Availability Groups
This section covers configuration and management of Availability Groups, including replicas, synchronization, read-only routing, and listener setup.
Failover clustering
Learn how SQL Server failover clustering works, including Windows Server Failover Clustering (WSFC), quorum models, and clustered instance setup.
Replication strategies
Explore SQL Server replication models and how they can be used as part of a DR strategy in specific scenarios.
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.
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.
Disaster recovery planning
This topic focuses on DR planning workflows, documentation, testing, and communication strategies before, during, and after an outage.
Troubleshooting real-world scenarios
Through examples and case studies, participants troubleshoot common issues and learn how to respond to real HA/DR challenges.
Practical information
- Duration: 3 days
- Price: 20 000 NOK
- Language: English material, instruction in English
- Format: Available as open enrollment or in-company training
We arrange this training for your company or departement upon request. Please contact us for dates and prices: itpro@glasspaper.no
FAQ
Is this course suitable for beginners?
No. This is an advanced MasterClass meant for professionals with prior SQL Server experience.
Will I need to bring my own laptop?
Yes. For hands-on portions you will need your own laptop with remote lab access.
Does this prepare me for a certification exam?
No. This is a MasterClass focused on practical skills and not tied to a specific certification.
What level of SQL Server experience is expected?
Participants should have a solid understanding of SQL Server fundamentals and prior administrative experience.
Will this cover cloud-based HA/DR?
Yes. The concepts and patterns include both on-premises and cloud-friendly approaches.
Relevant courses
Other subject areas
Key takeaways
Prerequisites
Target audience
