El Libro del Día: SQL Server 2012 Query Performance Tuning

El Libro del Día: 2014-12-12

Titulo: SQL Server 2012 Query Performance Tuning
Autor: Grant Fritchey
Editorial: Apress
Nro Paginas: 521

Capítulos:
Chapter 1: SQL Query Performance Tuning
Chapter 2: System Performance Analysis
Chapter 3: SQL Query Performance Analysis
Chapter 4: Index Analysis
Chapter 5: Database Engine Tuning Advisor
Chapter 6: Lookup Analysis
Chapter 7: Statistics Analysis
Chapter 8: Fragmentation Analysis
Chapter 9: Execution Plan Cache Analysis
Chapter 10: Query Recompilation
Chapter 11: Query Design Analysis
Chapter 12: Blocking Analysis
Chapter 13: Deadlock Analysis
Chapter 14: Cursor Cost Analysis
Chapter 15: Database Performance Testing
Chapter 16: Database Workload Optimization
Chapter 17: SQL Server Optimization Checklist

Descarga:
SQL_Server_2012_Query_Performance_Tuning

El Libro del Día: Microsoft SQL Server 2012 Internals

El Libro del Día: 2014-07-22

Titulo: Microsoft SQL Server 2012 Internals
Autor: Kalen Delaney, Bob Beauchemin, Conor Cunningham, 
          Jonathan Kehayias, Benjamin Nevarez, Paul S. Randal
Editorial: Microsoft
Nro Paginas: 983

Capítulos:
Chapter 1 SQL Server 2012 architecture and configuration
Chapter 2 The SQLOS
Chapter 3 Databases and database files
Chapter 4 Special databases
Chapter 5 Logging and recovery
Chapter 6 Table storage
Chapter 7 Indexes: internals and management
Chapter 8 Special storage
Chapter 9 Special indexes
Chapter 10 Query execution
Chapter 11 The Query Optimizer
Chapter 12 Plan caching and recompilation
Chapter 13 Transactions and concurrency
Chapter 14 DBCC internals

Descarga:
Microsoft_SQL_Server_2012_Internals