AWS

SQLServerCentral Article

Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide

  • Article

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2025-01-29

1,314 reads

SQLServerCentral Article

AWS Services Using SQL for Big Data Analysis

  • Article

AWS offers a robust suite of tools designed to manage big data effectively. This article explores focusses on how SQL is leveraged within Amazon Redshift and Amazon Athena. We will delve into the technical features, practical applications, and step-by-step examples for using these services, highlighting how they can transform raw data into actionable insights for your business.

2024-10-16

350 reads

Blogs

ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish

By

I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...

Beginner’s Guide: Create a File Organizer CLI Tool in Rust

By

Image from Afdhaluddin on ShutterstockCLI which is generally referred to as Command Line Interface...

The Third Sabbatical

By

I can’t believe I’ve been at Redgate long enough to get a third sabbatical....

Read the latest Blogs

Forums

Slot jepang

By Andpyxa

Slot jepang

Azure Database Watcher Monitoring

By bokswager

Hi, I’ve provisioned an Azure Database Watcher to monitor our 4 Azure SQL Managed...

Can You Ask for a Raise?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can You Ask for a...

Visit the forum

Question of the Day

Generating a Series I

What is returned by this code in SQL Server 2022? 

SELECT value
FROM GENERATE_SERIES(4, 1);

See possible answers