Linked Servers

In this tip we review how to configure a SQL Server linked server into Snowflake and a few use cases of how this solution would be beneficial in a production environment.

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

In this tip we look at how to create and use a linked server between Amazon Redshift and SQL Server.

I was trying to use OPENROWSET to query a remote database and I got the following error Ad hoc access to OLE DB provider has been denied error. You must access this provider through a linked server.

In this tip we will cover how to create a linked server with a constant name that points to different servers depending on what servers we are working with.

Linked servers are used to query remote databases and in this tip we will learn how to configure a linked server for a MySQL server from SQL Server.

There are often times when you need to access data from MySQL from within SQL Server. You could export and import the data, but another option is to create a linked server from SQL Server to MySQL. In this tip we walk through how this can be done for MyS

Linked servers are great to query remote databases, but when running update queries they don't always behave like they should. In this tip I will show you a situation where several queries worked fine, but a few did not behave as planned. I will also sh

Learn how to solve this linked server error - The OLE DB provider for linked server could not map ordinals for one or more columns of object DBSCHEMA_TABLE_STATISTICS.

You have data in SQLite databases on mobile devices you would like to import into SQL Server. In this tip we walk through the steps on how to import this data into SQL Server.

My boss is asking for a list of email addresses and phone numbers for all users in the company. I know this data exists in Active Directory, so how can I access this data from SQL Server?  In this tip we walk through how you can query Active Directory fro

Every DBA is faced with the task of occasionally refreshing their databases from Staging to QA to Development. A while back I started working on a project where we were building out a new environment and our DBA team was frequently tasked with refreshing

Creating linked servers is generally a pretty easy thing to do, but the creation of a link server with DB2  is not as simple. To create a linked server to DB2, it requires the SQL DBA to know or guess a lot of parameters that are not familiar or intuitive

You need to quickly check all linked server connections for a given instance or list of instances for SQL Server. In this tip I present a PowerShell script that can be used to quickly check all linked servers.

If you have the need to import many tables using Linked Server whether it be from SQL Server to SQL Server or other database platforms this tip shows how you can dynamically load and automate the process.

I am trying to create a stored procedure which creates a linked server connection, performs a query against the linked server, and then tears down that connection. I don't want the connection to be up at all times, hence the reason I want to create the co

I am trying to create a stored procedure which creates a linked server connection, performs a query against the linked server, and then tears down the linked server connection. I do not want the connection to be up at all times, hence the reason I want to

In this tip we look at how to install and configure linked servers for SQL Server and Oracle 64 bit client.