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:

• My posts on Microsoft Azure

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.