From Locks to No Locks – Concurrency in SQL Server
In this session, we’ll explore the good and bad about locking and blocking – essential mechanisms inside SQL Server that every database developer and administrator needs to understand thoroughly. Locking and blocking affects performance and data integrity, and we’ll see how we can influence that functionality under pessimistic concurrency control as well as how snapshot isolation changes the game.
This session will focus on reading data (while being blocked). We’ll consider table & index design and query hints, why we should rarely if ever use NOLOCK, and what alternatives we have. Be prepared for a demo-& code-intensive session – no “GUI-action.”
Sorry, there are no downloads available for this session.
Andreas Wolter is both a Microsoft Certified Master (MCM) on SQL Server 2008 and a Microsoft Certified Solutions Master Data Platform (MCSM) SQL Server 2012 and has also been awarded with the MVP for SQL Server.
He is the founder of Sarpedon Quality Lab, a Germany-based company that specializes in Development and Optimization of SQL Server Database- and Datawarehouse-architectures with focus on performance and scalability as well as a special passion for security.
With over a decade of experience with SQL Server he can be met at various international conferences and delivering training for the SQL Server Master-Class seminar-series held in Europe.
You can follow him at Twitter at @AndreasWolter.
The video is not available to view online.