Expert SQL Server Transactions and Locking
Concurrency Internals for SQL Server Practitioners
|Price||$24.47 - $26.47
|Format||Paper book / ebook (PDF)|
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.
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
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 Server's uniqu...
Price: $6.70 | Publisher: Addison-Wesley | Release: 2008
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: $49.99 | Publisher: Apress | Release: 2015
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 excep...
Price: $13.70 | Publisher: Apress | Release: 2010
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: $29.62 | Publisher: Apress | Release: 2014
by Basit A. Masood-Al-Farooq
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 ...
Price: $26.99 | Publisher: Packt Publishing | Release: 2014
by Gethyn Ellis
The release of SQL Server 2014 has brought with it some great new features and enhancements that database administrators can use to make their database servers faster, highly available, and protected from disaster. As the lines between on-premise and on-cloud based solutions become even more blurred, enterprise database applications such ...
Price: $16.99 | Publisher: Packt Publishing | Release: 2014
by Hemantgiri S. Goswami
Install various SQL Server High Availability options in a step-by-step manner. A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators. Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability. Tips to enhance performance...
Price: $29.99 | Publisher: Packt Publishing | Release: 2011