Concurrency is probably one of the most important subjects in SQL Server, but one of the least talked about -and one of the most misunderstood. We will attempt to delve into the world of Transactions, Locking and Isolation and reveal some of SQL's dirty little secrets.
Do you really understand SQL Servers’ Concurrency behavior? Are you sure that Transactions are an ALL or NOTHING operation? Do you believe Read operations cannot start a Transaction? Do you really know if READ_UNCOMMITTED is safe for reporting? Is being Optimistic *really* better than being Pessimistic? Is SQL Server 2012 be the solution to all our problems or our worst nightmare? I look forward to you joining me in this very revealing and thought provoking session where I will provide answers to these questions and more and make you wish you had known about all of this sooner.
Specifically we shall look in detail at:
Why you could lose data without realizing it.
Why locking is so difficult to understand and SQL Server's internal tricks to improve concurrency.
What problems Optimistic isolation can cause.
Mark Broadbent is a SQL Server specialist working for SQLCloud -a small consultancy specializing in SQL Server HADR solutions. He has many years experience working with and implementing SQL Server for large and small organizations and is the SQLCambs User Group Chapter Leader. He has presented at UK Usergroups, SQLSaturdays, SQLBits 7/ 8/ 9/ X, SQLRally Orlando/ Dallas, SQLPASS Summit 2011, 24HOP and is due to present at the SQL PASS 2012 Summit in Seattle. He is responsible for bringing the first SQLSaturday to the UK, which was recently held in Cambridge and has been awarded the Microsoft Community Contributor award in recognition of his contribution towards the SQL Server Community