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,054 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

343 reads

Blogs

A New Word: Tangency

By

tangency– n.  a fleeting glimpse of what might have been. I tend to live...

Join me at the Microsoft Fabric Community Conference with a discount code

By

I’m excited to be speaking at the Microsoft Fabric Community Conference this year, which...

Is Your Business Truly Ready for AI?

By

The AI revolution isn’t coming – it’s here. Companies are racing to integrate artificial...

Read the latest Blogs

Forums

Several Questions: Relationships and SSMS and Data Diagrams

By Ahr Aitch

I'm struggling setting relationships among tables.  I understand the one-to-many, many-to-one, many-to-many, and self-referential...

Query Help to show record in single row

By sqldba20

Hi All, need help with an SQL query. We have an existing table that's...

MSDTC not available on Windows 2022 clustered SQL 2019 CU30

By Johan Bijnens

I connect to this clustered instance and run : begin distributed transaction Msg 8501,...

Visit the forum

Question of the Day

Counting Bits III

What is the output of this code in SQL Server 2022?

select bit_count(0xEF)

See possible answers