Designing a Strategy to Manage Data Across Linked Servers
Users often need to query data stored on multiple and sometimes disparate systems. You must provide a method for users to have their data available and to query the data as though stored on the system the users are initially logging into. Your solution should allow users to issue queries that reach beyond the data in their server to include the remote data they have permission to access. This solution needs to provide access to the remote server as well as the ability to address diverse data sources in a similar manner. Your solution is linked servers (see Figure 8.1).
FIGURE 8.1 Linked servers
Linked servers begin their processing when an application requires a result set that is at ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
