DBA esperti, professionisti di Windows Server, team leader.

Prima di frequentare il corso, è necessario aver maturato esperienza nell'ambito SQL DBA e Windows IT PRO.

Module 1: Introduction

Module 2: AlwaysOn and High Availablity concepts and terminology
Concepts and Terminology
Table of Availability
High Availability
Causes of Downtime
Planned downtime
Unplanned downtime
Disaster Recovery
Recovery Time Objective (RTO)
Recovery Point Objective (RPO)
Recovery Level Objective (RLO)
Storage Area Networks (SAN)
Edition Changes from SQL 2012
SQL Server 2014 Changes
SQL Server 2016 Changes
Legacy Solutions prior to Always On
Failover Cluster Instances
Log Shipping
A Typical Log Shipping Configuration
Monitor Server
Replication
Database Mirroring
Database Mirroring Terminology
Principle
Mirror
Witness (red box in image above)
Database Snapshots
Limitations of legacy solutions:
What do we mean by Always On?
Table of Always On Comparison

Module 3: Windows server 2016 failover clustering
Understanding Failover Clustering in Server 2016
Statefull High Availability Solution
Supported in both Standard and Datacenter
Servers should run similar hardware
Should run same edition
Hyper-V best with datacenter
Certified for Windows server logo
Shared Storage
Quorums
Node Majority
Node and Disk Majority configuration:
Node and File Share Majority
No Majority
Configuration
Cluster Networks Best Practices
Connection to nodes to shared storage
Private network for internal cluster
Public network for client connections
Cluster Aware Updating
Virtual Machine Failover Clustering
Preferred Owners
Failover Failback
Resources
Dependences
Heartbeat

Module 4: SQL 2016 Failover cluster instances
Failover Cluster Instance
As A FCI Appears To A Client

Module 5: SQL 2016 Always on availability groups
Availability Groups and Replicas
Primary Replica
Secondary Replicas
Availability Group Listener
Availability Mode
Synchronous Commit Mode
Asynchronous Commit Mode
Failover Modes
Automatic Failover Without Data Loss
Automatic Failover Requirements:
Manual
Manual Failover Requirements
Common Topologies

Module 6: The dahsboard
The Dashboard
How to view logs
Using replication with Logins
Using partially contained databases

Module 7: Active Secondary Availability Group Actions
Reporting with Secondary Replicas
Configuring a Readable secondary
Read-Only Routing
Load Balancing
Lab: Configure a Read-Only Secondary
Database Backups with Secondary
Steps of Backup Using secondary
Backup Preference Options

Module 8: Maintenance
DBCC Checks
Database Adding and Removing

Module 9: Monitoring and troubleshooting availability groups
The Dashboard in Depth
Events
Policy Based Managemnt for Availability Groups