SQL Server Transactions and Locking

$259.00

  • EUR: €239.13
  • GBP: £204.95
  • NZD: $431.21
  • CAD: $351.33
  • AUD: $396.31

In order to achieve a good compromise between data integrity and performance suitable for the business needs, it is essential to select the appropriate transaction isolation level. A developer needs to thoroughly understand the possible problems by selecting an inappropriate isolation level. Fortunately, SQL Server offers all possible isolation levels with both, optimistic and pessimistic locking. Memory-optimized tables do not use locking but introduce their own set of possible issues. With locking hints, it is possible to control the locking on a lower granularity than with the session-level options. The course explains the possible problems and shows how the problems are solved with different transaction isolation levels.

Length: 1 Hour and 44 Minutes

Description

SQL-Server-Transactions-and-Locking

In order to achieve a good compromise between data integrity and performance suitable for the business needs, it is essential to select the appropriate transaction isolation level. A developer needs to thoroughly understand the possible problems by selecting an inappropriate isolation level. Fortunately, SQL Server offers all possible isolation levels with both, optimistic and pessimistic locking. Memory-optimized tables do not use locking but introduce their own set of possible issues. With locking hints, it is possible to control the locking on a lower granularity than with the session-level options. The course explains the possible problems and shows how the problems are solved with different transaction isolation levels.

Link to the agenda and sample videos from the course

Length: 1 Hour and 44 Minutes

Instructor

Dejan Sarka


Dejan Sarka, MCT and Data Platform MVP, is an independent trainer and consultant that focuses on the development of database and business intelligence applications. Besides projects, he spends about half of the time on training and mentoring. He is the founder of the Slovenian SQL Server and .NET Users Group. Dejan Sarka is the main author or co-author of eighteen books about databases and SQL Server. Dejan Sarka has also developed many courses and seminars for Microsoft, SolidQ, and Pluralsight.

Reviews

There are no reviews yet.

Be the first to review “SQL Server Transactions and Locking”

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Product Enquiry

You may also like…