SQL Server: ACID, Relational Databases, & Transaction Isolation Levels

In this episode of Tales from the Field Bradley Ball, Sr. Azure Engineer on the Microsoft FastTrack CXP Product Group talks about ACID, relational databases, and SQL Server's Transaction Isolation levels.

We do a demo demonstrating Atomicity, and how we can use Transaction Isolation Levels to bypass an exclusive lock.

[thehouse]

Genius! Use RCSI at the statement level instead of no lock. I'm pretty sure im going to put this into practice for adhoc queries and reports.