Expert SQL Server Transactions and Locking

Concurrency Internals for SQL Server Practitioners



Bookstore > Books > Expert SQL Server Transactions and Locking

Price$24.23 - $33.83
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.



5 5 5

Similar Books


Microsoft SQL Server 2012 with Hadoop

Microsoft SQL Server 2012 with Hadoop

by Debarchan Sarkar

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...

Price:  $23.99  |  Publisher:  Packt Publishing  |  Release:  2013

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

Building Custom Tasks for SQL Server Integration Services, 2nd Edition

by Andy Leonard

Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring all the power of Microsoft .NET to bear on your data integration and ETL processes, and for no added cost over what you've already spent on licensing SQL Server. New in this edition is a demonstration deploying a custom SSIS ...

Price:  $34.99  |  Publisher:  Apress  |  Release:  2021

A Developer's Guide to Data Modeling for SQL Server

A Developer's Guide to Data Modeling for SQL Server

by Eric Johnson, Joshua Jones

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...

Price:  $6.15  |  Publisher:  Addison-Wesley  |  Release:  2008

Microsoft SQL Server 2012 Integration Services

Microsoft SQL Server 2012 Integration Services

by Wee-Hyong Tok, Rakesh Parida, Matt Masson, Xiaoning Ding, Kaarthik Sivashanmugam

Build and manage data integration solutions with expert guidance from the Microsoft SQL Server Integration Services (SSIS) team. See best practices in action and dive deep into the SSIS engine, SSISDB catalog, and security features. Using the developer enhancements in SQL Server 2012 and the flexible SSIS toolset, you'll handle compl...

Price:  $8.80  |  Publisher:  Microsoft Press  |  Release:  2012

Expert SQL Server in-Memory OLTP

Expert SQL Server in-Memory OLTP

by Dmitri Korotkevitch

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 ...

Price:  $55.40  |  Publisher:  Apress  |  Release:  2015

Expert SQL Server 2008 Development

Expert SQL Server 2008 Development

by Adam Machanic, Alastair Aitchison

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 ...

Price:  $13.70  |  Publisher:  Apress  |  Release:  2010

Oracle Database Transactions and Locking Revealed

Oracle Database Transactions and Locking Revealed

by Thomas Kyte, Darl Kuhn

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...

Price:  $37.98  |  Publisher:  Apress  |  Release:  2014

Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Jonathan Kehayias, Cindy Gross, Steven Wort

When faced with a variety of SQL Server issues, you need to be able to troubleshoot SQL Server as well as its underlying operating system. To that end, this author group of SQL Server experts presents you with invaluable advice that brings together - and simplifies - practical internal information concerning SQL Server along with troubles...

Price:  $5.49  |  Publisher:  Wrox  |  Release:  2010