Global - (+34) 91 414 89 50 | N. America - (800) 757 6543 contact@solidq.com

CURSO: High Availability Solutions with SQL Server

Durante el curso aprenderás los conceptos básicos para crear una solución de alta disponibilidad (HA), además de las amenazas potenciales a las que la plataforma se puede enfrentar. Aprenderás cómo instalar Windows Server 2016, mantenerlo, monitorear y resolver los posibles problemas de la solución.

Crea una solución confiable de alta disponibilidad con Windows Server 2012 R2 / 2016 y SQL Server 2014/2016

Administra una solución de alta disponibilidad con Windows Server 2012 R2 / 2016 y SQL Server 2014/2016

Desarrolla soluciones de recuperación de desastres

Soluciona problemas con alta disponibilidad en SQL Server 2016 y 2014

MODALIDADES DEL CURSO

3 DÍAS CLASE PRESENCIAL

El curso está programado para cursarlo en una sala con aforo de máximo 20 personas para poder atender a todas las personas asistentes adecuadamente.

CLASES ONLINE EN DIRECTO

Esta formación es online 100% guiada por un mentor, contestará a tus preguntas y resolverá tus dudas en tiempo real. Podrás cursarlo en varias sesiones.

FORMACIÓN PRIVADA

Esta modalidad permitirá a tu empresa poder contratar la formación de manera privada para que asista todo tu equipo.

Solicitar presupuesto

COURSE OUTLINE

BUILDING AND MANAGIN HA SOLUTIONS WITH SQL SERVER

Module 01: Introduction to High Availability

  • Basic aspects of High Availability

Module 02: Windows Server 2016 High Availability Features Overview

  • Overview of HA features in Windows Server 2016

Module 03: SQL Server 2016 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

Module 04: Windows Server 2016 Failover Clustering

  • Installation
    • Storage configuration
    • Quorum configuration
  • Maintenance
    • Patching/Upgrading
    • Adding/Removing nodes to/from cluster
  • Monitoring
  • Troubleshooting

Module 05: SQL Server 2016 Failover Clustering Instance

  • SQL Server FCI configuration
    • Active/Active
    • Active/Passive
    • MS DTC
  • Maintenance
    • Patching/Upgrading
    • o Adding/Removing SQL Server to/from cluster
  • Monitoring
  • Troubleshooting

Module 06: SQL Server 2016 Availability Groups

  • SQL Server AG configuration
    • Sync/Async
    • Read Only Routing and Load Balancing
    • Direct seeding
    • Distributed AG
  • Maintenance
    • Patching/Upgrading
    • Adding/Removing files to/from database in AG
    • Adding/Removing database to/from AG
  • Monitoring
  • Troubleshooting

Module 07: SQL Server Interoperability

  • Interoperability
    • with Integration Services
    • with Analysis Services
    • with Reporting Services

HIGH AVAILABILITY SOLUTIONS WITH SQL SERVER

Module 01: High Availability Overview

  • Defining High Availability
  • Achieving High Availability

Module 02: Overview of Windows Server Failover Clusteriong

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

Module 03: SQL Server 2014 High Availability Overview

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

Module 04: AlwaysOn Failover Clustering

  • SQL Server Failover Clustering – Definitions and History
  • SQL Server 2014 Failover Clustering Instance (FCI)
  • Maintaining a SQL Server 2015 FCI
  • Multi-Site Failover Clustering

LAB: Installing a Two-Node Failover Clustered SQL Server and Analysis Services Installation

Module 05: AlwaysOn Availability 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 Replication for High Availability

  • Log Shipping Overview
  • Log Shipping Architecture
  • Configuring Log Shipping
  • Log Shipping Internals
  • Administering Log Shipping

LAB: Enabling Log Shipping Between Two Servers

Module 09: 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

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

¿Quieres realizar este curso? ¿Necesitas más información?

Completa el formulario que encontrarás en la parte superior de esta página