While this is normal for many businesses, for start ups this is an extra expense – it means that the servers are either configured by developers or operations staff, or that the company has to bring a DBA on board sooner than they had planned. Companies using the Microsoft stack but invested in AWS have had to set up and configure their own SQL Servers. The problem is that there hasn’t been a way to do this with SQL Server. Backups happen automatically, restores are easy to accomplish, and instances can be easily added or removed. Instead of setting up and configuring servers for MySQL or Oracle, customers can have a database server up and running in a few clicks. The point is to take a lot of the headache out of managing relational databases. Relational Database ServiceĪmazon Relational Database Service (RDS) is Amazon’s attempt at creating a hosted database platform on top of the other AWS services.

Configuring SQL Server in AWS environment isn’t the easiest thing on earth: the technology behind the AWS platform changes on a regular basis and it sometimes changes in subtle ways that can change how SQL Server performs. That’s not a bad thing, but it’s something that many teams have to keep in mind.

Unfortunately, you still have to administer and configure your servers. AWS hosts a variety of businesses, large and small. When you say “cloud”, a lot of people think of AWS. Amazon Web Services (AWS) is a platform that offers a ton of services ranging from block storage, operating systems, to mail queues, DNS, and caching.

Aws rds sql server connection string