Locks, Blocks, and Two Smoking Deadlocks

We will find out how locking works in SQL server, why blocking occurs, how to identify and to prevent different types of deadlocks. Concurrency models, isolation levels and read phenomena are also worth mentioning. EPAM IT WEEK 2016