Some good news out of Microsoft last week, SQL Azure now supports spatial types:

Spatial Data Support - SQL Azure now offers support for the Geography and Geometry types as well as spatial query support via T-SQL. This is a significant feature and now opens the Windows Azure Platform to support spatial and location aware applications.

Brilliant if you ask me!