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.

How to copy multiple tables to Azure blob using Azure data factory

In my previous article, I wrote about introduction on ADF v2. In this post, let us see how to copy multiple tables to Azure blob using ADF v2 UI.

For this example, I have created tables named Test, Test1 within Azure SQL database - Source for the copy operation.

I have created Azure blob with Container called myfolder - Sink for the copy operation.

To copy multiple tables to Azure blob in JSON format, created
Pipeline1 - For Each activity with Copy activity
Pipeline2 - Lookup activity and Execute pipeline activity

Lookup activity provides the list of tables, output of Lookup are mapped to Object type parameter. For Each activity on each iteration (tables list in object parameter) provides the table name to source & sink within copy activity.

Below are the steps: