SQL Server High Availability
On-Demand Training

Starting At: $395
On-Demand Training
Call Us At: (904) 413-1911

Pragmatic Works On-Demand Training gives you the ability to learn from industry experts at your own pace. Our courses cover a variety of topics including Business Intelligence, Business Analytics, Big Data, SQL Server Optimization and more.

SQL Server High Availability
Per User Per Year
Unlimited Elite Pack


Per User Per Year
Free Trial

Unlimited Elite Pack $100 off through March 31th.


Thanks for reporting a problem. We'll attach technical data about this session to help us figure out the issue. Which of these best describes the problem?

Any other details or context?


Course Details

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 demo-ed. 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.

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


A basic understanding of working with SQL Server is necessary. We recommend first taking our DBA Fundamentals 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

Curriculum For This Course


Dan Taylor


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 read his blogs for Pragmatic Works and at dbabulldog.wordpress.com. Currently, Dan is a Lead Consultant with Pragmatic Works.

Related Courses

Course Info
8 Comprehensive Modules
13 Effective Quizzes
Access on Mobile and TV
Certificate of Completion
3h 7m
Download Syllabus
Enrollment Price:

Share this course with your friends