How do I... Query foreign data using SQL Server's linked servers?

Sometimes, the data you need is in a non-database format or resides on a different server. Fortunately, SQL Server is flexible enough to offer a number of ways to get it. One of the easiest methods is to directly link to the data via a linked server. Here's how it works.

This download is also available as a blog entry.