HomeOn-Demand LearningSQL ServerSQL Server High Availability

SQL Server High Availability


What Will You Learn?

  • To understand basic high availability terminology
  • How to set up and configure a high availability solution
  • How to monitor your high availability solution


High availability is a broad term used and misused throughout on and offline discussions about uptime and application availability. For the DBA, it is critical to understand this topic and the technological underpinnings of the high availability options Microsoft provides within SQL Server. This course will begin by explaining key terms and concepts surrounding the idea of high availability. Following that, every SQL Server high availability option will be discussed and demoed. By the end of the course, students will have a firm idea of what high availability tools are presented within SQL Server, as well as how to deploy those tools.



Dan Taylor started his DBA career at Nielsen Media Research Company working with Sybase ASE 11 through 12.5, Sybase IQ, eventually moving to SQL Server. Post Nielsen Media Research, Dan worked for Publix Supermarket, a Forbes recognized industry leader, Forbes Top 100 Best Places to Work, and top in customer service and satisfaction. Following Publix, Dan worked at New York Life, which is recognized as a Fortune 500 company, Fortune 500 Global company, and recognized as top 50 company for diversity. Outside of work, he was also the Tech Editor for the Professional Microsoft SQL Server 2014 Administration Guide. Dan has worked with SQL Server versions from 7.0 to 2016. You can find him on Twitter as @DBABullDog, on LinkedIn, and at dbabulldog.wordpress.com. A former consultant with Pragmatic Works, Dan is currently working at Microsoft.


What to Know Before the Class

A basic understanding of working with SQL Server is necessary. We recommend first taking our DBA Fundamentals course.

Curriculum For This Course

System Requirements

  • To run these labs, you must have Windows Server 2012 R2, SQL Server 2016 Enterprise or Developer and Standard Edition.
  • Your computer should meet the following requirements:
  • Restore the WorldWideImporters database backup found in the course files

You may also like…