Current Status
Not Enrolled
Price
229
Get Started
Take this Course

SQL Server Locking, Blocking, and Deadlocking

Key Concepts Covered in this Course

  • Transaction Support in SQL Server
  • Transaction Isolation Levels
  • Locking Internals
  • Troubleshooting Deadlocks

Klaus Aschenbrenner

Microsoft Certified Master for SQL Server

I work with Microsoft SQL Server for more than 20 years, and I provide with my company SQLpassion consulting and training services around the whole world.

Since 2012 I’m also a Microsoft Certified Master for SQL Server.

Course Description

Locks are used by SQL Server to isolate database users from each other. Unfortunately incompatible locks lead to blocking situations. And blocking situations always hurt your end user response times. In this training we will have a detailed look at Locking & Blocking in SQL Server, and at how you can influence SQL Server in this area.

Take this Course
5/5

Amazing Course

“In this workshop Klaus manages to cover everything you need to know about Locking in SQL Server. With real-life examples it also becomes easy to follow. I would highly recommend this course to every DBA or developer.”

Mark from Montfoort, Netherlands

Course Details

Course Duration

6 hours

Course Price

EUR 229 incl. 20% VAT

Course Level

Intermediate

Course Content

Take this Course

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.