Grant Elastic Beanstalk Environment Access to RDS Automatically

Today, let’s take a colloquial look at automatically granting ingress access to your Elastic Beanstalk apps that need to use RDS resources. When we first started, we brought up our RDS instance and our Elastic Beanstalk instance. The two weren’t connected. Of course, as soon as the instance tried to connect to the SQL Server, it couldn’t. Why? Because the RDS security group blocks all access by default, only allowing in what you specify.…

AWS Security Group Secures RDS by Default

Turns out, AWS security groups secure your stuff, even if you don’t know it. At my employer, we finally got access to Amazon Web Services (AWS) and Vinyl Deals runs on Microsoft’s Azure cloud. Despite the fact that I’ve written articles about AWS before, my familiarity with modern AWS is still in the beginning phase. On day one playing with our shiny new AWS tools, I set up a development SQL Server using RDS.…

How To Use SQL CLR in Amazon AWS RDS

Recently, I went over how to setup SQL Server on Amazon RDS from within Visual Studio. In that article, I noted that there are differences between SQL Azure and SQL Server on Amazon RDS and that we needed more work to thoroughly investigate any limitations of SQL Server on RDS. I specifically called out the ability to run .NET assemblies (otherwise known as SQLCLR) as a possible deal breaker for some.…

Get Started With Amazon AWS RDS SQL Server

In the past, if you were a SQL Server shop and wanted to use the Amazon AWS cloud, your only option was to bring up Windows Virtual Machine instances and run those machines just like your on premises machines. With the new Amazon RDS SQL Server options, developers and IT shops can now spin up standalone SQL Server databases without having to worry about the machines that are hosting those databases.…