It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting.

N� de ref. del art�culo 1484239563-8-1

Contactar al vendedor

Denunciar este art�culo

Detalles bibliogr�ficos

T�tulo

Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

Editor

Apress (edition First Edition)

Fecha de publicaci�n

2018

Idioma

Ingl�s

ISBN 10

1484239563

ISBN 13

9781484239568

Encuadernaci�n

Paperback

Edici�n

First Edition.

Estado

Very Good

Cat�logos de vendedores

Acerca de

Sinopsis

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.

Acerca del autor

Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master (SQL Server 2008) with many years of IT experience, including years of experience working with Microsoft SQL Server as Application and Database Developer, Database Administrator, and Database Architect. He specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. Currently, he works as Director of Database Services at Chewy.com and he provides SQL Server consulting services and training to clients around the world. Dmitri regularly speaks at various Microsoft and SQL PASS events.

"Sobre este t�tulo" puede pertenecer a otra edici�n de este libro.

Descripci�n de la librer�a

BooksRun helps to save money on textbooks. We are committed to providing each customer with the highest standard of customer service. Please pay close attention to the description of the book and its condition you are ordering. If you have any questions or issues, please make sure to contact us first so we could resolve them. All orders are shipped on the same or the next business day. It usually takes 1 to 5 business days to receive your item if you choose expedited shipping. All orders submitted are eligible for a return within 30 days after the delivery. Thanks for shopping with us!

Ver la p�gina web de la librer�a

Informaci�n empresarial del vendedor

AZ Texts LLC
228 Park Ave S Suite 38827, New York, NY, 10003, U.S.A.

Condiciones de venta y env�o

Condiciones de venta

Derecho a cancelaci�n

Condiciones de env�o

Tarifas de env�o en Estados Unidos de America

Tarifas de env�o en Estados Unidos de America
Cantidad del pedido	De 3 a 8 d�as h�biles	De 3 a 6 d�as h�biles
Primer art�culo	EUR 0.00	EUR 3.41

Los plazos de entrega los establecen los vendedores y var�an seg�n el transportista y la ubicaci�n. Los pedidos que pasan por la aduana pueden sufrir retrasos y los compradores son responsables de los aranceles o tarifas asociadas. Los vendedores pueden ponerse en contacto con usted en relaci�n con cargos adicionales para cubrir cualquier aumento en los costes de env�o de los art�culos.