Building and Managing High Availability Solutions with SQL Server

3 days / 24 hours | online / onsite

Developed by Lucient Mentor Karol Papaj, the High Availability course focuses on HA / AlwaysOn solutions like Failover Clusrting and Availability Groups.

What Does this Course Cover?

Along the course you will learn the basics on how to create a high available solution, along with the potential threats the platform may face. You will learn how to install Windows Server 2019, maintain it, monitor and troubleshoot your solution.

  • Build a reliable High Availability solution with Windows Server 2019 and SQL Server 2019
  • Manage a High Availability solution with Windows Server 2019 and SQL Server 2019
  • Build Disaster Recovery Solutions
  • Troubleshoot problems with High Availability in SQL Server

Next Dates

01/23/2023 – 01/25/2023, QA, online
03/13/2023 – 03/15/2023, QA, online
11/29/2023 – 12/01/2023, Stockholm, Cornerstone, online, onsite

For our classes managed by our partners QA (UK) or Cornerstone (Sweden) please visit their respective websites!

Course Outline

Module 01: Introduction to High Availability

  • Basic aspects of High Availability

Module 02: Windows Server 2019 High Availability

  • Features Overview Overview of HA features in Windows Server 2019

Module 03: SQL Server 2019 High Availability Features Overview

  • Failover Cluster Instances
  • Availability Group
  • Log Shipping

Module 04: Windows Server 2019 Failover Clustering

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

Module 05: SQL Server 2019 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 06: SQL Server 2019 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

Herbert Albert

Trainer & Author

is a mentor at Lucient. He has been working with SQL Server since version 6.0 as a consultant, database developer and trainer. He is co-author of official Microsoft courses on Administering and Developing SQL Server, as well as author of the Lucient training “Troubleshooting and Performance Tuning for SQL Server”. He is also co-author of the “Upgrade Technical Reference Guide” and Technical Editor of Microsoft Press books. As a trainer, consultant and speaker, his focus is on Performance Tuning, T-SQL programming and High Availability, where he works internationally.

 

Karol Papaj

Trainer & Author

Karol Papaj, MCTS and former SQL Server MVP, is a mentor with Lucient since 2006. Karol is specializing in Relational Engine and Business Intelligence in SQL Server with focus on Performance Tuning and High Availability. He has been working with SQL Server since SQL Server 6.5 and participates in many projects for IT/Telco companies and companies from the banking industry in Slovakia. Besides mentoring and consulting Karol regularly speaks at conferences organizing by Microsoft and at community events in Slovakia and neighboring countries and teaching Lucient’s SQL Server courses.