Virtual The course goal is to dive into SQL Server Technologies and solutions that support and provide service and database availability, in order to understand and being able to design, maintain and support them in practical production environments.
It is very important to know the way both availability solutions work in order to design, implement and maintain critical production systems. Developing an overall understanding and familiarity of the basic features and different implementations is relatively simple. What is trickier to develop however, is an understanding of the mechanics (or internals) of Clustering, Availability Groups and Log Shipping and experience of how to manage large scale and critical systems.
This training gives you the important aspects to understand the Clustering, Log Shipping and Availability group technology in order to build and manage a reliable availability solution. It also describes the DB Mirroring, which is still useful to understand as a concept, in case you work with older version of SQL Server or to understand the foundation of Availability group solution.
Technical Level: 300+
Versions covered:
• The course covers all versions of SQL Server from 2016+ and later, including SQL Server 2019. The lab exercises will be on SQL Server 2017.
Course objectives:
After the training completion attendees will be able to:
• Decide what type and which HA and DR technology to implement
• Understand how the specific availability solution work
• Implement a proper high availability solution or a combination of them
• Manage, maintain, operate and troubleshoot Availability Group configuration
• Monitor and take actions to optimize the solution performance
Course outline:
Module 1 - HA and DR concepts:
• Putting measures and definition to work as solution requirements
• Defining terms for your SQL Server Availability
• SQL Server HA and DR Solutions overview
Module 2 - Log Shipping and DB Mirroring:
• The way DB Mirroring works
• Mirroring types in details
• Configuration parameters and security
• Log Shipping Concepts
• Configuring Log Shipping
Module 3 - Providing Service level protection with SQL Server Failover Clustering:
• How the FC works
• The Voting concept
• Installing SQL Server FC - important steps
• Maintaining SQL Server FC solution
Module 4 - SQL Server Availability Groups:
• Solution, design decisions, and possible architectures
• Configuration parameters and security
• Readable secondaries and Read Only Routing
Module 5 - Operating an Availability Group Solution:
• Solution Maintenance and support
• Monitoring Availability Group Solution
• Alerts and Notifications
Module 6 - Combining HA and DR Technologies:
• Important factors in combining HA and DR solutions
Course format:
The course modules consist of presentation for describing the respective concept and a demonstration. Some of the modules consist of practical exercises in order for the attendees to understand the concept better.
Audience:
Prerequisites:
• Level 200 of Microsoft SQL Server Administration and Development. T-SQL and database programming knowledge is good to have.
Language:
• English course material, English speaking instructor
Instructor: Magi Naumova
Margarita Naumova is a very well-known SQL Expert. Magi holds the highest possible SQL Server Technical Certification in the field - Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide. Magi is also a Microsoft Data Platform MVP (Most Valueable Professional). She has more than 10 years of SQL Server and BI technologies consulting and training experience and is a trusted advisor for many large companies in SQL Server Platform Area. Currently she works as a Managing Partner and Chief SQL Architect of Inspir-it AS, her own newly established Consulting Company here in Norway. Margarita is a regular speaker at the largest IT events, SQLBits, SQL Saturday in Europe.