Microsoft SQL Server 2012 Internals

Description

• Explore the core engine of Microsoft SQL Server 2012 and put that practical knowledge to work. Led by a team of SQL Server experts, you'll learn the skills you need to exploit key architectural features. Go behind the scenes to understand internal operations for creating, expanding, shrinking and moving databases-whether you're a database developer, architect or administrator. 

  • SQL Server 2012 architecture and configuration
  • The SQLOS
  • Databases and database files
  • Special databases
  • Logging and recovery
  • Table storage
  • Indexes: Internals and management
  • Special storage
  • Special indexes
  • Query execution
  • The Query Optimizer
  • Plan caching and recompilation
  • Transactions and concurrency
  • DBCC internals