READPAST & Furious: Transactions, Locking and Isolation

Do you really understand SQL Servers’ Concurrency behavior?
Do you really believe that Transactions are an ALL or NOTHING operation?
Do you really think that Read operations cannot start a Transaction?
Do you really know that READ_UNCOMMITTED is safe for reporting?

I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to those questions and more and will make you wish you had known about all of this sooner.
Presented by Mark Broadbent at SQLBits IX
Tags (no tags)
  • Downloads
  • SpeakerBIO
    Mark Broadbent is a SQL Server MCM and speaker with extensive experience working with numerous HADR & upgrade solutions and deployments. In 2011 he was awarded Microsoft's Community Contributor award and in 2012 also received the PASS Outstanding Volunteer award. Mark currently serves as a PASS UK Regional Mentor, is the founder and event lead to SQLSaturday Cambridge (the UK's first SQLSaturday) and runs the Cambridgeshire SQL User Group which is a PASS Chapter. He has previously presented at SQLBits 7/8/9/X/XI, SQLRally 1/2, SQLRelay, PASS Summit 2011/12 and SQLSaturday's Lisbon, Dublin, Edinburgh, New York, Cambridge and Portland.
    http://tenbulls.co.uk http://tenbulls.co.uk/feed/
  • Video