Amazon RDS Now Supports SQL Server 2012

The Amazon Relational Database Service (RDS) now supports SQL Server 2012.You can now launch the Express, Web, and Standard Editions of this powerful database from the comfort of the AWS Management Console. SQL Server 2008 R2 is still available, as are multiple versions and editions of MySQL and Oracle Database.

If you are from the Microsoft world and haven't heard of RDS, here's the executive summary: You can run the latest and greatest offering from Microsoft in a fully managed environment. RDS will install and patch the database, make backups, and detect and recover from failures. It will also provide you with a point-and-click environment to make it easy for you to scale your compute resources up and down as needed.

What's New?
SQL Server 2012 supports a number of new features including contained databases, columnstore indexes, sequences, and user-defined roles:

• A contained database is isolated from other SQL Server databases including system databases such as "master." This isolation removes dependencies and simplifies the task of moving databases from one instance of SQL Server to another.
• Columnstore indexes are used for data warehouse style queries. Used properly, they can greatly reduce memory consumption and I/O requests for large queries.
• Sequences are counters that can be used in more than one table.
• The new user-defined role management system allows users to create custom server roles.

Read the SQL Server What's New documentation to learn more about these and other features.

Launch Now
You can launch SQL Server 2012 from the AWS Management Console. First you select the edition that best meets your needs:

Then you fill in the details (SQL Server 2012 is version 11), and your DB Instance will be launched in a matter of minutes:

Yes, This is Cool!
You can now get started with SQL Server 2012 without having to invest in hardware or buying a license. If you are eligible for the AWS Free Usage Tier,  you can get started without spending a penny. You can launch a DB Instance, evaluate the product, do a trial migration of your data, and learn all about the new features at minimal cost. When the time comes to move your organization to SQL Server 2012, you'll already have experience using it in a real-world environment. That certainly can't hurt your career.

-- Jeff;

 

Comments

[Bobby Warner]

When will RDS support PostgreSQL?

[James]

Bobby I wouldn't hold my breath, obviously supporting an open-source, reliable, largely SQL standard compliant RDBMS isn't a priority for Amazon RDS.

[JB]

Hi,

Maybe I should be asking these questions in the support forum, if so, my apologies, but two questions.

1: Why is it that when I "modify" my MS SQL Server instance, I'm able to set "Multi-AZ" deployment to "Yes". However, if I try to launch a new SQL Server instance, I'm NOT able to choose "Multi-AZ Deployment" as "Yes"?

2: If I have an existing 2008 instance, I notice I'm able to "modify" my instance and choose the 2012 version.. but is that a supported way of upgrading to the new version?

Thanks!
JB

[Cjstevenson7791]

This announcement doesn't say whether or not RDS supports Multi-AZ and automatic failover.

[Gerardo Delgado]

This is a great addition to the RDS family and I will be implementing this soon in my VPC. I would like to know if the same multi-AZ feature as is available in MySQL and Oracle RDS will be available for the SQL RDS. I have some mission critical production applications I would like to put on SQL RDS but a little reluctant to do that till a multi-AZ feature is available for SQL RDS.