logo
Product categories

EbookNice.com

Most ebook files are in PDF format, so you can easily read them using various software such as Foxit Reader or directly on the Google Chrome browser.
Some ebook files are released by publishers in other formats such as .awz, .mobi, .epub, .fb2, etc. You may need to install specific software to read these formats on mobile/PC, such as Calibre.

Please read the tutorial at this link.  https://ebooknice.com/page/post?id=faq


We offer FREE conversion to the popular formats you request; however, this may take some time. Therefore, right after payment, please email us, and we will try to provide the service as quickly as possible.


For some exceptional file formats or broken links (if any), please refrain from opening any disputes. Instead, email us first, and we will try to assist within a maximum of 6 hours.

EbookNice Team

(Ebook) Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners by Dmitri Korotkevitch ISBN 9781484239568, 1484239563

  • SKU: EBN-7211402
Zoomable Image
$ 32 $ 40 (-20%)

Status:

Available

5.0

25 reviews
Instant download (eBook) Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners after payment.
Authors:Dmitri Korotkevitch
Pages:320 pages.
Year:2018
Editon:1
Publisher:Apress
Language:english
File Size:12.59 MB
Format:pdf
ISBNS:9781484239568, 1484239563
Categories: Ebooks

Product desciption

(Ebook) Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners by Dmitri Korotkevitch ISBN 9781484239568, 1484239563

Master 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.
SQL 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.
Understanding 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.
What You'll Learn
● Know how transaction isolation levels affect locking behavior and concurrency
● Troubleshoot and address blocking issues and deadlocks
● Provide required data consistency while minimizing concurrency issues
● Design efficient transaction strategies that lead to scalable code
● Reduce concurrency problems through good schema design
● Understand concurrency models for In-Memory OLTP and Columnstore Indexes
● Reduce blocking during index maintenance, batch data load, and similar tasks
Who This Book Is For
SQL 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.
*Free conversion of into popular formats such as PDF, DOCX, DOC, AZW, EPUB, and MOBI after payment.

Related Products