Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

Archive for September 7th, 2010

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_LogoIn order to RSVP for the event you will need to login to the national PASS site and click on the RSVP link.  The sponsor for this month’s meeting is Microsoft User Group Support Services.image

PASSMN September 2010 Meeting – Isolation vs Concurrency: What Are the Choices?

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!

Posted in Training | Tagged: | Leave a Comment »