My employer began using SQL Azure several months ago, but during the past 2-3 months the quality of service has markedly decreased. To date we've experienced at least one system-wide outage (defeats the purpose of a cloud solution to begin with); we've also been struggling for weeks with how to handle with Azure's aggressive connection management behavior. Plus, there's the Azure-enforced T-SQL limitations to deal with: no more SELECT... INTO in stored procedures, unable to change column data types of columns in an existing clustered index without recreating an entire table, etc etc. And while we're not ready to jump ship just yet, I have been asked to investigate alternatives.
An Amazon cloud solution -- some combination of EC2/RDS/EBS/S3 for for web hosting, OLTP and backups -- seems like a pretty good place to start, especially since they offer a free 30-day trial. I've seen plenty of suggestions for migrating from SQL Server to Azure, but not so much on migrating away from SQL Azure and into Amazon RDS. Does anyone have ideas or suggestions on where to look?