As I’ve mentioned a couple times already our PASSMN meeting tonight will be in a new location. This is a one month change due to a scheduling conflict. This month we’ll be meeting in the room above the Caribou across the skyway from our regular location.
5:00 –5:15 : Announcements
5:25 –6:45 : Isolation vs Concurrency: What Are the Choices?
6:45 –7:00 : Survey Collection and Giveaways
Kalen Delaney (blog) will be speaking this month and she’ll be talking about the following topic:
Isolation vs Concurrency: What Are the Choices?
What does it mean to have data isolation? In this presentation, we’ll look at the four different ANSI isolation levels and the new one, Snapshot Isolation, added in SQL Server 2005 to see how much isolation each provides and what behaviors—such as Dirty Reads, Nonrepeatable reads, and Phantoms—are possible in each level. We’ll discuss what consistency might mean to your applications and what the trade-offs are as you choose a higher isolation level to enable greater isolation and consistency. We’ll also discuss the difference between the optimistic and pessimistic concurrency models and look at the relationship between isolation level and concurrency models to see how the various isolation levels work in either an optimistic or a pessimistic manner.
Help us plan for the meeting and RSVP here.