2025-05-19
548 reads
2025-05-19
548 reads
Linked servers in Amazon RDS for SQL Server allow seamless connectivity to remote databases for distributed queries and data integration. In this article, I guide you through the step-by-step process of creating a linked server using SQL commands, from setting up authentication to testing the connection. Learn best practices, advanced configurations, and essential considerations, including why you can't use SSMS for linked server setup in RDS. This professional guide is tailored for experienced database administrators looking to optimize cross-server operations.
2025-01-29
1,496 reads
In this tip we look at how to setup a Linked Server in SQL Server using SQL Server Management Studio.
2022-04-25
Learn how to perform data filtering in Oracle Linux using a database link to SQL Server
2020-04-13
2,407 reads
2017-02-16
1,044 reads
A quick guide on changing the linked server properties and settings.
2018-09-03 (first published: 2016-07-07)
34,544 reads
2011-11-03 (first published: 2011-10-21)
1,747 reads
There is an inprocess setting for linked servers. Have you ever used it? Gianluca Sartori gives a look at what the implications are for this.
2011-06-09
23,878 reads
By Chris Yates
Trust is the currency of the data economy. Without it, even the most advanced...
By Steve Jones
Another test with Copilot in SSMS (v22 P3) that didn’t go so well. This...
By Kevin3NF
If your production SQL Servers are still running 2016 (or older) you’re basically banking...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item SQL Server Ghosts
Comments posted to this topic are about the item The Selfish Case for Learning...