MOFAKH.COM
← Back to profile
SQL

Isolation levels and what each one actually prevents

unwritten—Outline
Note to self
Not written yet. This is the outline I am working from — it will be filled in as I go through the topic.
  • Dirty reads, non-repeatable reads, phantoms — one example each
  • Read committed snapshot vs snapshot isolation on SQL Server
  • Locking, blocking and deadlock graphs
  • Choosing a level per transaction instead of per application
Previous
Reading an execution plan end to end
Next
Multi-tenant row filtering without leaking data