CHAPTER 11CREATING AN ABSTRACTION LAYER IN SQL SERVER

Our journey has brought us a long way, and now we’re near the end. At this point you should have a fully working physical database complete with all the appropriate indexes. This is the time when many database modelers stop their work and toss the database over the wall for the DBAs to implement and manage. If you choose that course, you may be just fine, but you might also be setting yourself up for failure. In its current state, access to the database will be pieced together by the application developers, and trust us when we tell you that most application developers do not understand how to access a database in the best way.

No, to be complete you have one more step, one last thing to build ...

Get A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.