Distributed Queries

SQLServerCentral Article

Updating AS/400 Linked Server Tables from SQL Server

  • Article

One of the strongest features of SQL Server is the ability to connect to disparate data sources and perform queries across multiple sources. New author Basu Hullur brings us a technique that he used to update data on the AS/400 in a much quicker way than previously.

5 (1)

You rated this post out of 5. Change rating

2007-09-22 (first published: )

44,082 reads

External Article

Connect to Lotus Domino using SQL Server Linked Server

  • Article

Many Enterprises create and maintain applications that reside on "IBM Lotus Domino Server." Since the Lotus Domino server has the capability of handling applications and messaging, it has become a prime requirement for a SQL Server DBA to cross- reference data or import and export data to and from the Domino database and SQL Server databases. In this article, I am going to discuss how to use SQL Server Linked server to connect to databases that reside on the Lotus Domino server. The steps involved in connecting to the Lotus notes mail server database can be used for connecting to other databases that reside in "Lotus Notes Domino" server.

2005-01-31

2,430 reads

SQLServerCentral Article

Oracle Link

  • Article

SQL Server is the best RDBMS, at least according to the current thinking at SQLServerCentral.com, and is fully capable of meeting all of your database needs. However not all database systems run on SQL Server and it seems that we often see data from some other system being consolidated on SQL Server for additional processing or reporting. DTS usually handles the load, but there are times that you might want create a linked server to an Oracle system for updating individual rows. New author Adria

4.4 (5)

You rated this post out of 5. Change rating

2004-12-29

17,443 reads

SQLServerCentral Article

An Introduction To Linked Servers

  • Article

Linked Servers are an interesting technology in SQL Server to allow remote access from within the database to external data sources. They can be a boon in a heterogenous environment with other Oracle, DB2, etc. data sources. But they can also help in a smaller scale against those "hidden" datasources like Excel or Access. New Author Krishna.

3.14 (7)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

47,894 reads

Blogs

MVP No more, But It’s OK

By

Embracing Limitations: Finding Strength and Purpose in Hard Times For four years, I was...

A New Word: Fitching

By

fitching – v. intr. compulsively turning away from works of art you find frustratingly,...

Copilot in Microsoft Fabric

By

Microsoft Copilot is an app that uses AI to help you find information, create content,...

Read the latest Blogs

Forums

Pase keywords in text string

By Bruin

I've been trying to find an example to parse a record that looks for...

Exploring Generative Adversarial Networks (GANs) for Butterfly Image Generation

By Rohit Alladi

Comments posted to this topic are about the item Exploring Generative Adversarial Networks (GANs)...

A Valid Type?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Valid Type?

Visit the forum

Question of the Day

A Valid Type?

What happens when I run this code in SQL Server 2019?

DECLARE @variable CURSOR;

See possible answers