Advanced SQL Server High Availability & Disaster Recovery

Business continuity is critical for any organization. Ensure your applications remain operational with robust high availability (HA) and disaster recovery (DR) strategies. This course equips you with the knowledge to minimize application downtime through effective HA/DR techniques.

We dive deep into SQL Server high availability and disaster recovery technologies, covering:

• SQL Server Replication: Understand its functionality, monitoring, and troubleshooting.
• AlwaysOn Availability Groups: Explore the benefits, prerequisites, limitations, and implementation of AlwaysOn, a key component of SQL Server HA.
• Log Shipping: Learn about this established disaster recovery solution, commonly used for DR and SQL Server migration.
• HA & DR Topologies: Discover various topologies to build a highly available infrastructure, including hybrid HA/DR solutions.

This course provides practical insights into implementing high availability infrastructure and disaster recovery planning using proven technologies. You'll gain confidence in creating resilient and performant systems.

About the Authors:

Ahmad Osama is a Microsoft Data Platform MVP and Database Engineer at Pitney Bowes Pvt Ltd. He specializes in developing and maintaining high-performance SQL Server environments, CI/CD for databases, and automation. Ahmad is a prolific blogger at dataplatformlabs, with over 100 articles on SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He frequently presents at user group events and webinars.

Gethyn Ellis brings over 18 years of SQL Server experience, with the last 10 years focused on Microsoft Azure. He is a Microsoft certified trainer and consultant, specializing in SQL Server. Gethyn is also an author, having written books on SQL Server Administration and Azure essentials for Packt.