[DOWNLOAD] "Microsoft® SQL Server® 2012 Internals" by Kalen Delaney * Book PDF Kindle ePub Free

eBook details

Title: Microsoft® SQL Server® 2012 Internals
Author : Kalen Delaney
Release Date : January 15, 2013
Genre: Databases,Books,Computers & Internet,
Pages : * pages
Size : 17999 KB

Description

Dive deep inside the architecture of SQL Server 2012

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.

Discover how to:
Dig into SQL Server 2012 architecture and configurationUse the right recovery model and control transaction loggingReduce query execution time through proper index designTrack events, from triggers to the Extended Event EngineExamine internal structures with database console commands Transcend row-size limitations with special storage capabilitiesChoose the right transaction isolation level and concurrency modelTake control over query plan caching and reuse