Implementing SQL Server on Amazon RDS

By Warner Chaves
A guide for database administrators to implement SQL Server on Amazon RDS.
Course info
Rating
(49)
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 19m
Table of contents
What Is Amazon RDS?
Introducing Amazon RDS 2m What Is Database as a Service? 5m The Business Value of RDS 1m Module Summary 2m
Building Your SQL Server on Amazon RDS
What's in This Module? 1m Planning Your Deployment 2m Pricing and Instance Choices 4m Storage and Networking 8m Demo: Create Your SQL Server on RDS through the AWS Console 6m Configuring Your SQL Server in RDS 3m Demo: Configure Your SQL Server in RDS through the AWS Console 5m Demo: Configure SQL Server in RDS through the AWS Command Line 3m Module Summary 1m
Connecting and Managing SQL Server on Amazon RDS
What's in This Module? 1m Connecting to SQL in RDS 3m Demo: Verify Network Connectivity 3m Demo: Connecting with SSMS and Excel 2m The RDS Admin User 2m Demo: Working as RDS Admin 3m Working with the SQL Agent 1m Demo: SQL Agent Functionality in RDS 3m Viewing SQL Server Logs in RDS 2m Demo: Viewing SQL Logs on the AWS Web Console 2m Demo: Viewing SQL Logs through SQL Commands 2m Module Summary 1m
Moving Data in and Out of SQL Server on RDS
What's in This Module? 1m Tools to Move Data 3m Demo: Scripting Your Database 5m Which Tool to Use 1m Demo: Moving Data with the Import/Export Wizard 3m Demo: Moving Data with the BCP Utility 3m SQL Database Migration Wizard 1m Demo: Migrate Using the SQL Database Migration Wizard 4m Module Summary 1m
Configuring Backups and High Availability
What's in This Module? 1m Backup Settings and Cost 3m Restore and Recovery Models 2m Demo: Verify and Modify Backup Settings 4m Demo: Restoring to a Point in Time 3m Working with RDS Snapshots 3m Demo: Creating a Snapshot of Your SQL Server 2m Demo: Restoring Your SQL Server from a Snapshot 3m SQL Server Multi-AZ Deployment 3m Demo: Enabling Multi-AZ Deployment 3m Demo: Failing over a Multi-AZ deployment 2m Module Summary 1m
Known Service Limitations
What's in This Module? 1m Main Limitations and Work-arounds 6m Demo: Create a Linked Server to RDS 4m Demo: Set up Transactional Replication to RDS 8m Other Limitations 1m Module Summary 1m
Description
Course info
Rating
(49)
Level
Intermediate
Updated
Oct 19, 2015
Duration
2h 19m
Description

Amazon is one of the biggest providers of cloud computing in the world. Part of their offering is the database cloud service known as Amazon RDS. In this course, we'll cover what these service can do, the option and configuration choices for SQL Server, and the differences from the on-premises SQL Server that you already know.

About the author
Warner Chaves
About the author

Warner is a SQL Server Certified Master, MVP, and Principal Consultant at Pythian. He manages clients in many industries and leads a talented team that maintains and innovates with their data solutions. When he's not working in Ottawa, Ontario, he can be found in his home country of Costa Rica.

More from the author
Database Programming with Pyodbc: Python Playbook
Intermediate
2h 21m
Apr 4, 2019
Microsoft Azure Developer: Connecting to Storage
Beginner
1h 8m
Sep 28, 2018
Delivering Real-time Data with Azure and Power BI Streaming
Intermediate
1h 59m
Apr 20, 2018
More courses by Warner Chaves

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT