Pro SQL Server Internals
Pro SQL Server Internals
Article Index
Pro SQL Server Internals
Chapters 5 -11
Chapters 12 -17
Chapters 18 - 24
Chapter 25 - 29
Chapters 30 - 35
Conclusion

 

Author: Dmitri Korotkevitch
Publisher: Apress
Pages: 804
ISBN: 978-1430259626
Audience: DBAs, Database developers
Rating: 4.9
Reviewer: Ian Stirk

Conclusion

This book provides an in-depth look at a wide range of SQL Server topics from an internals and performance related perspective.

 

 

It assumes some background knowledge of SQL Server, perhaps a few years SQL development. It is relatively easy to read, with excellent explanations, good use of screenshots, and detailed example code throughout to back up the assertions made. There are good links between the chapters, and to further information available on the web. Most chapters end with a very useful, and relatively long, summary. Having a single author undoubtedly contributed to a more consistent quality of explanations, and prevented duplication.

The book is wide-ranging, with coverage from User-Defined Functions to High Availability options. This is matched by its great detail, including examination of execution plans and physical database page/row content. There is no filler in this book, it is all useful detail. Throughout there are useful incidental tips provided. The author provides a balanced approach in his discussions, giving both the pros and cons to each problem’s solutions. There were few errors, mostly relating to editing, but nothing too distracting.

This book will take your level of SQL Server internals/performance understanding from say level 4 to level 9 (out of 10). I learned something new in almost every chapter, and there are lots of chapters! I started this review wondering if we needed another SQL Server internals book, I’ll finish it by saying this is the best SQL Server internals/performance book I’ve read, I congratulate the author on his industry.

Banner

 


Android Programming: The Big Nerd Ranch Guide (2e)

Author: Bill Phillips, Chris Stewart, Brian Hardy and Kristin Marsicano
Publisher: Big Nerd Ranch Guides
Pages: 600
ISBN: 978-0134171456
Print: 0134171454
Kindle: B0136ZXIMM
Audience: Java programmers
Rating: 4.5
Reviewer: Mike James  

The Big Nerd Ranch Guide to And [ ... ]



Professional C# 6 and .NET Core 1.0

Author: Christian Nagel
Publisher: Wrox
Pages:1536
ISBN: 978-1119096603
Print: 111909660X
Kindle:B01DRDK5MY
Audience: Intermediate C# programmers wanting to keep up-to-date

Rating: 4
Reviewer: Mike James

A book on .NET Core is welcome given how much confusion there is.


More Reviews

 



Last Updated ( Monday, 07 December 2015 )
 
 

   
Banner
RSS feed of book reviews only
I Programmer Book Reviews
RSS feed of all content
I Programmer Book Reviews
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.