SQL DBA Blog

Tag: Linked Servers

Creating a Linked Server with a MySQL Database

July 15, 2020

This is my 3rd Linked Server demo post, and this time it’s to a MySQL database. Noteworthy weblinks: > My Linked Server Blog Posts > Microsoft Docs – Linked Servers Here is a simple diagram of the setup in this post. The above was setup similar to what’s…
Read More
Creating a Linked Server for a PostgreSQL Database

March 10, 2019

This is a post on how to create a Linked Server to a PostgreSQL database. In my previous post, I created a Linked Server to another SQL Server instance. This time, it’s a link to a Postgres database. I recommend checking out my other post for pre-requisite information…
Read More
Creating a Linked Server to SQL Server

March 4, 2019

Linked Servers in SQL Server allow you to query external databases, such as remote SQL Server instances, Oracle, ODBC or MS Access databases. It provides easy query access to another database server for users, however it’s not the most efficient ways to do it. The following steps should…
Read More

Recent Posts

How to Open PowerShell as AdministratorFebruary 17, 2025
How to Filter Objects in SSMSFebruary 15, 2025
The Evolution of Microsoft SQL ServerFebruary 15, 2025
SQL Server Script: Enable or Disable All SQL Agent JobsFebruary 15, 2025
Database cannot be opened, it is in the middle of a RestoreFebruary 14, 2025

Categories

– AWS
– DBA Stories
– Linux
– MySQL
– Other
– Postgres
– PowerShell
– Redshift
– SQL Server
– Windows Server

Tags