O'Reilly logo

Microsoft® SQL Server® 2008 Bible by Uttam Parui, Mike White, Paul Nielsen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Part V. Data Connectivity

IN THIS PART

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required