Two tiers of the Web version are now available as well (<= 1GB, and <= 5GB)

Geometry, Geography, and HierarchyID types (based on the SQL CLR) are now supported

On July 1st, users of the the Content Delivery Network (CDN) are now being billed for data transfers ($0.15/GB in the US) and transactions ($0.01/10,000). These charges are for the transfer of data from the edge-point to the consumer. Charges for moving the data from the actual Azure data center to the edge-point follow the normal Azure storage rates, which are actually the same as the CDN rates for the US.

On a slightly related note, I just published a screencast of my Northeast Roadshow presentation from March(!) covering Azure storage, SQL Azure, and WCF Data Services – with some updates (of course) given the announcements since then.