Four Reasons to Migrate Your SQL Server Databases to the Cloud
PASS Data Community Summit via YouTube
Overview
Syllabus
Intro
Technical Assistance
What we'll cover
What is AWS?
AWS lets you focus on your business
The AWS global infrastructure
AWS services to use when deploying SQL Server
Choose the right solution for your needs
Solutions for SQL Server on AWS
SQL Server features at a glance
Deploy and manage SQL Server Multiple ways to start and manage your SQL Server resources using AWS
Deploy and run SQL Server securely Consider the following security layers offered by AWS
Securing SQL Server on AWS: network
Securing SQL Server on AWS: instances
Securing SQL Server on AWS: Access
Securing SQL Server on AWS: data
Launching an RDS DB instance
Workload pattern impact on performance
Monitoring SQL Server performance Montor performance using Amazon CloudWatch
Enhanced Monitoring in the RDS Console
Scaling compute resources
Storage options for SQL Server Networked black storage (Amazon EBS & RDS Storage)
Storage system I/O performance
SQL Server High Availability
Amazon RDS built-in features
Amazon RDS management windows Configurable administrative windows of time
DMS: Keep apps running during the migration
RDS SQL Server Windows Authentication
Amazon RDS Enhanced Monitoring
Taught by
PASS Data Community Summit