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.
In this course, you’ll dig into:
- How to tell if your existing applications are using these types of isolation levels
- When you might want to raise your isolation level in SQL Server
- The tradeoffs you make if you choose serializable or repeatable read with disk based tables.
Note: In this course, we focus on disk-based tables. In-Memory OLTP (“Hekaton”) works differently — it’s not lock-based! Learn about In-Memory OLTP and Isolation Levels here.
Course scripts
https://github.com/LitKnd/SQLWorkbooks/tree/main/repeatable_read_and_serializable_isolation_levels
Each video in this course has English captions available, as well as a transcript below the video.