OPENQUERY Flexibility

Connecting SQL Server to SaaS applications with a Linked Server

But nowadays, most services are in the cloud. They're not on your servers; they're somewhere else. With most software-as-a-service (SAAS) offerings, you don't have many options to configure connectivity. What if you need data from one SaaS service into another?

Understanding SQL Server Linked Servers

In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.

A Linked Server Alias

Connect to Sybase with a Linked Server

Learn how to create a Linked Server to a Sybase database instance.

Changing Linked Server Passwords

How to article on changing passwords for linked servers via TSQL and SSMS.

List instances hosting similarly named databases

Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names

Linked server creation to MySQL Server

Here is a step by step procedure to create a linked server to MySQL from SQL Server.

Linked Server Tribulations In SQL Server

In this article, Thomas chronicles the difficulties of troubleshooting a linked server set up, with helpful tips and an exposé of a Linked Server UI flaw.

Show all Objects used by Linked Server

Stored Procedure will list all objects, object type, and linked server name. The stored procedure can either be passed in a linked server name as string or null.