fbpxl

CURSO: SQL Server High Availability

Gain an in-depth look into SQL Server High Availability technologies and their usage

Developed in-house by SolidQ, the high Availability course provides an in-depth review of SQL Server High Availability, including concepts for HA, drill-through of the various technologies available with SQL Server, and how to implement high availability using those technologies. Troubleshooting and operational guidance will also be provided.

COURSE DELIVERY OPTIONS

3-DAYS CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

PRIVATE ONSITE

The course will take place in your companie’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request quote here!

“You’ve opened my eyes and helped me re-discover the passion I have for solving problems using creative and efficient methods”

Course Coverage

This course is designed for those responsible for designing and implementing high availability solutions for SQL Server 2014. 1 year of SQL Server experience and 1 year of Windows Server 2012 (or later) experience are needed. We also recommend 1 year of Hyper-V experience and 1 year of Windows Failover Clustering experience.

j

Design a SQL Server 2012 availability solution to meet their availability goals

E

Implement system maintenance while understanding the availability implications

Implement that design using the available technologies in SQL Server 2012

R

Troubleshoot problems with High Availability in SQL Server 2012

COURSE OUTLINE

Module 01: High Availability Overview

  • Defining High Availability
  • Achieving High Availability

Module 02: Overview of Windosw Server Failover Clustering

  • Failover Clustering Concepts
  • Cluster Resources
  • Setting up a Windows Failover Cluster
  • MSDTC Clustering
  • LAB: Creating Your Windows Server Failover Cluster

Module 03: SQL Server High Availability Overview

  • SQL Server High Availability (HA) Technologies
  • High-level Considerations on Technology Choices
  • Common Combinations

Module 04: AlwaysOn Failover Clustering

  • SQL Server Failover Clustering – Definitions and History
  • SQL Server Failover Clustering Instance (FCI)
  • Maintaining a SQL Server FCI
  • Multi-Site Failover Clustering
  • MSDTC Clustering
  • LAB: Installing a Two-Node Failover Clustered SQL Server and Analysis Services Installation

Module 05: AlwaysON Availabilty Groups

  • Availability Group Concepts
  • Partners and Secondary Servers
  • LAB A: Creating an Availability Group Hosted on Three Servers: Primary, Synchronous Secondary, and Asynchronous Secondary
  • LAB B: Database Backups for Secondary Replicas: Creating Automated Database Backups on All Secondary Replicas

Module 06: Legacy Database Mirroring

  • Database Mirroring Overview
  • Database Mirroring Architecture
  • Enabling Database Mirroring
  • Database Mirroring Operations
  • LAB: Enabling Database Mirroring Between Two Servers

Module 07: Legacy Log Shipping

  • Log Shipping Overview
  • Log Shipping Architecture
  • Configuring Log Shipping
  • Log Shipping Internals
  • Administering Log Shipping
  • LAB: Enabling Log Shipping Between Two Servers

Module 08: Using Preplication for High Availability

  • Replication Overview
  • Replication Types
  • Replication Architecture
  • Configuring Replication
  • Replication Monitoring
  • LAB: Enabling Transactional Replication with Three Servers

Module 09: High Availabiltiy Solutions Interoperability

  • AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
  • AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
  • AlwaysOn Availability Groups with Replication
  • LAB: Creating AlwaysOn Availability Groups Running a Primary Replica on an AlwaysOn Failover Cluster Instance

Module 10: High Availability with Virtualization

  • Hyper-V in Windows Server 2012 R2
  • Improvements in Windows Server 2012/R2
  • SQL Server Hyper-V Support
  • Hyper-V HA Considerations
    • Using Cluster Shared Volumes for High Availability
    • Live Migration
    • Using Guest Clustering

Module 11: Meeting Your Availability Goals

  • Technology Choices
  • Servicing for Availability
  • Ongoing Maintenance
    • Indexing
    • Partitioning
  • Processes and Procedures for Availability
    • Rule No.1
    • Understanding the Technologies Used
    • Understanding the Procedures and Escalation Paths
    • Planned Downtime

Would you like to register for this course?

Fill out the form at the top of this page

Invite & Earn

X
Signup to start sharing your link
Signup