CHAPTER 6Protecting the Integrity of Your Data

What person would spend hundreds of hours outfitting their home with the perfect furnishings to keep the occupants comfortable, only to neglect to erect a roof and walls to keep out the bugs, the burglars, and even the weather?

—Me

Yes, it does seem pretty silly, but the fact is, many people spend tremendous amounts of time designing the correct database storage (or at least what seems like tremendous amounts of time to them) and then just leave the data unprotected. To be honest, I know what some people are thinking. "This is what the data access layer is for." I couldn't agree more . . . and less. Do you stop protecting your home with a few walls? That depends on where you live, I suppose, but ...

Get Pro SQL Server 2008 Relational Database Design and Implementation 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.