SQL Server High Availability and Disaster Recovery (HA/DR)
Dive deep into how SQL Server works to implement an effective high availability and disaster recovery solution.
Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso
En línea · 60 h
13 unidades
Nivel avanzado
Qué aprenderás
Lo que serás capaz de hacer
This is a deep dive course on understanding how SQL Server works to effectively choose the right high availability and disaster recovery solution that will address every organization's need to protect digital assets. Packed with videos explaining concept and demos to reinforce the lessons, this course is what every IT professional needs to properly manage and protect a SQL Server database. If you're a SQL Server database administrator or a systems administrator responsible for SQL Server databases, this is for you. You want to be well-informed and skilled in protecting SQL Server databases from unwanted data loss and outages. Because outages and data loss happen to databases. It's only a matter of time. The course primarily uses SQL Server 2012 for demonstrations. But the concepts still apply to later versions of SQL Server on Windows - even SQL Server 2025 on Windows Server 2025. OR...Just watch hours of Practical SQL Server HA/DR Show episode videos... FOR FREE . The goal of the Practical SQL Server HA/DR Show is to provide guidance and lessons beyond the technical know-how. It's the non-technical aspects of high availability and disaster recovery that most technology professionals often overlook but are as equally important nonetheless. Get access to these videos without signing up on Udemy. Just expand the section Practical SQL Server HA/DR Show to watch the videos.
- By the end of the course, attendees will be able to understand the different SQL Server high availability and disaster recovery technologies - how they work and properly implement the right solution to address recovery objectives and service level agreements
Temario
UNIDAD 1 - Introduction · 2 leccionesUNIDAD 1 - Introduction
UNIDAD 1 - Introduction · 2 lecciones
UNIDAD 1 - Introduction
- Introduction
- The Need for High Availability and Disaster Recovery
UNIDAD 2 - Non-Technology Aspects of High Availability and Disaster Recovery · 3 leccionesUNIDAD 2 - Non-Technology Aspects of High Availability and Disaster Recovery
UNIDAD 2 - Non-Technology Aspects of High Availability and Disaster Recovery · 3 lecciones
UNIDAD 2 - Non-Technology Aspects of High Availability and Disaster Recovery
- Non-Technology Aspects of HA/DR
- The Alphabet Soup of HA/DR
- S.M.H. Those Things That You're not Aware Of But Part of HA/DR
UNIDAD 3 - SQL Server Recovery Models · 3 leccionesUNIDAD 3 - SQL Server Recovery Models
UNIDAD 3 - SQL Server Recovery Models · 3 lecciones
UNIDAD 3 - SQL Server Recovery Models
- SQL Server Database Recovery Models
- Demo: SQL Server Database Recovery Models
- Demo: The Risk of Switching Recovery Models
UNIDAD 4 - SQL Server Database Backups · 2 leccionesUNIDAD 4 - SQL Server Database Backups
UNIDAD 4 - SQL Server Database Backups · 2 lecciones
UNIDAD 4 - SQL Server Database Backups
- Database Backups
- Demo: Understanding Multi-base Differential Backups
UNIDAD 5 - SQL Server Transaction Log Internals · 3 leccionesUNIDAD 5 - SQL Server Transaction Log Internals
UNIDAD 5 - SQL Server Transaction Log Internals · 3 lecciones
UNIDAD 5 - SQL Server Transaction Log Internals
- Inside the SQL Server Transaction Log
- Demo: Inside the SQL Server Transaction Log
- Demo:Effects of the Transaction Log Filling Up
UNIDAD 6 - SQL Server Database Restore and Recovery · 4 leccionesUNIDAD 6 - SQL Server Database Restore and Recovery
UNIDAD 6 - SQL Server Database Restore and Recovery · 4 lecciones
UNIDAD 6 - SQL Server Database Restore and Recovery
- Database Restore and Recovery
- Factors Affecting Restore And Recovery
- DEMO:Effects of Instant File Initialization
- Demo: Database Recovery Techniques
UNIDAD 7 - SQL Server System Databases · 2 leccionesUNIDAD 7 - SQL Server System Databases
UNIDAD 7 - SQL Server System Databases · 2 lecciones
UNIDAD 7 - SQL Server System Databases
- Protecting System Databases
- Demo: Protecting System Databases
UNIDAD 8 - SQL Server Database Mirroring · 3 leccionesUNIDAD 8 - SQL Server Database Mirroring
UNIDAD 8 - SQL Server Database Mirroring · 3 lecciones
UNIDAD 8 - SQL Server Database Mirroring
- Understanding and Implementing SQL Server Database Mirroring
- Demo: Implementing Database Mirroring - The Simple Way
- Demo: Implementing Database Mirroring on Workgroup Servers - The Hard Way
UNIDAD 9 - SQL Server Log Shipping · 2 leccionesUNIDAD 9 - SQL Server Log Shipping
UNIDAD 9 - SQL Server Log Shipping · 2 lecciones
UNIDAD 9 - SQL Server Log Shipping
- Understanding and Implementing SQL Server Log Shipping
- Demo: Implementing SQL Server Log Shipping
UNIDAD 10 - SQL Server Failover Clustering · 6 leccionesUNIDAD 10 - SQL Server Failover Clustering
UNIDAD 10 - SQL Server Failover Clustering · 6 lecciones
UNIDAD 10 - SQL Server Failover Clustering
- SQL Server Failover Clustering Fundamentals
- Demo: Implementing SQL Server Failover Clustered Instances From Start to Finish
- Demo: SQL Server 2012 Multi-Subnet/Geographically-Dispersed Failover Clusters
- Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 1
- Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 2
- Implementing SQL Server Failover Clustered Instances (2022 Edition) - Part 3
UNIDAD 11 - SQL Server Availability Groups · 6 leccionesUNIDAD 11 - SQL Server Availability Groups
UNIDAD 11 - SQL Server Availability Groups · 6 lecciones
UNIDAD 11 - SQL Server Availability Groups
- Understanding and Implementing SQL Server Availability Groups
- Demo: SQL Server 2012 Availability Groups Configuration
- Demo: Multi-Site/Geographically Dispersed SQL Server 2012 Availability Groups
- Demo: Successfully Implement SQL Server Always On Availability Groups with FCI
- SQL Server Licensing for your Always On Availability Groups
- SQL Server Always On Availability Groups and Failover Clustering Internals
UNIDAD 12 - SQL Server Replication · 2 leccionesUNIDAD 12 - SQL Server Replication
UNIDAD 12 - SQL Server Replication · 2 lecciones
UNIDAD 12 - SQL Server Replication
- SQL Server Replication
- Course Summary
UNIDAD 13 - Practical SQL Server HA/DR Show · 108 leccionesUNIDAD 13 - Practical SQL Server HA/DR Show
UNIDAD 13 - Practical SQL Server HA/DR Show · 108 lecciones
UNIDAD 13 - Practical SQL Server HA/DR Show
- Patching and Maintaining HA Solutions
- Monitoring SQL Server High Availability Solutions
- High Availability Basics for the DBA - What SQL Server CANNOT Do For You
- Backups
- Migrating SQL Server High Availability Solutions
- Migrating SQL Server High Availability Solutions - Part 2
- Focus on Windows Server Failover Clustering
- Are You Asking The Most Important Question About Your Availability Groups?
- The A.R.T. of Dealing with a Crappy Environment That You Just Inherited
- The Curse of SILOs
- What To Do When You Have Too Many Incidents In Your HA Environments
- 3 Biggest Mistakes DBAs Make When Deploying and Managing SQL Server Always On
- Dealing With A Black Box Even When You Don't Have Access
- How Learning and Mastering SQL Server Always On Can Lead To Your Next Promotion
- Succeeding as a SQL Server DBA Even Without Production Experience
- The Secret to Becoming a Subject Matter Expert
- Why "Is This Supported?" Is the Wrong Question to Ask About Your SQL Server HA
- H.O.W. to Handle Emergencies When You Have Very Limited Resources
- 3 Reasons Why Focusing on Tech is the WORST WAY to Deploy SQL Server HA/DR
- Do you have these 3 THINGS to properly support a HA/DR Solution?
- How Your Problem Solving Skills Can Cause More Problems If Not Done Right
- How Being an Operational DBA For So Long Is Hurting Your Career
- Your Responsibilities as an IT Pro for Dealing with Disasters
- Deadly SQL Server Always On Availability Group Deployment Mistakes to Avoid
- 3 Things Preventing You From Working with Always On Availability Groups
- Being A Jack-Of-All-Trades Puts Your High Availability Solution At Risk
- Why A Technical Answer Is NEVER The Right Response to a Technical Question
- What Experts & Consultants Are Not Telling You About Your HA/DR Solution
- Eliminate the Headaches of Upgrading & Migrating your SQL Server Databases
- Maximizing Your Change Freeze Period
- Making The Most of Your HA/DR Solutions in the New Year
- Impacts of Outdated Legacy Systems in HA/DR
- Protecting SQL Server from Unexpected Disasters
- Beyond Licenses and Hardware: The Hidden Costs of HA/DR
- 3 Common Mistakes IT Pros Make When Working with Backups
- 3 Biggest Blunders from My Botched Backups
- Making the Right Decision: What 3rd-party Backup Tools CANNOT Do For You
- Backup Strategies That Can Cause Unexpected Disasters
- 3 Things Your SQL Server HA/DR Solutions Need to Work
- Dealing With External Dependencies The Right Way
- Is Your HA/DR Solution a By-product of Technical Malpractice?
- March 31st is #WorldBackupDay
- Designing and Building Resilient HA/DR Solutions
- Why Developers Need to be Included in HA/DR Discussions
- Backend Developers and Data Engineers: Your Responsibilities in HA/DR
- HA/DR Disconnect: The Cost of Not Being On The Same Page with Other IT Teams
- "Supported" HA/DR Solutions: What It Really Means
- Unwritten Expectations That Come with HA/DR Solutions
- Business Impact Analysis: What It Means To Your HA/DR Solutions
- Risks of Having Untrained Operational Staff in Your HA/DR Solutions
- Considerations When Upgrading and Migrating HA/DR Solutions
- Business Continuity: What You Need to Know as an IT Professional
- Starting the Year Right: Re-evaluating Your Existing HA/DR Solutions
- HA/DR Tasks In The Beginning Of The Year
- Dealing with the "New VMWare": What You Need to do for your HA/DR Solutions
- Beyond the Database: HA/DR for your Multi-tier Solutions
- Why Do Always On Availability Groups Deployment Projects Fail?
- Why I No Longer Recommend Stretched Failover Clusters and Availability Groups
- Successful Deployments: Customer Stories About AG Implementations
- 3 Questions to Ask Before Implementing SQL Server Always On Availability Groups
- Upgrade & Migration Considerations for SQL Server High Availability Solutions
- Common Pitfalls When Implementing Always On Availability Groups
- Always On Availability Groups Implementation: Beyond the DBA World
- Hidden Pitfalls of Using SSMS Wizards for Always On: What DBAs Needs to Know
- What You Need to Become a HA/DR Solutions Architect
- Why Most Always On Availability Group Tutorials Are Setting You Up to Fail
- 3 Reasons Why Your Availability Groups Did Not Automatically Failover
- The Hidden Dangers in SQL Server Always On Availability Groups
- HA/DR Solutions: The Hidden Costs That Burn Budgets
- Addressing the Hidden HA/DR Costs: The "People Tax"
- Addressing the Hidden HA/DR Costs: The "Consumption Tax"
- Addressing the Hidden HA/DR Costs: The "Invisible Handshake Tax"
- Failover Clustering Trap You're Walking Into
- Vendor Recommendations on HA/DR: Asking the Right Questions
- Vendor Recommendations on HA/DR: The Dark Side
- Vendor Recommendations on HA/DR: Misconceptions
- Vendor Recommendations on HA/DR: What Vendors Are Not Telling You
- The Science and Art of Troubleshooting SQL Server Availability Group Issues
- Don't Blindly Trust the SQL Server Always On Availability Group Dashboard
- How I Troubleshoot & Resolve SQL Server Always On Availability Groups Outages
- Using the Client-Server Model to Troubleshoot Always On Issues
- Mental Game: Troubleshooting Always On Availability Group Outages
- Why Simplicity Is The Ultimate HA/DR Strategy
- 3 Rules for Designing Reliable High Availability Solutions
- Why Your Initial High Availability Design Is Already Broken
- Hidden HA/DR Risks During Change Freeze
- The DBA's Change Freeze Survival Guide
- What If There Was No Change Freeze?
- 3 Questions to Ask About Your Existing HA/DR Solutions (2026 Edition)
- Evaluating Your Existing HA/DR Solutions
- Inheriting an Environment You Don't Trust. Now What?
- Do Not Start With a Technical Assessment In Your SQL Server Environment
- The Truth About Risks in Your High Availability and Disaster Recovery Solutions:
- Taking Action Towards Stabilizing a Mess You Inherited
- Standing Out as a Tech Professional
- The Harsh Reality About Working in Tech
- The Silent Career Killer Every Tech Professional Ignores
- What No One Tells You About SQL Server Always On Availability Group Monitoring
- How To Choose The Right Monitoring Tool for SQL Server HA Solutions
- SQL Server Always On Availability Groups Monitoring: Metrics That Matter
- Dangerous Mistakes When Implementing HA/DR Solutions
- Best Practices for High Availability and Disaster Recovery
- High Availability and Disaster Recovery Solutions: Performing Failover Testing
- What I Check in High Availability and Disaster Recovery Implementations
- Considerations for Multi-Site Failover
- How to Upgrade and Migrate Highly Available SQL Server Databases
- The Psychology of Crisis: How Technology Professionals Respond to Disasters
- How to Choose The Right High Availability Solution
Certificado oficial
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Cómo funciona
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
13 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
Cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Lo que obtienes
Un certificado oficial de la SEP
Muestra · verificable por folio y QR
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Edwin M Sarmiento.
- Folio y QR verificables para compartirlo con quien te contrate.
Medios que necesitas
Equipo de cómputo
Conexión estable a internet
Pago único
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 13 unidades · 146 lecciones · 60 h
- 12 meses de acceso
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Preguntas frecuentes
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Edwin M Sarmiento; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.
