Isolation vs Concurrency: What Are the Choices?
Presenter: Kalen Delaney, SQLearning
Session 08: September 15 at 19:00 GMT
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.
About the Speaker
Kalen Delaney has been working with SQL Server for almost 23 years and provides advanced SQL Server training to clients around the world, using her own custom-developed curriculum. She has been a SQL Server MVP since 1993 and has been writing about SQL Server almost as long.
Kalen has spoken at dozens of technical conferences, including every PASS conference in the US, since the organization’s founding in 1999. She is a contributing editor and columnist for SQL Server Magazine and the author or co-author of several of the most deeply technical books on SQL Server, the most recent being SQL Server 2008 Internals, from Microsoft Press. Kalen blogs at sqlblog.com, and her personal website and schedule can be found at www.SQLServerInternals.com.
Register now for 24 Hours of PASS!