Microsoft SQL Server 2012 Internals

by Kalen Delaney

Dive deep inside the architecture of SQL Server 2012Explore 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 Dig into SQL Server 2012 architecture and configuration Use the right recovery model and control transaction logging Reduce query execution time through proper index design Track events, from triggers to the Extended Event Engine Examine internal structures with database console commands Transcend row-size limitations with special storage capabilities Choose the right transaction isolation level and concurrency model Take control over query plan caching and reuse

Genres: Technology

982 pages, Kindle Edition

First published November 15, 2013

Reviews

[Oby Onova · Rating 5 out of 5]

Great book

[John Deardurff · Rating 5 out of 5]

I first read this book about 6 years ago to get a deeper dive into the internals of SQL Server 2012. I definitely learned a lot. But I think I picked up, even more, the second time through. Considering I have actually met all the authors from SQL Saturday events or the annual PASS Summit. But, I think having taught SQL performance tuning over the last 6 years that I was able to really understand the concepts at a more detailed level. Now, this version of the book is for SQL Server 2012 and there have been at least three versions of SQL Server released since then with 2019 coming very soon. But the majority of this book is still relevant for all of those versions. An updated version would be welcome with some of the newer features added, but this is definitely a book I will most likely be reading again.