Locking and Blocking

XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)

XEvents SQLChallenge: Create an Extended Events Trace (55 minutes)

Build your skills with Extended events in this SQLChallenge.

Read Committed Snapshot and Snapshot Isolation (46 minutes)

Read Committed Snapshot and Snapshot Isolation (46 minutes)

This course is an overview of why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.

Try the course quiz anytime.

Read Committed is Bonkers - Webcast Recording (46 minutes)

Read Committed is Bonkers - Webcast Recording (46 minutes)

If you haven’t thought much about isolation levels in SQL Server, chances are your application can easily return incorrect data to your users.

Try the course quiz anytime.

Snapshot Isolation Against Availability Group Secondaries (28 minutes)

Snapshot Isolation Against Availability Group Secondaries (28 minutes)

In just half an hour, you’ll see how queries against a readable secondary in an Availability Group are automatically escalated to Snapshot Isolation – whether you ask for it or not!

Try the course quiz anytime.

Defuse the Deadlock SQLChallenge (23 minutes)

Defuse the Deadlock SQLChallenge (23 minutes)

Sharpen your skills at fighting blocking and deadlocks.

The Dirty Secrets of NOLOCK (50 minutes)

The Dirty Secrets of NOLOCK (50 minutes)

What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server?

Try the course quiz anytime.

Repeatable Read and Serializable Isolation Levels (45 minutes)

Repeatable Read and Serializable Isolation Levels (45 minutes)

Serializable and Repeatable Read isolation levels offer protections so your users won’t see weird or incorrect data – but there are tradeoffs for those protections.

Try the course quiz anytime.

Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)

Troubleshooting Blocking and Deadlocks for Beginners (2 hours 10 minutes)

Your SQL Server is slow, and you suspect blocking.

Try the course quizzes anytime: blocking diagnosis, troubleshooting retroactively, deadlocks