Expert SQL Server Transactions and Locking

1. Data Storage and Access Methods
2. Transaction Management and Concurrency Models 
3. Lock Types
4. Blocking in the System
5. Deadlocks
6. Optimistic Isolation Levels
7. Lock Escalation
8. Schema and Low-Priority Locks
9. Lock Partitioning
10. Application Locks
11. Designing Transaction Strategies
12. Troubleshooting Concurrency Issues
13. In-Memory OLTP Concurrency Model
14. Locking in Columnstore Indexes