How to create linked server between On-premise and Azure SQL data warehouse

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 post and 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.


How to reset azure sql admin password

In this post, I have shared the resource which explains different ways to reset azure sql admin password

1) From Azure portal - >SQL Server Overview page -> Reset Password
2) From Powershell -> using Azure CLI command - az sql server update 
3) From Powershell -> using power shell command - Set-AzureRmSqlServer
4) From SSMS -> using t-sql command - ALTER LOGIN

Reset lost admin account password

See Also:

How to delete files in Azure data lake store

In this post, let us see how to delete files in Azure data lake store using powershell and Azure CLI commands.


I have created Azure data lake store with account name trndls and uploaded some JSON files.