Pro SQL Server Internals

4,8 valoración promedio
( 5 valoraciones por Goodreads )
 
9781430259626: Pro SQL Server Internals

Pro SQL Server Internals explains how different SQL Server components work "under the hood" and how they communicate with each other. This is the practical book with a large number of examples that will show you how various design and implementation decisions affect the behavior and performance of your systems.

Pro SQL Server Internals covers a multiple SQL Server versions starting with SQL Server 2005 all the way up to the recently released SQL Server 2014. You’ll learn about new SQL Server 2014 features including the new Cardinality Estimator, In-Memory OLTP Engine (codename Hekaton), and Clustered Columnstore Indexes. With Pro SQL Server Internals, you have a solid roadmap for understanding the depth and power of the SQL Server database backend, regardless of the version and edition of SQL Server you use.

Pro SQL Server Internals does the following:

  • Explains how to design efficient database schema, indexing, and transaction strategies.
  • Shows how various database objects and technologies are implemented internally and when they should or should not be used.
  • Demonstrates how SQL Server executes queries and works with data and transaction logs.

What you ll learn

  • Design and develop efficient database solutions utilizing SQL Server as the database backend.
  • Troubleshoot and address design, concurrency, and performance issues in systems.
  • Choose the right database objects and technologies for the job.
  • Improve system availability and manageability and reduce implementation costs with data partitioning.
  • Design efficient Disaster Recovery and High-Availability strategies for systems.
  • Improve the performance of OLTP and Data Warehouse systems by utilizing new SQL Server 2014 features, such as the In-Memory OLTP Engine and Clustered Columnstore Indexes.

Who this book is for

Pro SQL Server Internals is a book for developers and database administrators who want to design, develop, and maintain systems in a way that gets the most from SQL Server. This book is an excellent choice for people who prefer to understand and fix the root cause of a problem, rather than applying a 'band aid' to it.

Table of Contents

Part 1 – Tables and Indexes

· Chapter 1: Data storage internals

· Chapter 2: Tables and Indexes – Internal Structure and Access Methods

· Chapter 3: Statistics

· Chapter 4: Special Indexing and Storage Features

· Chapter 5: Index fragmentation

· Chapter 6: Designing and tuning the indexes

Part 2: Other things that matter

· Chapter 7: Constraints

· Chapter 8: Triggers

· Chapter 9: Views

· Chapter 10: Functions

· Chapter 11: XML

· Chapter 12: Temporary Tables

· Chapter 13: CLR

· Chapter 14: CLR types

· Chapter 15: Data partitioning

· Chapter 16: System design considerations

Part 3: Locking, Blocking and Concurrency

· Chapter 17: Lock types

· Chapter 18: Troubleshooting Blocking issues

· Chapter 19: Deadlocks

· Chapter 20: Lock Escalations

· Chapter 21: Optimistic isolation levels

· Chapter 22: Application locks

· Chapter 23: Schema locks

· Chapter 24: Designing transaction strategies

Part 4: Query Life Cycle

· Chapter 25: Query Optimization and Execution

· Chapter 26: Plan Caching

Part 5: Practical Troubleshooting

· Chapter 27: System Troubleshooting

· Chapter 28: Extended events

Part 6: Inside the transaction log

· Chapter 29: Transaction Log Internals

· Chapter 30: Designing a Backup Strategy

· Chapter 31: Designing a High Availability Strategy

Part 7: In-Memory OLTP Engine

· Chapter 32: Hekaton (In Memory OLTP Engine)

Part 8: Columnstore Indexes

· Chapter 33: In-Memory OLTP Programmability

· Chapter 34: Introduction to Columnstore indexes

· Chapter 35: Clustered Columnstore indexes

"Sinopsis" puede pertenecer a otra edición de este libro.

From the Back Cover:

Improve your ability to develop, manage, and troubleshoot SQL Server solutions by learning how different components work under the hood, and how they communicate with each other. The detailed knowledge helps in implementing and maintaining high-throughput databases critical to your business and its customers. You ll learn how to identify the root cause of each problem and understand how different design and implementation decisions affect performance of your systems.

