Advanced SQL Server High Availability & Disaster Recovery
Learn how to implement high availability and disaster recovery solutions for SQL Server with this comprehensive course. Gain the knowledge and skills to minimize downtime and ensure smooth functioning of your infrastructure. Ideal for DBAs, developers, and professionals looking to enhance their production environment.
What you’ll learn
- Configure and troubleshoot Replication, AlwaysOn, and Log Shipping
- Study the best practices to implement HA and DR solutions
- Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment
- Automate the AlwaysOn setup using PowerShell
- Migrate from On-Premise SQL Server to Azure SQL Database
- Configure and troubleshoot snapshot replication
Business continuity is of utmost importance. High availability (HA) and disaster recovery (DR) ensure that your infrastructure experiences no downtime and smoothly functions at all times. Sound knowledge of various HA and DR techniques help you to drastically reduce the downtime of your applications.
This course begins by explaining the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You’ll learn what they are, how to monitor them, and how to troubleshoot any related problems. You’ll learn how to use different HA and DR topologies to create a highly available infrastructure that also includes hybrid topologies. You’ll learn what is Always On, it’s pros and cons, prerequisites, and restrictions. You’ll also learn about log shipping, one of the oldest SQL Server solutions, which is mostly used for DR and SQL Server migration. Through this course, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies.
By the end of the course, you’ll feel confident and look forward to changing the game with robust and high performing infrastructure.
About the Author
Ahmad Osama works for Pitney Bowes Pvt Ltd as a database engineer and is a Microsoft Data Platform MVP. In his day to day job at Pitney Bowes, he works on developing and maintaining high performance on-premises and cloud SQL Server OLTP environments, building CI/CD environments for databases and automation. Other than his day to day work, Ahmad blogs at dataplatformlabs and has written over 100 blogs, including SQL Server Administration/Development, Azure SQL Database, and Azure Data Factory. He regularly speaks at user group events and webinars conducted by the Dataplatformlabs community.
Gethyn Ellis has over eighteen years of experience with SQL Server and for past ten years he has been working on Azure. He is an Microsoft certified trainer. He also trains and is a consultant for SQL Server. Prior to this he has worked with Packt and written books on “Getting Started SQL Server 2014 Administration” , “Microsoft Azure laaS Essentials”, and Professional Azure SQL Database Administration.
Who this course is for:
- Professional SQL Server High Availability and Disaster Recovery is designed for database administrators, database developers, and application developers, who want to improve the performance of their production environment.