An enormous 95-slide deck has been published as a briefing on cloud computing at MS and the Azure platform.
Slide 67 has some of the features in and out of SQL Azure.
What’s not supported:
- XML, HierarchyID, Sparse Columns, Filestream data types. (XML support would be a biggie for some clients)
- Full-text indexes (again, some clients leveraging this)