Expert SQL Server Transactions and Locking
Concurrency Internals for SQL Server Practitioners
| Price | $24.23 - $33.83
|
| Rating |  |
| Author | Dmitri Korotkevitch |
| Publisher | Apress |
| Published | 2018 |
| Pages | 320 |
| Language | English |
| Format | Paper book / ebook (PDF) |
| ISBN-10 | 1484239563 |
| ISBN-13 | 9781484239568 |
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.
- Dmitri Korotkevitch (5 books)
5 5 5
Similar Books
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
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 
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
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
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
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
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
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