Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Running Managed SQL Server on AWS

PASS Data Community Summit via YouTube

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

Reviews

Start your review of Running Managed SQL Server on AWS

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.