All Brands   >   Microsoft   >   Microsoft SQL Server   >   Designing and Managing High Availability Solutions with SQL Server 2017

CMDBID: 108102 | Course Code: SQL TPHASQLS | Duration: 3 Days
Overview >
  • In this course, you will learn basic aspects of High Availability as a Recovery Point Objective, Recovery
  • Time Objective, measuring HA in percentage of time etc. Then you will get a brief overview of HA features introduced in Windows Server 2012 R2/2016, which are relevant for SQL Server solutions -
  • domain/domainless WFCS, cluster shared volumes, scale-out file services, storage spaces, storage replica, Hyper-V, etc. From the SQL Server perspective, the course will focus on the most popular HA/DR features - Failover Clustering and Availability Groups.

In the Failover Clustering part, you will learn details on how to design highly available SQL Server solution from the perspective of storage; Quorum and Failover Cluster Instance. From a practical point of view, you will learn how to maintain and troubleshoot an FCI solution.

In the Availability Group part, you will learn details on how to design AG solution with custom requirements; quorum configurations and AG configuration (sync/async, read only routing, read only load balancing, direct seeding, hybrid AG, etc.). Similar to Failover Cluster Instances, in the practical part you will learn how to monitor an AG solution In addition, along the course you will also learn on interoperatibility of another SQL Server technologies with SQL Server HA - Integration Services, Analysis Services and Reporting Services.

Skills >
Outline >

Course Dates

Search by:

Show only GTR courses

Page 1, showing results 1-25 out of 39
Location
Start Date
Price
LVC, United Kingdom
19th Oct 2020
£1795
LVC, United States
19th Oct 2020
$2700
LVC, Australia
19th Oct 2020
$3900
LVC, New Zealand
19th Oct 2020
$3900
LVC, New Zealand
19th Oct 2020
$3900
LVC, France
19th Oct 2020
€2400
LVC, Germany
19th Oct 2020
€2400
LVC, Spain
19th Oct 2020
€2400
LVC, Italy
19th Oct 2020
€2400
LVC, Australia
19th Oct 2020
$3900
LVC, Australia
19th Oct 2020
$3900
LVC, United States
19th Oct 2020
$2700
LVC, United States
19th Oct 2020
$2700
New York, United States
9th Nov 2020
$2700
Wellington, New Zealand
9th Nov 2020
$3900
Auckland, New Zealand
9th Nov 2020
$3900
San Francisco, United States
9th Nov 2020
$2700
Canberra, Australia
9th Nov 2020
$3900
Paris, France
9th Nov 2020
€2400
Milan, Italy
9th Nov 2020
€2400
Chicago, United States
9th Nov 2020
$2700
Berlin, Germany
9th Nov 2020
€2400
Melbourne, Australia
9th Nov 2020
$3900
Sydney, Australia
9th Nov 2020
$3900
Madrid, Spain
9th Nov 2020
€2400

Thinking about Onsite?

If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. Its a cost effective option. One on one training can be delivered too, at reasonable rates.

Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.

All $ prices are in USD unless it’s a NZ or AU date

SPVC = Self Paced Virtual Class

LVC = Live Virtual Class

Please Note: All courses are availaible as Live Virtual Classes