Enjoying the fall here in Minnesota? The leafs are changing a bit and temp has been dropping. Has that left you feeling a little isolated? Maybe it’s time to get together with some likeminded peers and talk about SQL Server. This month’s PASSMN meeting will have Kalen Delaney (blog) in town talking about isolation and concurrency.
Things might feel a little off still though because this month we’ll be meeting in a different place. The new location won’t have internet access which means some of the fans that we usually have join us over the intertubes won’t be there to keep us company. This should only be an issue this month.
September Meeting Location
So… since our normal room at the Microsoft Offices got double booked. 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
As I mentioned, Kalen will be speaking and she’ll be speaking on 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.