FYI, we announced new features on SQL Azure today, including SQL Azure as a distributed query target for SQL Server:

http://blogs.msdn.com/b/windowsazure/archive/2012/09/19/announcing-updates-to-windows-azure-sql-database.aspx