All about SQLServer

In my previous post, l wrote about how to create linked server between On-premise and Azure SQL database.In this post, let us see how to create linked server between On-premise and Azure SQL data warehouse and after establishing linked server, how we can query Azure SQL data warehouse tables from local On-premise SQL Server.I have created Azure SQL data warehouse in my previous postand for this example I have created table "dwtable1" within azure sql dw.Below are the steps to publish linked server connection between On-premise and azure sql dw.