Lock, Block and Two Smoking Barrels
SQL Server is a high performance relational engine and provides a highly scalable database platform but due to its complexity (and bad programming practices) can be prone to serious concurrency problems, unexpected behaviors, lost updates and much more!
In SQL Server 2005, two optimistic concurrency mechanisms were introduced and touted as the solution to all our problems. Now in SQL Server 2012, 2014 and 2016 even more have followed, but many challenges and problems still remain.
Let’s take a long look into the world of SQL Server concurrency and investigate Pessimistic and Optimistic isolation understanding how they work, when you should use them, and more importantly when they can go very wrong. Don't be staring down the wrong end of SQL Server's two Smoking Barrels and join me for this revealing and thought provoking presentation.
Attendees should have a basic appreciation of SQL Server's concurrency concepts such as locking, blocking, deadlocking and the database engine.