Pro SQL Server Internals

Introduction

Several people asked me the same question during the time I worked on this book. “Why have you decided to write yet another book on SQL Server Internals? There are plenty of books on this subject out there, including an excellent one by Kalen Delaney et al., the latest version being entitled, Microsoft SQL Server 2012 Internals, Developer Reference series (Microsoft Press 2013).

To be absolutely honest, I asked myself the same question while I toyed with the idea of writing that book. In the end, I defined two goals:

1. I wanted to write a book that explains how SQL Server works while keeping the content as practical as possible.
2. I wanted the book to be useful to both database administrators and developers.

There is a joke in SQL ...