Choosing Data Access Technologies and an Object Model
o Introduction to Data Access Technologies
o Choosing Technologies for Accessing Data
o Building a Data Access Layer
o Designing Data Access from SQL Common Language Runtime (CLR) Objects
o Available Data Object Models for Administering SQL Server
Designing an Exception Handling Strategy
o Exception Types and Their Purposes
o Detecting Exceptions
o Managing Exceptions
Choosing a Cursor Strategy
o Common Scenarios for Row-Based vs. Set-Based Operations
o Selecting Appropriate Server-Side Cursors
o Selecting Appropriate Client-Side Cursors
Designing Query Strategies Using Multiple Active Result Sets
o Introduction to MARS
o Designing Query Strategies for Multiple Reads
o Designing Query Strategies for Mixing Reads and Writes in the Same Connection
o Concurrency Considerations When Using MARS
Designing Caching Strategies for Database Applications
o Why Caching Is Important
o Data and Query Caching in SQL Server 2005
o Using Caching Technologies Outside of SQL Server
o Custom Caching Techniques
Designing a Scalable Data Tier for Database Applications
o Identifying the Need to Scale
o Scaling Database Applications to Avoid Concurrency Contention
o Scaling SQL Server Database Systems
o Scaling Database Applications Using a Service-Oriented Architecture
o Improving Availability and Scalability by Scaling Out Front-End Systems