New in this second edition is coverage of SQL Server 2016 Internals, including In-Memory OLTP, columnstore enhancements, Operational Analytics support, Query Store, JSON, temporal tables, stretch databases, security features, and other improvements in the new SQL Server version. The knowledge also can be applied to Microsoft Azure SQL Databases that share the same code with SQL Server 2016.

Pro SQL Server Internals is a book for developers and database administrators, and it covers multiple SQL Server versions starting with SQL Server 2005 and going all the way up to the recently released SQL Server 2016. The book provides a solid road map for understanding the depth and power of the SQL Server database server and teaches how to get the most from the platform and keep your databases running at the level needed to support your business. The book:
Provides detailed knowledge of new SQL Server 2016 features and enhancements
Includes revamped coverage of columnstore indexes and In-Memory OLTP Covers indexing and transaction strategies
Shows how various database objects and technologies are implemented internally, and when they should or should not be used

Demonstrates how SQL Server executes queries and works with data and transaction log

"

About the Author:

Dmitri Korotkevitch is Microsoft SQL Server MVP and Microsoft Certified Master (in SQL Server 2008). He brings years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. He specializes in design, development, and performance tuning of OLTP Systems working under heavy load.

Dmitri regularly speaks at various Microsoft and SQL PASS events, and he provides SQL Server training to clients around the world. He blogs at: http://aboutsqlserver.com.

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

Comprar nuevo Ver libro

Gastos de envío: EUR 8,98
De Reino Unido a Estados Unidos de America

Destinos, gastos y plazos de envío

Añadir al carrito

Los mejores resultados en AbeBooks

1.

DMITRI KOROTKEVITCH
Editorial: Apress (2014)
ISBN 10: 1430259620 ISBN 13: 9781430259626
Nuevos Paperback Cantidad: 1
Librería
Herb Tandree Philosophy Books
(Stroud, GLOS, Reino Unido)
Valoración
[?]

Descripción Apress, 2014. Paperback. Estado de conservación: NEW. 9781430259626 This listing is a new book, a title currently in-print which we order directly and immediately from the publisher. Nº de ref. de la librería HTANDREE0712843

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 41,06
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 8,98
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Korotkevitch, Dmitri
Editorial: Apress (2014)
ISBN 10: 1430259620 ISBN 13: 9781430259626
Nuevos Paperback Cantidad: 10
Librería
Ergodebooks
(RICHMOND, TX, Estados Unidos de America)
Valoración
[?]

Descripción Apress, 2014. Paperback. Estado de conservación: New. Nº de ref. de la librería INGM9781430259626

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 59,37
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 4,21
A Estados Unidos de America
Destinos, gastos y plazos de envío

3.

Korotkevitch, Dimitri
Editorial: Apress (2014)
ISBN 10: 1430259620 ISBN 13: 9781430259626
Nuevos Paperback Cantidad: 1
Librería
Revaluation Books
(Exeter, Reino Unido)
Valoración
[?]

Descripción Apress, 2014. Paperback. Estado de conservación: Brand New. 769 pages. 9.00x7.50x2.00 inches. In Stock. Nº de ref. de la librería zk1430259620

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 73,33
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 6,74
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

4.

Korotkevitch, Dmitri
Editorial: Apress (2014)
ISBN 10: 1430259620 ISBN 13: 9781430259626
Nuevos Paperback Cantidad: 2
Librería
Murray Media
(North Miami Beach, FL, Estados Unidos de America)
Valoración
[?]

Descripción Apress, 2014. Paperback. Estado de conservación: New. Never used!. Nº de ref. de la librería P111430259620

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 83,79
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 1,68
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

Korotkevitch, Dmitri
Editorial: Apress (2014)
ISBN 10: 1430259620 ISBN 13: 9781430259626
Nuevos Cantidad: 1
Librería
Nearfine Books
(Brooklyn, NY, Estados Unidos de America)
Valoración
[?]

Descripción Apress, 2014. Estado de conservación: new. Shiny and new! Expect delivery in 20 days. Nº de ref. de la librería 9781430259626-1

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 109,51
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,38
A Estados Unidos de America
Destinos, gastos y plazos de envío