September 2008
Beginner to intermediate
768 pages
17h 40m
English
book
Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
by Robert D. Schneider, Darril Gibson
Content preview from Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
IV.6.1. Data Everywhere: Remote Applications to the Rescue!
When running SQL Server, it's highly unlikely that you'll be running it on your desktop system. Instead, you'll run SQL Server 2008 on a server product (such as Windows Server 2003 or Windows Server 2008) and access your SQL Server 2008 database over the network.
Moreover, you're not limited to only the data held on a single SQL Server. A distributed query is used to access data from different data sources through SQL Server. In other words, the distributed query is executed against SQL Server, but pulls data from somewhere else.
By using distributed queries, you allow your applications to be remote applications. The applications can run from anywhere and can access data from any other data source as long as they can establish connectivity with a single SQL Server. Of course, the SQL Server must have access to the other data source; that is, there must be connectivity and permissions must be granted.
Figure 6-1 shows how a distributed query works. The client application queries SQL Server. SQL Server then uses an Object Linking and Embedding Database (OLE DB) provider to query data from another data source, such as another SQL Server, Oracle, or Microsoft Access database — any data source with an Open Database Connectivity (ODBC) driver. This is by no means a complete list. Just about any data source that enjoys some level of popularity has either an OLE DB or ODBC provider that can be used.
Figure IV.6-1. Querying data ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.