SQL Server Databases and Cloud
In this video, we take a look at how to set advanced configurations using RDS parameter groups. Due to permissions restrictions, some parts of the usual DBA toolkit are disabled such as setting trace flags or amending the sp_configure settings. With parameter groups, you can still make these changes where necessary.
In this video, we walk through how to create your first RDS instance using the AWS console. (SQL Server) No scripting skills are required at this stage.
This short training video shows you what is required for connecting to your AWS RDS instance. Learn how to use SQL Server Management Studio and what is different from connection to your on-premises SQL Server.
This short video details some benefits and limitations of AWS RDS. It’s not full SQL Server as you know, but it does a lot for you. I also go into some key AWS terminology which may help the those who are new to AWS, or the cloud in general. The video is only 5 minutes long. Once you watched it, you can get a more detailed list of unsupported features from the AWS documentation.
UPDATE: You can now use database mail with RDS – See this.
I’ve put together a short video series on running SQL Server on Amazon RDS. It covers some basics and can be completed in around an hour, with several very short videos. It’s intended for SQL professionals who are just getting started with AWS, but might also be enjoyed by AWS users, looking to get started with a relational database management system.
It’s my first attempt at putting together a training plan. So any feedback will be gratefully received. Either in the blog comments or YouTube video comments.
1. Introduction to SQL Server on Amazon RDS (Scroll down)
2. Benefits and limitations of AWS RDS
3. Create your first RDS instance using the AWS console
4. Connecting to your AWS RDS instance
5. Advanced Configurations using Parameter Groups
6. Securing your SQL Server AWS RDS Instance
7. Automating Deployments using PowerShell
8. Backup and restore for AWS RDS
9. Providing High-Availability through Multiple Availability Zones
10. Monitoring Your Instances using CloudWatch