2025-05-19
547 reads
2025-05-19
547 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,480 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,405 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,475 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,825 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
Hi, our peer who owns a remote mysql server from which we extract warehouse...
What is returned as a result set when I run this command without a new seed value?
See possible answers