Name: Myths and Misconceptions about Locking & Blocking
Start: 2022-04-05T19:00:00+01:00
End: 2022-04-05T20:30:00+01:00

* Online Session* Click link to join at 19:00

You know the various Transaction Isolation Levels and Locking/Blocking very well in SQL Server? If yes, come and join my session where I will talk about various Myths and Misconceptions around Locking & Blocking that I have encountered over the years. We will take a whirl tour through some edge cases that will change forever how you think about Locking & Blocking in SQL Server. During this session we will cover the following areas:

*) NOLOCK can block!
*) Shared Locks are blocking Shared Locks!
*) Read Committed behaves as Repeatable Read
*) Online Index Operations are not Online Index Operations!

About Klaus Aschenbrenner - SQLpassion

Klaus Aschenbrenner provides with his company SQLpassion SQL Server consulting & training services across Europe. Klaus works with SQL Server for more than 20 years. Klaus has also written the book Pro SQL Server 2008.

Bob Duffy

SQL Ireland User Group

Azure Data Tech Groups

Technology

SQL Server

Advanced SQL Server

Microsoft Azure

Database Professionals

Data Management

Business Intelligence

Big Data

Database Development

Data Visualization

Predictive Analytics

Data Mining

Myths and Misconceptions about Locking & Blocking

Online event

Share

SQL Ireland User Group

Myths and Misconceptions about Locking & Blocking

SQL Ireland User Group

Details

Members are also interested in