Table of Contents

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.

About the Author

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master (SQL Server 2008) with many years of IT experience, including years of experience working with Microsoft SQL Server as Application and Database Developer, Database Administrator, and Database Architect. He specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. Currently, he works as Director of Database Services at Chewy.com and he provides SQL Server consulting services and training to clients around the world. Dmitri regularly speaks at various Microsoft and SQL PASS events.