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.