- United Arab Emirates
- Saudi Arabia
- Qatar
- Oman
- Kuwait
- Bahrain
- Pakistan
- Egypt
- Libya
- Afghanistan
- Sudan
- Cyprus
- Fiji
- Ethiopia
- Ghana
- Kenya
- Nigeria
- Mauritius
- South Africa
- Zambia
- Zimbabwe
- Mozambique
- Uganda
- Tanzania
- Angola
- And Growing up
Narrated ‘Ali bin Abi Talib (RA): The Prophet (RA) stood up for a funeral (to show respect) and thereafter he sat down. (Dawud)
This Microsoft course is designed to help engineers and administrators who are going to be involved with monitoring the Isolation levels in SQL Server databases. The course uses SQL 2016 but explains the differences between versions of 2014 and 2012.
Module 1: Introduction this module explains the course and objectives.
Module 2: Alwayson and high availability concepts and technology
This module will introduce the participants to the concepts and terminology used in the course.
After completing this module, students will be able to:
» Show More 👇
Module 3: Windows server 2016 failover clustering
Failover clustering is covered in this module and is a critical feature of AlwaysOn High Availability.
After completing this module, students will be able to:
Module 4: SQL 2016 failover cluster instances
In this module we move from the generic failover clustering to the specifics involving SQL.
After completing this module, students will be able to:
Module 5: SQL 2016 always on availability groups
Within the failover clusters of SQL are the concept of Availability groups and their enhancements with the release of SQL 2016 which is the focus of this module.
After completing this module, students will be able to:
Module 6: The Dasboard Managing AlwaysOn High Availability groups with SQL 2016 is accomplished with the Dashboard.
This module will demonstrate the skills necessary for the accomplishment of the management tasks.
After completing this module, students will be able to:
Module 7: Active Secondary Availability Group Actions
Within Availability groups you may have Active secondary SQL which is covered and demonstrated in this module.
Lab : Database Backup Using Secondary ReplicaLab : Configure a Read-Only secondary
After completing this module, students will be able to:
Module 8: Maintenance
In this module you explore maintenance procedures for AlwaysOn High Availability Groups.
After completing this module, students will be able to:
Module 9: Monitoring and troubleshooting availability groups
In this the final module you will learn how to monitor the clusters and Availability groups and various common troubleshooting procedures.
Migrating Settings by using Windows Easy Transfer
After completing this module, students will be able to:
» Show Less 👆
Audience Profile
Experienced DBAs, Windows Server pros, team leads.
We designed this course based on our experience of having taught hundreds of classes to literally thousands of students. We tried very hard to make the labs, of which there are over 30, very oriented to a single concept such as Adding a Replica or Transferring Logons.
Q: What is SQL Always On high availability?
A: The SQL is always in high availability and features a disaster-recovery solution that provides an enterprise-level option for database mirroring. Introduced in SQL Server 2012 (11. x), Always On availability groups maximize the availability of a group of user databases for a business.
Q: What are the duration and prerequisites of the 55246-A: SQL 2016 Always on High Availability course?
A: The duration of this course is 3 days, whereas before this course, learners must have experience in SQL DBA and Windows IT Pro.
Q: What is the course objective of the 55246-A: SQL 2016 Always on High Availability course?
A: The course objective is to fully understand AwasyOn High Availability. Employ Server 2016 Failover Clustering, deploy SQL Failover Clusters, work with Availability Groups, perform maintenance, and most importantly, monitor and troubleshoot Availability Groups.
Q: What are the features of AlwaysOn?
A: AlwaysOn provides high availability and disaster recovery at the SQL database level.
Live, Online Training by top Instructors and practitioners across the globe.
Conduct training at the work location you desired.
The Venue will be ideally located and easy to access with covid-19 SOP's.
Travel to any desired location for your training.