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?
2024-01-10
In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.
2022-04-25
2020-12-14
596 reads
Learn how to create a Linked Server to a Sybase database instance.
2019-05-30
12,014 reads
How to article on changing passwords for linked servers via TSQL and SSMS.
2017-01-26
15,909 reads
Lists instances, aliased linked servers, and databases pattern matched on the linked server and database names
2016-06-03 (first published: 2016-05-06)
340 reads
Here is a step by step procedure to create a linked server to MySQL from SQL Server.
2014-10-13
3,500 reads
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.
2014-08-05
5,822 reads
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.
2012-09-17 (first published: 2012-08-23)
1,033 reads
Create a linked server on the fly in this tip.
2009-10-06
3,401 reads
By Steve Jones
This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
Comments posted to this topic are about the item Unlimited Text
Hi, I'm trying to make the below query SARGable by removing the ISNULL function...
We're about to upgrade our SQL 2017 Standard to 2022 standard. We have 1...
If I want to get unlimited amounts of data back from a varchar(max)/nvarchar(max) column, what do I run?
See possible answers