“A picture is worth a thousand words” –> so here are those thousand words:
But remember that the list is based on the features and limitations (because nothing is perfect, Eh!?) of SQL Azure as on July 2011. And thanks to the ever evolving nature of SQL Azure, some of the missing features will be provided in near future. But basically, SQL Azure VS SQL server is an open ended question – it means different things in different context and it’s better discussed when the context is known.
please do drop your feedback/comments/advice/(random text of string) in comments section. if you really do that – Thanks!
After the SU8. Read What’s new in SQL Azure