Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

dotnet
325K subscribers
<__slot-el>
<__slot-el>
7.4K views Streamed 1 year ago #dotnet #sql #efcore
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:    • Database Concurrency - 3-part series   ⏲️ 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 4 …...more
...more
.NET Data Community Standup - Database concurrency and EF Core: Beyond optimistic concurrency - Ep 3
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:    • Database Concurrency - 3-part series   ⏲️ 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

Follow along using the transcript.

dotnet

325K subscribers