If you’re running SQL Server on Amazon EC2, there are some new options that may well work out less expensive.
Amazon has added the option of running SQL Server on its Standard Small and Medium instance types, so lowering the minimum size of a SQL Server database instance on EC2.
Another option that is being added is support for SQL Server Web Edition. Web Edition is similar to SQL Server Standard Edition, but costs less. It does lack some features that might be useful, including the SQL query edit and design tools, support for version control, and the MDX edit, debug, and design tools.
The pricing looks good, though. On a Small instance type, you’d pay a default usage of $0.115 per hour. Add in SQL Standard and the cost rises to $0.629 per hour, but SQL Web Edition is just $0.155 per hour.
Amazon has also added the ability to use SQL Server 2012 on EC2.
Amazon announced a raft of improvements to its databases at its AWS Summit in San Francisco, ranging from accelerators for DynamoDB to the ability to query exabytes of unstructured data directly in S3 [ ... ]