The small review by Tim was excellent.

I am just starting with SQL Azure and was going through diff documents available under MS Windows Azure site.

As far as i understand its not a very good platform for data warehousing applications and can only be usefult for small OLTP applications. One of the case studies given in MS Site is of 3M where they have implemented Azure to host a complex visual designing system which runs complex algorithms in parallel but not very sure how much of it was in Azure and how much on premises.

Hope to find many more Azure developers soon.;-)