fbpxl

Instructor-Led Online | 3 Days Classroom | Private Onsite

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.

Main Benefits

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

Build Disaster Recovery Solutions.

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

Troubleshoot problems with High Availability in SQL Server 2016 and 2014.

Upcoming Dates

 Oct 28, 2019 – Vienna Enroll here
 Nov 4, 2019 – Stockholm Enroll here

Course Delivery Options

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.

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.

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.

After this Course
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.

“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

Developer“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

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”.

Course Outline

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. Modeling: 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
  • Contact us

    Do you want more info about these courses?

    • By submitting this information, you acknowledge that you have read the Privacy Policy and that you consent to our data processing in accordance with this Statement.