This one popped up in my feed today: Things You Should Know About Databases. My favourite quote was this one:
The SQL standard defines 4 standard isolation levels these can and should be configured globally (insidious things can happen if we can’t reliably reason about isolation levels).
It’s so important to know what isolation level is applicable to your connection/transaction.
Can’t agree more. Super important concept.
SQL Server (my favorite database) additionally introduces two more: SNAPSHOT and READ COMMITTED SNAPSHOT.