Part V. Data Connectivity
IN THIS PART
Chapter 30: Bulk Operations
Chapter 31: Executing Distributing Queries
Chapter 32: Programming with ADO.NET
Chapter 33: Sync Framework
Chapter 34: LINQ
Chapter 35: Asynchronous Messaging with Service Broker
Chapter 36: Replicating Data
Chapter 37: Performing ETL with Integration Services
Chapter 38: Access as a Front End to SQL Server
As much as I'd like to think that Management Studio is the ultimate UI and there's no need for any other interface to SQL Server, the truth is that SQL Server needs to connect to nearly any possible data conduit.
Other than Chapter 5, "Client Connectivity," all the code so far has occurred inside SQL Server. Part V focuses on myriad ways that data can be brought into and synchronized with SQL Server.
Some of the connectivity technologies are well known and familiar technologies like the simple but mighty bulk insert, distributed queries and linked servers, ADO.NET, replication, and Microsoft Access.
Other connectivity technologies are newer. Integration services replaced DTA with SQL Server 2005. Service Broker was also introduced with SQL Server 2005. LINQ and Synch are new with SQL Server 2008.
If SQL Server is the box, then this part busts out of the box and pumps data in and out of SQL Server.
Get Microsoft® SQL Server® 2008 Bible 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.
