Implementing SQL Server on Amazon RDS
A guide for database administrators to implement SQL Server on Amazon RDS.
What you'll learn
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.
Table of contents
- 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
- 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
- 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
- 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
About the author
Warner is a SQL Server Certified Master, MVP, and Solutions Architect at Pythian, a global Canada-based company specializing in data and infrastructure services. A brief stint in .NET programming led to his early DBA formation, working for enterprise customers in Hewlett-Packard's ITO organization. From HP he transitioned to his current position at Pythian, managing multiple clients of different sizes and industries. He leads a highly-talented team of data professionals that keep things running ... more