fbpxl

Formación privada

 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.

Beneficios

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

Desarrolla soluciones de recuperación de desastres.

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

l

Soluciona problemas con alta disponibilidad en SQL Server 2016 y 2014.

Modalidades del Curso

Formación Privada

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

Pre-requisitos

No se requiere ninguna experiencia previa para cursar.

Después del Curso

Después de completar este curso, el alumno será capaz de crear y administrar  soluciones de alta disponibilidad con Windows Server 2012 R2/ 2016 y SQL Server 2014/2016

Contenido del Curso

BUILDING AND MANAGIN HA SOLUTIONS WITH SQL SERVER

HIGH AVAILABILITY SOLUTIONS WITH SQL SERVER

Module 1. Introduction to High Availability.
  • Basic aspects of High Availability.
Module 2. Windows Server 2016 High Availability Features Overview.
  • Overview of HA features in Windows Server 2016.
Module 3. SQL Server 2016 High Availability Features Overview.
  • Failover Cluster Instances.
  • Availability Group.
  • Log Shipping.
Module 4. Windows Server 2016 Failover Clustering.
  • Installation.
  • Storage configuration.
  • Quorum configuration.
  • Maintenance.
  •  Patching/Upgrading.
  • Adding/Removing nodes to/from cluster.
  • Monitoring.
  • Troubleshooting.
Module 5. SQL Server 2016 Failover Clustering Instance.
  • SQL Server FCI configuration.
  •  Active/Active.
  •  Active/Passive.
  • MS DTC.
  • Maintenance.
  •  Patching/Upgrading.
  • Adding/Removing SQL Server to/from cluster.
  • Monitoring.
  • Troubleshooting.
Module 6. 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 7. SQL Server Interoperability.
  • Interoperability.
    • with Integration Services.
    • with Analysis Services.
    • with Reporting Services.
Module 8. Introducción a la Alta Disponibilidad.
  • Clustering.
  • Database Mirroring.
  • AlwaysON.
  • Log Shipping.
  • Replicación.
  • ¿Cuál escoger en cada caso?
Module 1. High Availability Overview.
  • Defining High Availability.
  • Achieving High Availability.
Module 2. Overview of Windows Server Failover Clusteriong.
  • Failover Clustering Concepts
  • Cluster Resources.
  • Setting up a Windows Failover Cluster.
  • MSDTC ClusteringLAB: Creating Your Windows Server Failover Cluster.
Module 3. 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 4. 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 5. 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 6. Legacy Database Mirroring.
  • Database Mirroring Overview.
  • Database Mirroring Architecture.
  • Enabling Database Mirroring.
  • Database Mirroring Operations.

LAB: Enabling Database Mirroring Between Two Servers.

Module 7. 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 8. 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 9. 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.

Contacta con Nosotros

¿Necesitas más información o un presupuesto para formación privada?

Invite & Earn

X
Signup to start sharing your link
Signup