Microsoft SQL Server 2012 Internals (Developer Reference)

As way of introduction, I am a CPA, MBA, MCSD, MCDBA - (for those of you who know, these are old credentials) I have made my living designing, coding, and supporting SQL based systems since Informix introduced Smartware. Most of my work has been done in MS SQL Server and Access.I have spent countless hours trying to solve problems related to MS SQL Server because I never read this book or any like it. I don't care how long you have been working in MS SQL Server, if you do not understand the internals of how the engine works, you will waste vast amounts of time and most likely produce code and environments, which although they may function, are not optimized. You will spend hours trying to solve problems because you will not even know where to start looking.This book is highly technical and extremely dry in many places. You will not take it to the beach for light reading. It will take a long time to work through this book and much of it may not seem relevant to you at the moment. I admit skimming some of the longer examples, but they are there for you to use in the future when you hit a wall.This book is for persons who have a good amount of experience working with SQL Server and are moving up to 2012 and really want to understand the product from the inside out. You do need a good understanding of hardware system nomenclature and functionality to understand the references in the book.If you are an T-SQL developer and you think you don't really need the information in this book, you are wrong. As all of us who have written a million lines of T-SQL code in our lives know that there are a thousand different ways to get from point A to point B. Although all of them may work, 99% of them are inefficient at least. This book will give you the background understanding to know when you are headed done the wrong road.

Excellent! Lots of in-depth details and good examples. The book is pretty advanced, but everything is well explained and included scripts help to understand the subject and follow technical description. This is not a book to learn SQL or T-SQL (which is good), but a book explaining how SQL Server works internally.

This was a gift for my husband, who seems very happy with it. I can't speak to the content, because I couldn't possibly know less about SQL Server. I do know that many of the Microsoft SQL Server books are written by respected experts within the community and that this book is no exception. If you have a SQL Server DBA in your circle of friends or family and you want to surprise them with a book related to THEIR interests, this isn't a bad choice.

Excellent book. I am working on sql server since few years and this book made me feel I knew very little about it. Definitely recommend for in-depth knowledge on sql server internals.

Clear, definitive,precise and as easy to read as any technical book can be.

Probably the best publication out there for SQL Server.

Great book about sql server internals

This book is great for people that already have knowledge of SQL Server, it's not for beginners. A lot of details on SQL internals.