This course is an overview of why Read Committed Snapshot Isolation (RCSI) and Snapshot Isolation levels are critical for scaling workloads in SQL Server.
In this session, I use diagrams and slides for most of the discussion, with a short amount of demo.
For a deeper dive:
- Complete the Read Committed is Bonkers course first, and then skip the “Welcome” lesson in this course – it is a recap of the problems with Read Committed
- Follow this course up by taking the course Snapshot Isolation Against Availability Group Secondaries
Get the scripts for this course here: https://github.com/LitKnd/SQLWorkbooks/tree/main/rcsi_and_snapshot_isolation