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

COURSE: Building and Managing High Availability Solutions with SQL Server 2017 - 2014

Build a reliable High Availability solution with Windows Server

Master your T-SQL Querying, Query Tuning and Programming skills. Create highly efficient solutions to your common business tasks

UPCOMING DATES

Feb 18, 2019 – Vienna Enroll here

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 2016, maintain it, monitor and troubleshoot your solution.

COURSE DELIVERY OPTIONS

3-DAYS CLASSROOM

The course will take place in a classroom with no more than 20 students in order to maintain a good level of interactivity.

INSTRUCTOR-LED ONLINE

The training will be an instructor-led 100% online course, where you will be able to talk to the mentor and solve your problems in real time It wil lbe run in six 3-hour long sessions.

PRIVATE ONSITE

The course will take place in your company’s facilities. We limit attendance to no more than 20 students in order to maintain a good level of interactivity. Request a quote now.

Course Coverage

Build a reliable High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016

Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016

Build Disaster Recovery Solutions

Troubleshoot problems with High Availability in SQL Server 2016 and 2014

“Itzik’s course opened my eyes and helped me re-discover the passion I have for solving problems using creative and efficient methods”

John Smith

DBA

“I am extremely happy after Herbert’s class. I will need more time to process everything I´ve learnt from this course”

Matt Johnson

Developer

“I can see why people love T-SQL. Being able to learn from Itzik has been a pleasure”

Jason Harris

DBA

COURSE OUTLINE

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

Meet our Instructors

 Herbert Albert

Herbert Albert is a Mentor and Managing Director of SolidQ’s Central and Eastern Europe subsidiary. Since SQL Server 6.0 Albert worked as a consultant, a database developer and trainer and holds several Microsoft certifications including MCT. He was involved in the development of several Microsoft Official Curriculum courses. Herbert co-authored “SQL Server Upgrade Technical Reference Guide” for SQL Server 2008 and 2012 and the Microsoft Press book “SQL Server 2005 Step-by-Step Applied Techniques”. He is a regular speaker at international conferences and events. As a trainer Herbert is focused on courses for T-SQL programming and performance tuning, which he delivers successfully all over Europe.

Karol Papaj

Karol Papaj, MCTS and former SQL Server MVP, is a mentor with SolidQ 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 participated 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 SolidQ’s SQL Server courses. He is also the author of the SolidQ course “Building and Managing High Availability Solutions with SQL Server 2017-2014”.

Would you like to register for this course?

Fill out the form at the top of this page