SQL Server 2005 - Snapshot Isolation

Course Code: SQSSNA
Duration: 1 day
Audience: Developers, programmers and database administrators.
Prerequisites: At least six (6) months of relational database experience.
Summary: This presentation details how to use SQL Server 2005's new isolation levels for lock avoidance and read consistency, mainly in OLTP environments.
Objectives: Upon completion of this presentation, the participant should understand SQL Server 2005's:
  • Concurrency controls
  • Isolation levels
  • Snapshot isolation
  • Row versioning
  • Isolation level usage and good practices
  • How to monitor isolation levels
Format: Lecture
View full outline in PDF formatDetailed Outline

print  |  top of page