A review of why locks are important and how they are used within SQL Server. Also how transactions work (and don't work) with a demo of nested transactions and use of ROLLBACK. It includes a discussion of the theory along with illustrations and examples.
0:41 Lock Types
10:22 Locks Demo
18:55 Transactions
31:03 Transaction Demo