.NET Data Community Standup - Database concurrency and EF Core: Beyond optimistic concurrency - Ep 3

From the creator

In the 3rd installment of our series on concurrency, we'll dive deep into SQL isolation levels, how they work (and work differently!) across SQL Server and PostgreSQL. We'll hopefully learn a bit about how database locks, snapshots and isolation levels work together to bring some sanity into the world of concurrency. Watch the 3-part Database Concurrency series: https://www.youtube.com/playlist?list=PLdo4fOcmZ0oUaC54XKb1miYBaTFc3H17z ⏲️ Chapters: 00:00 Countdown 02:40 Welcome to .NET Data Community Standup 04:22 State of the Unicorn 06:36 Optimistic concurency overview 08:57 SQL Isolation levels overview 21:39 Demo - Read uncommitted 40:26 Repeatable read 42:22 Demo - Repeatable read 55:05 Scan direction and Multiversion Concurrency Control (MVCC) 01:01:36 Demo - Read committed snapshot isolation 01:08:00 Snapshot Isolation 01:12:20 Demo - Snapshot Isolation mode 01:16:20 Serialization Anomaly vs. Snapshot 01:18:45 Q&A 01:37:30 Thank you Catch up on the 1st and 2nd installments: Database concurrency and EF Core: ASP.NET and Blazor https://www.youtube.com/live/xVyYrtetDeA Links: https://www.theurlist.com/trexfpd Featuring: Shay Rojansky, Arthur Vickers #sql #dotnet #efcore

Published 2024-02-08 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.