SQL Server High Availability

£395.00

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

Category:

DESCRIPTION

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.

INSTRUCTOR

DAN TAYLOR

DBA
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.


Duration: 2:47:05
High Availability is a broad term used and misused throughout online and offline discussions about up-time 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 and, by the end of 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.
High Availability - What you need to get started
Module 01 - Introduction to High Availability
11:45
Module 02A - Replication (Snapshot Replication)
35:18
Module 02B - Replication (Transactional Replication)
10:26
Module 02C - Replication (Monitor Replication)
09:27
Module 02D - Replication (Summary)
05:29
Module 03A - Log Shipping (Setting Up Log Shipping to Single Secondary)
14:14
Module 03B - Log Shipping (Setting Up Log Shipping Monitor Server)
07:14
Module 04 - Database Mirroring
16:47
Module 05 - Windows Server Failover Cluster
16:23
Module 06A - Availability Groups (Setup and Configuration)
18:18
Module 06B - Availability Groups (Additional Considerations)
09:34
Module 07 - Basic Availability Groups
12:44
Module 08 - Clustering SQL Server
19:19
Class Survey

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