Overview
This course covers how to run a managed SQL Server on AWS using Amazon Relational Database Service (RDS). The learning outcomes include understanding how RDS automates database administration tasks, offers high availability, performance monitoring, and scalability for SQL Server workloads. The course teaches about deploying and operating a SQL Server database in the cloud, differences between managed and self-managed deployments, backup options, high availability features, performance insights, instance types, storage options, Active Directory integration, performance monitoring using CloudWatch metrics, and moving data. The teaching method is through a recorded session from PASS Summit 2020. The intended audience includes individuals interested in deploying and managing SQL Server databases on AWS using Amazon RDS.
Syllabus
Introduction
Eugenes background
Session evaluations
Agenda
What is RDS
Running SQL Server on AWS
Managed Experience
Backup
Manual Snapshot
Native Backups
High Availability
failover times
readscaleout
compute and storage scaling
performance insights
compute instance types
EBS
General Purpose
Provision IOPS
Recap
Active Directory Integration
Performance Monitoring
CloudWatch Metrics
Enhanced Monitoring
Moving Data
New Features
SQL Server Analysis Services
Replication Service Master Key
Taught by
PASS Data Community Summit