{"product_id":"expert-sql-server-transactions-and-locking-concurrency-internals-for-sql-server-practitioners-paperback","title":"Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners - Paperback","description":"\u003cdiv\u003e\u003cp style=\"text-align: right;\"\u003e\u003ca href=\"https:\/\/reportcopyrightinfringement.com\/\" target=\"_blank\" rel=\"nofollow\"\u003e\u003cb\u003eReport copyright infringement\u003c\/b\u003e\u003c\/a\u003e\u003c\/p\u003e\u003c\/div\u003e\u003cp\u003eby \u003cb\u003eDmitri Korotkevitch\u003c\/b\u003e (Author)\u003c\/p\u003e\u003cp\u003eMaster SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.\u003cbr\u003eSQL Server's Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.\u003cbr\u003eUnderstanding the internals surrounding SQL Server's Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes. \u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cb\u003eWhat You'll Learn\u003c\/b\u003e\u003cul\u003e\n\u003cli\u003eKnow how transaction isolation levels affect locking behavior and concurrency\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and address blocking issues and deadlocks\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eProvide required data consistency while minimizing concurrency issues\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDesign efficient transaction strategies that lead to scalable code\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eReduce concurrency problems through good schema design\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eUnderstand concurrency models for In-Memory OLTP and Columnstore Indexes\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eReduce blocking during index maintenance, batch data load, and similar tasks\u003cbr\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\u003cb\u003e\u003cbr\u003e\u003c\/b\u003e\u003cb\u003eWho This Book Is For\u003c\/b\u003e\u003cbr\u003eSQL Server developers, database administrators, and application architects who are developing highly-concurrent applications. The book is for anyone interested in the technical aspects of creating and troubleshooting high-throughput systems that respond swiftly to user requests.\u003cbr\u003e\u003cp\u003e\u003c\/p\u003e\u003ch3\u003eBack Jacket\u003c\/h3\u003e\u003cp\u003eMaster SQL Server's Concurrency Model so you can implement high-throughput systems that deliver transactional consistency to your application customers. This book explains how to troubleshoot and address blocking problems and deadlocks, and write code and design database schemas to minimize concurrency issues in the systems you develop.\u003cbr\u003eSQL Server's Concurrency Model is one of the least understood parts of the SQL Server Database Engine. Almost every SQL Server system experiences hard-to-explain concurrency and blocking issues, and it can be extremely confusing to solve those issues without a base of knowledge in the internals of the Engine. While confusing from the outside, the SQL Server Concurrency Model is based on several well-defined principles that are covered in this book.\u003cbr\u003eUnderstanding the internals surrounding SQL Server's Concurrency Model helps you build high-throughput systems in multi-user environments. This book guides you through the Concurrency Model and elaborates how SQL Server supports transactional consistency in the databases. The book covers all versions of SQL Server, including Microsoft Azure SQL Database, and it includes coverage of new technologies such as In-Memory OLTP and Columnstore Indexes.\u003cbr\u003eWhat You'll Learn: \u003cbr\u003e\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eKnow how transaction isolation levels affect locking behavior and concurrency\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eTroubleshoot and address blocking issues and deadlocks\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eProvide required data consistency while minimizing concurrency issues\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eDesign efficient transaction strategies that lead to scalable code\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eReduce concurrency problems through good schema design\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eUnderstand concurrency models for In-Memory OLTP and Columnstore Indexes\u003cbr\u003e\n\u003c\/li\u003e\n\u003cli\u003eReduce blocking during index maintenance, batch data load, and similar tasks\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eAuthor Biography\u003c\/h3\u003e\u003cp\u003e\u003cb\u003eDmitri Korotkevitch \u003c\/b\u003eis 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.\u003c\/p\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eNumber of Pages:\u003c\/strong\u003e 320\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eDimensions:\u003c\/strong\u003e 0.71 x 10 x 7 IN\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003eIllustrated:\u003c\/strong\u003e Yes\u003c\/div\u003e\n            \u003cdiv\u003e\n\u003cstrong\u003ePublication Date:\u003c\/strong\u003e October 09, 2018\u003c\/div\u003e\n            ","brand":"BooksCloud","offers":[{"title":"Default Title","offer_id":47212719931641,"sku":"9781484239568","price":70.18,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0789\/2782\/3097\/files\/NWdVNnhlTTZndjZzMngvUmxmcDUzdz09.webp?v=1768095183","url":"https:\/\/bookscloud.io\/products\/expert-sql-server-transactions-and-locking-concurrency-internals-for-sql-server-practitioners-paperback","provider":"BooksCloud Book Dropshipping","version":"1.0","type":"link"}