This session: 30 Nov - 4 Dec 2026
This Building and Managing High Availability Solutions With SQL Server 2022 session in Lyon (France) runs from Monday 30 November to Friday 4 December 2026 (week 49, Q4 2026). It is the only date in Lyon (France) in 2026, at a fee of £5,900, the same for each of them. Registration is open for this date. It is held in person.
| Dates | Monday 30 Nov – Friday 4 Dec 2026 |
|---|---|
| Week | 49 of 2026 |
| Duration | One week |
| Fee | £5,900 |
| Status | Open for registration |
| Format | In person |
Introduction
This intensive course is designed to provide participants with advanced knowledge and practical skills in building and managing high-availability solutions using SQL Server 2022. Through a blend of theoretical discussions, hands-on exercises, and real-world scenarios, participants will gain in-depth insight into the latest features, SQL Server 2022 changes, and best practices to ensure maximum availability, reliability, and resilience for critical databases.
With the evolution of SQL Server 2022 versions and the introduction of new features, understanding how to configure, deploy, and maintain high-availability environments is crucial for IT professionals. Whether you’re working with SQL Server 2022 editions or exploring SQL Server 2022 build versions, this course equips you with the knowledge to meet business continuity goals effectively.
Course Objectives
- Understand high availability and disaster recovery (HA/DR) concepts within the context of SQL Server 2022.
- Explore advanced features and new enhancements in SQL Server 2022 to improve high-availability solutions.
- Learn to design and implement high-availability architectures that align with SQL Server 2022 requirements and specific business needs.
- Master the configuration and management of Always On Availability Groups for seamless failover and data protection.
- Gain skills in using SQL Server 2022 features like Failover Clustering and Log Shipping to secure high availability.
- Develop expertise in monitoring, troubleshooting, and optimizing solutions to ensure peak performance.
- Learn SQL Server 2022 best practices for maintaining and updating high-availability environments.
- Prepare for real-world challenges in deploying and managing SQL Server 2022 high availability solutions.
Course Outlines
Day 1: Introduction to High Availability Concepts
- Overview of high availability and disaster recovery (HA/DR) concepts.
- Understanding the importance of high availability in modern database environments.
- Review of SQL Server 2022 features, including updates related to high availability.
- Introduction to what is SQL Server 2022 and its role in enterprise environments.
Day 2: Always On Availability Groups
- In-depth exploration of Always On Availability Groups architecture in SQL Server 2022.
- Configuring and setting up Availability Groups using SQL Server 2022 Configuration Manager.
- Managing Availability Group replicas, failover modes, and ensuring data protection.
- Monitoring and troubleshooting Availability Groups using SQL Server 2022 reporting services.
Day 3: Failover Clustering
- Introduction to Failover Clustering in SQL Server 2022.
- Configuring and managing Failover Clusters for high availability.
- Understanding quorum models and configurations to ensure reliability.
- SQL Server 2022 best practices for deploying Failover Clustering in production environments.
Day 4: Log Shipping and Database Mirroring
- Overview of Log Shipping and Database Mirroring techniques in SQL Server 2022.
- Configuring and managing Log Shipping for disaster recovery.
- Implementing Database Mirroring for high availability and seamless failover.
- Comparing Log Shipping, Database Mirroring, and Always On Availability Groups in different SQL Server 2022 editions.
Day 5: Advanced Topics and Best Practices
- Performance tuning and optimization for SQL Server 2022 high availability solutions.
- Using automation and scripting for managing high-availability environments.
- Disaster recovery planning and testing in SQL Server 2022 lifecycle.
- Exploring future trends and innovations in SQL Server 2022 high availability.
Why Attend This Course: Wins & Losses!
- Master advanced features and SQL Server 2022 best practices for high-availability environments.
- Gain hands-on experience with SQL Server 2022 configuration manager and reporting tools.
- Enhance your ability to troubleshoot and optimize SQL Server 2022 high availability solutions.
- Prepare for SQL Server 2022 certification with comprehensive training and real-world applications.
- Understand the nuances of different SQL Server 2022 versions and how they impact high-availability solutions.
Conclusion
This comprehensive course on SQL Server 2022 high availability equips participants with the knowledge and skills to design, implement, and manage robust database solutions. From setting up Always On Availability Groups to mastering Failover Clustering and Log Shipping, attendees will gain practical expertise in ensuring seamless workflow and data resilience. Whether you're preparing for SQL Server 2022 certification or looking to optimize your organization's database infrastructure, this course offers the essential training to excel in the evolving landscape of SQL Server 2022.
Join us to become a leader in SQL Server 2022 high availability and take your database management skills to the next level!
Good to know
How long is the course, and what are the daily hours?
This date lasts one week: 30 Nov - 4 Dec 2026. A one-week course is 20 hours over 5 days: 4 hours each training day (9am – 1pm). Timing and duration can be customised to your needs.
From the FAQ: What is my daily training agenda?
Which language is the course taught in?
Courses are offered in English and Arabic. The course language is officially English; on request, it can be delivered in Arabic while keeping the English terms.
From the FAQ: In which language do you offer your training courses?
Will I receive a certificate?
Yes. At the end of the course you receive the course certificate issued by BlackBird Training, with an online QR code to verify it.
From the FAQ: Do I receive the certificate at the end of the course?
How do I book, and when do I pay?
Choose Apply now and fill in the form; we guide you through the rest. The acceptance letter is sent within 24 hours of your registration. Payment is due at least 10 days before the course starts, online by credit card or by bank transfer.
From the FAQ: How can I register for a training course in BlackBird?, When do I get my Acceptance Letter?, When do I need to pay?, How can I pay for the course?
Can I cancel or send a colleague instead?
You can send a replacement delegate if you tell us one week before the course starts. Cancellation and refund terms are set out in the cancellation policy.
From the FAQ: Can I send a replacement delegate?
Enquire about this date
Building and Managing High Availability Solutions With SQL Server 2022, Lyon (France), 30 Nov - 4 Dec 2026