O'Reilly logo

All-In-One MCITP SQL Server 2005 Database Developer by Darril Gibson

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

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 ...

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