Hi I wanted to write this post a long time ago but have not had the chance, so now with the new year - this will be the first post for 2016. Cross Database Queries in SQL Azure DB was a key feature that was missing from day 1 on SQL Azure DB. Finally we have this key feature, and no, it is not the same as in the regular SQL Server. We have a new way to do this. It is bases on the new key feature in SQL Server 2016 called "External Tables" ( https://msdn.microsoft.com/en-us/library/dn935021.aspx ). Also known as " PolyBase ". The logic behind the feature is that you can query tables with-in your DB (like you are doing today) and also at any other DATA source like it is a table within the DB. From one SQL Azure DB to another we can not connect to it via linked server. However a second SQL Azure DB is referenced like any other external data source. Microsoft thinking is that SQL Azure DB is another DATA sources for External tables (
All About Azure SQL DB, CloudComputing, SQL on the Cloud, and Big Data Platform. That any Data Position Needs to Know.