We are happy to advise you!
+43 1 6000 880-0     Contact

High Availability with Microsoft SQL Server 2012/2014 (SQHA)

 

Course Overview

In diesem Seminar lernen Sie die unterschiedlichen Varianten von Hochverfügbarkeiten bei SQL Servern kennen. Sie erfahren, unter welchen Voraussetzungen und bei welchen Erfordernissen, welche Technologien geeignet sind. Anschließend an diesen Kurs sind Sie imstande eine Hochverfügbarkeitslösung zu entwerfen, zu implementieren und zu warten.

Who should attend

Dieser Kurs richtet sich an diejenigen,die für Gestaltung und Umsetzung von Hochverfügbarkeitslösungen für SQL Server 2012 verantwortlich sind.

Prerequisites

Vor der Teilnahme an diesem Kurs ist es empfehlenswert, dass Teilnehmer folgende Fähigkeiten besitzen:

  • 1 Jahr SQL Server-Erfahrung (nicht unbedingt SQL Server 2012)
  • 1 Jahr Windows Server 2008 (oder höher) Erfahrung
  • 1 Jahr Hyper-V-Erfahrung
  • 1 Jahr Windows Failover Clustering Erfahrung

Course Content

High Availability Overview
  • Defining High Availability
  • Achieveing High Availiability
Overview of Windows Server Failover Clustering
  • Failover Clustering Concepts
  • Cluster Resources
  • Setting up a Windows Failover Cluster
  • MSDTC Clustering.
SQL Server 2012 High Availability Overview
  • SQL Server 2012 High Availability (HA) Technologies
  • High-level Considerations on Technology Choices
  • Common Combinations
AlwaysOn Failover Clustering
  • SQL Server Failover Clustering - Definitions and History
  • SQL Server 2012 Failover Clustering Instance (FCI)Maintaining a SQL Server 2012 FCI
  • Multi-Site Failover Clustering
AlwaysOn Availability Groups
  • Availability Group Concepts
  • Partners and Secondary Servers
Legacy Database Mirroring
  • Database Mirroring Overview
  • Database Mirroring Architecture
  • Enabling Database Mirroring
  • Database Mirroring Operations
Legacy Log Shipping
  • Log Shipping Overview
  • Log Shipping Architecture
  • Configuring Log Shipping
  • Log Shipping Internals
  • Administering Log Shipping
Using Replication for High Availability
  • Replication Overview
  • Replication Types
  • Replication Architecture
  • Configuring Replication
  • Replication Monitoring
High Availability Solutions Interoperability
  • AlwaysOn Failover Cluster Instances with AlwaysOn Availability Groups
  • AlwaysOn Failover Cluster Instances with Legacy Database Mirroring
  • AlwaysOn Availability Groups with Replication
High Availability with Virtualization
  • Hyper-V in Windows Server 2008 R2
  • Improvements in Windows Server 2012
  • SQL Server Hyper-V Support
  • Hyper-V HA Considerations (Using Cluster Shared Volumes for High Availability, Live Migration, Using Guest Clustering)
Meeting Your Availability Goals
  • Technology Choices
  • Servicing for Availability
  • Ongoing Maintenance (Indexing, Partitioning)
  • Processes and Procedures for Availability (Rule n.1, Understanding the Technologies Used, Understanding the Procedures and Escalation Paths, Planned Downtime)
Online Training

Duration 3 days

Price (excl. tax)
  • 1,552.- €
Digital courseware

Courseware language: English

Classroom Training

Duration 3 days

Price (excl. tax)
  • Austria: 1,552.- €
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Bread
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by iTLS.


Digital courseware

Courseware language: English

Schedule

This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO). Until 30.06. we offer our courses also as online trainings.
Austria
09/12/2020 ― 11/12/2020 Vienna
This is a FLEX course, which is delivered both virtually and in the classroom. All FLEX courses are also Instructor-led Online Trainings (ILO). Until 30.06. we offer our courses also as online trainings.
German
Time zone CEST
09/12/2020 ― 11/12/2020 Online Training Time zone: Central European Time (CET) Course language: German