Transactions basics – part 2: Isolation levels
Fair warning, this post is a little on the long side but bear with me, understanding the differences here is important. All SQL statements used in this post is in…
Transactions basics – part 1: Transaction Modes
In SQL (almost) nothing happens unless it is within a transaction. A transaction is a single unit of work where all contained changes are either completed successfully or rolled back.…