Module 1 - Accessing Data with SQL Server 2005
Accessing Data Over The Years
Reaching The Server
MDAC vs. SQLNCLI
Demo - SQLNCLI
ADO.NET SqlClient
Native XML Web Services
Remote Data Calls
Data Access Layers
Data Pooling
Demo - Connection Pooling
CLR in SQL
SQLNCLI Objects
Managing SQL Server Objects
Module 1 Review
Module 2 - Exception Handling Exception Handling
Exceptions, Bugs, Defects
Severity Levels
Patterns to Creating Exceptions
How to CATCH the Exception
Deadlocks
What Is Done With Errors?
Demo - Recognizing and Dealing with Errors
Even If Code is Good…
Module 2 Review
Module 3 - Cursors and Sets
Cursors Have Their Place….
… Yet, Not Usually in SQL Server
So, Why Do We Create Them?
Thoughts on Refactoring
A Good Use for Pivots
CTE’s Make Life Easier
Server Side Cursors
Client Side Cursors
Demo - Data Connection
Module 3 Review
Module 4 - Multiple Active Result Sets
Destination - MARS
MARS Depends on Client Libraries
Snapshot Isolation in MARS
System Catalog Views
Demo - Snapshot Isolation
Interleaving
Data Manipulation Practices With MARS
Lessons on MARS
Module 4 Review
Module 5 - Store Your Cache for Databases Applications
Demo - Cache
So Much Cache! Where to Begin?
Balance the Budget
DataSet Benefits
Denormalization is Not a Bad Word
Let Someone Else Hold Your Cache
Persist Data at Client
Module 5 Review
Module 6 - Serve Several Requests with a Scalable Architecture
High Availability vs. Scalability
Scalability Up or Out
It’s All About Your Attitude
Spreading the Databases
Partition Tables & Indexes
Distributed Data Options
Not All Requests Are Alike
Demo - Set Operations
Demo - External Data
Designing the Middle Tier
Component Services
Service Oriented Architecture
Bypass the Physical Middle Man
Demo - CLR
Scaling Out Application Servers
Module 6 Review
Course Closure