PASSMN September 21, 2010 Monthly Meeting
Posted by denglishbi on September 7, 2010
The next Minnesota SQL Server User Group meeting is on Tuesday, Sept 21. This month we be meeting in a different location across the skyway over in the 8000 building on the 2nd floor above the Caribou Coffee shop. We are pleased to announce that Kalen Delaney will be presenting this month – www.SQLServerInternals.com.
PASSMN September 2010 Meeting – Isolation vs Concurrency: What Are the Choices?
- Meeting sponsor: Microsoft UGSS
- Location: 8000 Norman Center Drive, 2nd Floor, Bloomington, MN 55437
- Please RSVP here for the event to assist in making sure there is enough snacks and beverages ordered.
- Live Meeting URL: no live meeting due to location change
Agenda:5:00 –5:15 : Announcements
5:25 –6:45 : Isolation vs Concurrency: What are the Choices?
6:45 –7:00 : Survey Collection and GiveawaysPresentation:Isolation vs Concurrency: What are the Choices? (presenter Kalen Delaney) – 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.
One other thing to mention is that next month we will not be having our regular monthly meeting. Instead we will be having an all day free event out at Mystic Lake Casino in Prior Lake on Friday, October 29 – SQLSaturday #58 – Minnesota 2010, Oct 29. Registration for this event will be required so that we can properly order the food and organize the space required for the event. This will be a similar event like last year where we had different tracks (DBA, BI, SQL Dev) and multiple sessions (presentations), just like the launch event earlier this year as well.
Please spread the word in regards to both of these events!