I know I am a bit late with this post, but wanted to spread the news of the changes to the pricing for SQL Azure. I have been looking at this myself lately because I am debating moving hosting companies and might need the extra SQL space.
SQL Azure had two options to start with. This was a 1G database for $9.99 or a 10G database for $99.99. This is an easy to figure out linear system. It looks like there are people that wanted something else in-between and even larger.
They are setup for the smaller users and then targeting large databases. But you are limited to 50G right now. So if you need a larger one, you will have to split it up to use Azure. I am looking at using this for a project or two that I am working on. It is not a bad price and using SQL Azure should be as simple as normal SQL Server. If/when I get a database setup with this, I will be sure to post about it.