Database Platforms, Tuning, and Administration, Workshops

DPM02 Workshop: SQL Server and Azure SQL - Architecting for High Availability

11/16/2026

8:30am - 5:30pm

Level: Intermediate

Denny Cherry

Owner and Principal Consultant

Denny Cherry & Associates Consulting

In this day-long pre-con session we will explore the various high availability options within SQL Server including how to configure these various options. We will be looking into Windows and SQL Server Clustering (including what is needed for a geographically dispersed cluster), Database Mirroring, The Always On Availability Group features, and SQL Server Log Shipping.

In addition to working through these high availability options, we will be discussing the most important part of high availability configuration, making sure that you know how to select the correct high availability solution. After completing this high availability pre-con workshop, you'll be able to make the correct decision about which high availability decision to deploy, as well as how to correctly deploy the selected solution.

You will learn:

  • About Failover Clusters
  • About Database Mirroring
  • About AlwaysOn Availability Groups