Expert SQL Server Transactions and Locking

Concurrency Internals for SQL Server Practitioners



Bookstore > Books > Expert SQL Server Transactions and Locking

Expert SQL Server Transactions and Locking
Price$24.47 - $26.47
Rating
AuthorDmitri Korotkevitch
PublisherApress
Published2018
Pages320
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101484239563
ISBN-139781484239568
EBook Hardcover Paperback

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.

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.




Similar Books


Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

With the explosion of data, the open source Apache Hadoop ecosystem is gaining traction, thanks to its huge ecosystem that has arisen around the core functionalities of its distributed file system (HDFS) and Map Reduce. As of today, being able to have SQL Server talking to Hadoop has become increasingly important because the two are indee...
A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

Effective data modeling is essential to ensuring that your databases will perform well, scale well, and evolve to meet changing requirements. However, if you're modeling databases to run on Microsoft SQL Server 2008 or 2005, theoretical or platform-agnostic data modeling knowledge isn't enough: models that don't reflect SQL Server's uniqu...
Expert SQL Server in-Memory OLTP

Expert SQL Server in-Memory OLTP

Expert SQL Server In-Memory OLTP is a deep dive into one of the most significant features of SQL Server 2014 - support for In-Memory Online Transaction Processing. The book describes the architecture and internals of the In-Memory OLTP Engine and explains how to develop, deploy, and maintain systems using it. With it you can dramatically ...
Expert SQL Server 2008 Development

Expert SQL Server 2008 Development

Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer Alastair Aitchison shows you how to think about SQL Server development as if it were any other type of development. You'll learn to manage testing in SQL Server and to properly deal with errors and excep...
Oracle Database Transactions and Locking Revealed

Oracle Database Transactions and Locking Revealed

Oracle Database Transactions and Locking Revealed provides much-needed information for building scalable, high-concurrency applications and deploy them against the Oracle Database. Read this short, 150-page book that is adapted from Expert Oracle Database Architecture to gain a solid and accurate understanding of how locking and concurren...
SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials

SQL Server 2014 Development Essentials is an easy-to-follow yet comprehensive guide that is full of hands-on examples. With Microsoft SQL Server 2014, you can design, build, and deploy mission-critical database applications. The variety of new in-memory features enable you to design high performance database applications that can improve ...