El Libro del Día: Introducing SQL Server

El Libro del Día: 2015-12-15

Titulo: Introducing SQL Server
Autor: Mike McQuillan
Editorial: Apress
Nro Paginas: 397

Capítulos:
Chapter 1: What Is SQL Server
Chapter 2: Obtaining and Installing SQL Server
Chapter 3: Database Basics
Chapter 4: Tables
Chapter 5: Putting Good Tables Together
Chapter 6: Automating Deployment with SQLCMD
Chapter 7: NULLs and Table Constraints
Chapter 8: DML (or Inserts, Updates, and Deletes)
Chapter 9: Bulk Inserting Data
Chapter 10: Creating Data Import Scripts
Chapter 11: The SELECT Statement
Chapter 12: Joining Tables
Chapter 13: Views
Chapter 14: Indexes
Chapter 15: Transactions
Chapter 16: Functions
Chapter 17: Table-Valued Functions
Chapter 18: Stored Procedures Part 1
Chapter 19: Stored Procedures Part 2
Chapter 20: Bits and Pieces
Appendix A: SQL Data Types
Appendix B: Glossary
Appendix C: Common SQL Server System Objects
Appendix D: Exercises

Descarga:
Introducing_SQL_Server

El Libro del Día: Expert SQL Server In-Memory OLTP

El Libro del Día: 2015-10-22

Titulo: Expert SQL Server In-Memory OLTP
Autor: Dmitri Korotkevitch
Editorial: Apress
Nro Paginas: 258

Capítulos:
Chapter 1: Why In-Memory OLTP?
Chapter 2: In-Memory OLTP Objects
Chapter 3: Memory-Optimized Tables
Chapter 4: Hash Indexes
Chapter 5: Nonclustered Indexes
Chapter 6: In-Memory OLTP Programmability
Chapter 7: Transaction Processing in In-Memory OLTP
Chapter 8: Data Storage, Logging, and Recovery
Chapter 9: Garbage Collection
Chapter 10: Deployment and Management
Chapter 11: Utilizing In-Memory OLTP
Appendix A: Memory Pointers Management
Appendix B: Page Splitting and Page Merging in Nonclustered Indexes .
Appendix C: Analyzing the States of Checkpoint File Pairs
Appendix D: In-Memory OLTP Migration Tools

Descarga:
Expert_SQL_Server_in_Memory_OLTP

El Libro del Día: Microsoft SQL Server 2012 Step By Step

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

Titulo: Microsoft SQL Server 2012 Step By Step
Autor: Patrick LeBlanc
Editorial: Microsoft prePress
Nro Paginas: 364

Capítulos:
Part I Getting started with Microsoft SQL Server 2012
Chapter 1 Overview of Microsoft SQL Server 2012
Chapter 2 Installing, configuring, and upgrading Microsoft SQL Server 2012
Chapter 3 Using SQL Server 2012 administration and development tools
Part II Designing databases
Chapter 4 Designing SQL Server databases
Chapter 5 Creating your first table
Chapter 6 Building and maintaining indexes
Part III Advanced database design topics
Chapter 7 Table compression
Chapter 8 Table partitioning
Chapter 9 Database snapshots
Chapter 10 The SELECT statement
Part IV Using Transact-SQL (TSQL)
Chapter 11 Advanced data retrieval topics
Chapter 12 Modifying data
Chapter 13 Built-in scalar functions
Part V Creating other database objects
Chapter 14 Advanced TSQL topics
Chapter 15 Views
Chapter 16 User-defined functions
Chapter 17 Stored procedures
Chapter 18 Data manipulation triggers
Part VI SQL Server replication
Chapter 19 Replication
Part VII Database maintenance
Chapter 20 Backups
Chapter 21 Managing and maintaining indexes and statistics
Chapter 22 Maintenance plans
Part VIII Database management
Chapter 23 SQL Server Profiler
Chapter 24 Extended events
Chapter 25 SQL Server
Chapter 26 Resource Governor
Chapter 27 SQL Server Agent

Descarga:
Microsoft_SQL_Server_2012_Step_By_Step

El Libro del Día: SQL Server 2012 T-SQL Recipes

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

Titulo: SQL Server 2012 T-SQL Recipes
Autor: Jason Brimhall, David Dye, Jonathan Gennick, 
           Andy Roberts, Wayne Sheffield
Editorial: Apress
Nro Paginas: 794

Capítulos:
Chapter 1: Getting Started with SELECT
Chapter 2: Elementary Programming
Chapter 3: NULLs and Other Pitfalls
Chapter 4: Querying from Multiple Tables
Chapter 5: Grouping and Summarizing
Chapter 6: Advanced Select Techniques
Chapter 7: Aggregations and Windowing
Chapter 8: Inserting, Updating, Deleting
Chapter 9: Working with Strings
Chapter 10: Working with Dates and Times
Chapter 11: Working with Numbers
Chapter 12: Transactions, Locking, Blocking, and Deadlocking
Chapter 13: Managing Tables
Chapter 14: Managing Views
Chapter 15: Managing Large Tables and Databases
Chapter 16: Managing Indexes
Chapter 17: Stored Procedures
Chapter 18: User-Defined Functions and Types
Chapter 19: Triggers
Chapter 20: Error Handling
Chapter 21: Query Performance Tuning
Chapter 22: Hints
Chapter 23: Index Tuning and Statistics
Chapter 24: XML
Chapter 25: Files, Filegroups, and Integrity
Chapter 26: Backup
Chapter 27: Recovery
Chapter 28: Principals and Users
Chapter 29: Securables, Permissions, and Auditing
Chapter 30: Objects and Dependencies

Descarga:
SQL_Server_2012_TSQL_Recipes

El Libro del Día: Oracle Database 12c Performance Tuning Recipes

El Libro del Día: 2014-10-14

Titulo: Oracle Database 12c Performance Tuning Recipes
Autor: Sam R. Alapati, Darl Kuhn, Bill Padfield
Editorial: Apress
Nro Paginas: 621

Capítulos:
Chapter 1: Optimizing Table Performance
Chapter 2: Choosing and Optimizing Indexes
Chapter 3: Optimizing Instance Memory
Chapter 4: Monitoring System Performance
Chapter 5: Minimizing System Contention
Chapter 6: Analyzing Operating System Performance
Chapter 7: Troubleshooting the Database
Chapter 8: Creating Efficient SQL
Chapter 9: Manually Tuning SQL
Chapter 10: Tracing SQL Execution
Chapter 11: Automated SQL Tuning
Chapter 12: Execution Plan Optimization and Consistency
Chapter 13: Configuring the Optimizer
Chapter 14: Implementing Query Hints
Chapter 15: Executing SQL in Parallel

Descarga:
Oracle_Database_12c_Performance_Tuning_Recipes

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