Four Reasons to Migrate Your SQL Server Databases to the Cloud

Overview

Explore four compelling reasons to migrate SQL Server databases to the cloud in this informative PASS Data Community Summit presentation. Delve into AWS services tailored for SQL Server deployment, learn how to choose the right solution for specific needs, and understand the various methods to deploy and manage SQL Server resources securely. Gain insights on monitoring performance using Amazon CloudWatch, scaling compute resources, and leveraging storage options for optimal I/O performance. Discover high availability features, including Amazon RDS built-in capabilities and management windows. Learn about keeping applications running during migration with DMS and implementing Windows Authentication in Amazon RDS. Presented by Jeremiah Wilton and moderated by Hamish Watson, this comprehensive overview covers essential aspects of SQL Server migration to AWS, emphasizing security, performance, and management considerations.

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