Really an excellent set of resources (also can be used for reference) that describe the patterns for architecting solutions and security on top of Windows Azure, for teaser something like ASP.NET to SQL Azure: