Category Locking, Blocking & Isolation Levels

• Defuse the Deadlock SQLChallenge (23 minutes)

  by Kendra Little 5 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses, SQLChallenges

  

  Sharpen your skills at fighting blocking and index design by defusing this deadlock

  To access this course, enroll in SQL Learning League, SQLChallenge Kit or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

• Read Committed is Bonkers - Webcast Recording (46 minutes)

  by Kendra Little 6 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  See how easy it is for your users to get incorrect data under SQL Server's default isolation level - and start out on the path to fixing your queries.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

• Read Committed Snapshot and Snapshot Isolation (46 minutes)

  by Kendra Little 7 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  Learn why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

• Repeatable Read and Serializable Isolation Levels (45 minutes)

  by Kendra Little 9 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  Learn why read committed is not enough, and the tradeoffs you make if you choose serializable or repeatable read with disk based tables.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

  Preview this course - (1 preview lessons)

• Snapshot Isolation Against Availability Group Secondaries (28 minutes)

  by Kendra Little 5 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  See automatic isolation level escalation in action, as we query a readable secondary in an Always On Availability Group.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

• The Dirty Secrets of NOLOCK (50 minutes)

  by Kendra Little 11 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  What happens when you use NOLOCK hints in your code, or set your isolation level to READ UNCOMMITTED in SQL Server? Learn the dirty secrets and potential uses of NOLOCK.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

  Preview this course - (1 preview lessons)

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

  by Kendra Little 22 Lessons in Locking, Blocking & Isolation Levels, Online Video Courses

  

  Learn how to set up a free blocking monitor, how to troubleshoot live blocking with free tools, how to configure built-in tools to document blocking when it happens, and how to trace deadlock graphs in SQL Server.

  To access this course, enroll in SQL Learning League or Locking, Blocking & Isolation Levels Learning Kit, or log in if you are already enrolled.

  Preview this course - (2 preview lessons)