Wednesday, 15 November 2017

Creating a Linked Server to an Azure SQL Database

Why would you create a Linked Server to an Azure SQL Database?

If you work in a hybrid environment with some databases stored on your on premises SQL Server instances and you also have deployed some databases to Azure SQL Database, maybe you have archived a bunch of data up to the cloud to free some space on your on premises servers but you still want to query that data.  You might want to query the azure SQL Server databases from your on-premises SQL Server instances for a whole bunch of other reasons too. Then you might want to create a Linked Server to your Azure SQL Database

In this short video David talks you through the process of creating a linked server to an Azure SQL databases

You can download the free ebook: Putting Your Head in the Cloud: An Introduction to Cloud Computing and Azure SQL Database

If you have any questions, please leave them in the comments

No comments:

Post a Comment

Featured post

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...