Building and Managing High Availability Solutions with SQL Server
Utbildningsformer
Längd
3 dagar
Pris
25350 kr
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.
- Build a reliable High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
- Manage a High Availability solution with Windows Server 2012 R2/2016 and SQL Server 2014/2016
- Build Disaster Recovery Solutions
- Troubleshoot problems with High Availability in SQL Server 2016 and 2014
Experience administering a recent version of Microsoft SQL Server
Module 01: Introduction to High Availability
- Basic aspects of High Availability
- Features Overview Overview of HA features in Windows Server 2016
- Failover Cluster Instances
- Availability Group
- Log Shipping
- Installation
- Storage configuration
- Quorum configuration
- Maintenance
- Patching/Upgrading
- Adding/Removing nodes to/from cluster
- Monitoring Troubleshooting
- SQL Server FCI configuration
- Active/Active
- Active/Passive
- MS DTC
- Maintenance
- Patching/Upgrading
- Adding/Removing SQL Server to/from cluster Monitoring Troubleshooting
- 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
- Interoperability
- with Integration Services
- with Analysis Services
- with Reporting Services