You can run SQL Server on AWS?

---

My presentation

I presented on running SQL Server on AWS at DataGrillen in Germany. Specifically, I covered the differences between RDS and EC2, migration options and the AWS CLI. Despite being a daunting prospect, I enjoyed speaking at a major conference for the first time.

I received a few questions and managed to answer most. For the one I could not remember, I promised to provide an answer.

I was asked who provides the SSL certificates when using SSL connections with your RDS instance. The answer:  When you create a SQL Server DB instance, Amazon RDS creates an SSL certificate for it. The SSL certificate includes the DB instance endpoint as the Common Name (CN) for the SSL certificate to guard against spoofing attacks. Read more.

Link to slides, please feel free to view or download.

The event

DataGrillen is a community Data Platform event which is free to attend and draws speakers and attendees from across the world. It is so inclusive and welcoming, it’s easy to see why it’s a can’t miss event for so many many people.

Links to my other AWS content

• https://johnmccormack.it/2017/12/ec2-sql-server-backups-to-amazon-s3/
• https://johnmccormack.it/2018/08/how-to-create-a-table-in-aws-athena/

AWS documentation

• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html
• https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ConnectToMicrosoftSQLServerInstance.html
• https://docs.aws.amazon.com/cli/latest/reference/rds/restore-db-instance-to-point-in-time.html
• https://docs.aws.amazon.com/cli/latest/userguide/install-windows.html#install-msi-on-windows 
• https://aws.amazon.com/blogs/database/powering-up-database-mail-on-amazon-rds-for-sql-server-how-under-armour-runs-database-mail-on-amazon-rds-for-sql-server/ 

Thanks

John