9/08/2007 4:51:36 PM
SQL Server 2005 offers two models for an application to provide data consistency: Pessimistic and Optimistic Concurrency Control. In this session we’ll discuss what consistency might mean to your applications, and describe the costs and tradeoffs between the two Concurrency Models that SQL Server 2005 supports through different transaction isolation levels. We’ll also look at the internal differences between the isolation levels.
Kalen Delaney is one of the most widely recognised names in the global SQL Server community. Kalen is the author of "Inside SQL Server" for the 2005, 2000 & 7.0 editions (all MS PRess) as well as a number of other SQL Server books and many technical articles. Not only is Kalen one of the most accomplished SQL Server authors, Kalen has spoken at many conferences including TechEd, PASS, SQL Server Connections, SQL Server Magazine Live, WinSummit and SQLU Summits in many countries. Kalen has worked dailey with SQL Server since joining Sybase corporation in 1987 and has been a SQL Server MVP since 1993. Kalen was one of the founders of www.SolidQualityLearning.com.au, a leading provider of expert SQL Server training and is delivering her "SQL Server Internals & Performance Tuning" Master Class in Australia in Melbourne starting August 20th. She lives in the beautiful Pacific Northwest, a ferryboat ride away from Seattle with her husband Dan & 3 of her four children who are still at home.
Venue: Microsoft Level 5, Building 4, Freshwater Place, Southbank , Melbourne, VIC |
Duration 5:30PM pizzas & drinks for 6:00 start, approx 7:30 pm finish |
On: Tuesday, 21 August 2007