CHAPTER 11Data Access

In this chapter, you will learn about:

• Service Broker

• Web services and HTTP endpoints

• Linked servers

• Data access methods—MARS and more

I have traveled the length and breadth of this country and talked with the best people, and I can assure you that data processing is a fad that won't last out the year.

—The editor in charge of business books for Prentice Hall, 1957

So far in this book, we've talked about how to create the database, secure it, and create many different database objects. Generally, we create database objects such as stored procedures, VIEWs, and user-defined functions to limit direct access to the database tables. In this chapter, we'll cover some of the methods beyond traditional database objects ...

Get MCITP SQL Server 2005 Database Developer All-in-One Exam Guide (Exams 70-431, 70-441 & 70-442) 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.