"Vi hjelper deg å nå dine kompetansemål i 2018"

Mastering SQL Server High Availability and Disaster Recovery

Kursavgift: kr 20 000 | Varighet: 3 dager


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+

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 prerequisites:
Level 200 of Microsoft SQL Server Administration and Development. T-SQL and database programming knowledge is good to have.

About the instructor: Magi Naumova

Margarita Naumova is a very well-known Bulgarian SQL Expert. Magi holds a highest possible SQL Server Technical Certification in the field – Microsoft Certified Master, making her one of the best SQL Server Experts Worldwide, among the top one percent of IT professionals in the World. She has more than 10 years of SQL Server and BI technologies consulting and training experience gained in Bulgaria and abroad and is a trusted advisor for major Bulgarian companies in SQL Server Platform Area.

Margarita is a leader and founder of Bulgarian SQL & BI User Group “Let’s SQL Together!” and is a regular presenter of the largest IT events in Bulgaria. Currently she works as a Managing Partner and Chief SQL Architect of Inspirit - her own newly established Consulting Company. She is a former and author of SQL Master Academy Training Program. Previously she was Seniour Consultant at Microsoft. She was also Microsoft Certified trainer with more than 12 years of training experience.

Read more about Magi at http://maginaumova.com.


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.

Course Syllabus

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: 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 3: DB Mirroring Core concepts
  • The way DB Mirroring works
  • Mirroring types in details
  • Configuration parameters and security
  • Mirroring partner statuses
Module 4: SQL Server Availability Groups
  • Solution, design decisions, and possible architectures
  • Configuration parameters and security
  • Solution Maintenance and support
Module 5: Log Shipping
  • Log Shipping Solution and configuration
  • Monitoring scenarios
  • Patching and upgrading
  • Operating the solution
Module 6: Combining HA and DR Technologies
  • Important factors in combining HA and DR solutions

Bestill kurset her


Velg kurssted


    Velg dato

    kurs merket med * har startgaranti


    Mailen er sendt:

    Ditt tips er registrert og sendt!
    Vi håper snarlig å se deg på kurs hos oss!


    OBS! Vi har problemer med å sende ditt tips!

    Vi anbefaler deg å sjekke om du har skrevet inn en gyldig mailadresse.

    Tips sjefen

    Lyst til å delta på dette kurset, men må overbevise sjefen først?

    Glasspaper har laget en tips funksjon, som gjør det enklere for deg å overbevise din sjef om at dette kurset er perfekt for deg.
    Det eneste du trenger å gjøre er å fylle ut kontaktinformasjon, så sender vi relevant informasjon om kurset rett til dine utvalgte kontaktpersoner.
    Bruk gjerne funksjonen til å tipse venner og kollegaer om at dette er et nyttig kurs for dem

    Kontakt oss


    Hroar Henriksen

    916 70 066


    Personvern og cookies