A few weeks ago the book Inside Microsoft SQL Server 2008: T-SQL Querying was sent to the printers, and it should be available in the next few days in the book stores. Like with your kids, I guess you’re not suppose to point out a favorite, but I can’t resist… I’ve been involved (and still am) in writing several books about SQL Server 2008, and T-SQL Querying is by far my favorite—it’s closest to my heart. When planning the book I was thinking about the book that I always wanted to read. I love SQL, and I feel that in order to appreciate the true depths of the language, you should familiarize yourself with the mathematical roots of the relational model, the model itself, and algorithmic complexity. Then you can start delving into the various aspects of querying and query tuning, and attain immense satisfaction and great insights while doing so.
The book was written by a group of authors which I’m honored and proud to be part of. Steve Kass wrote two chapters: one about set theory and predicate logic, and another about algorithms and complexity. Dejan Sarka wrote a chapter about the relational model. Lubor Kollar wrote a chapter about querying partition tables. I wrote the other eight chapters focusing on querying and query tuning, and an appendix about logic puzzles. Steve Kass was the main Technical Editor of the book, and Umachandar Jayachandran (UC) helped by editing a couple of chapters. César Galindo-Legaria wrote the foreword.
For those that have some of my other books and wonder what’s the difference…
If you read the book Microsoft SQL Server 2008: T-SQL Fundamentals, it was designed for any audience that needs to write T-SQL code, including people who just started using T-SQL. It focuses on logical aspects of T-SQL and on the fundamentals. The T-SQL Querying book is much more advanced, and actually assumes as prerequisites that you read T-SQL Fundamentals or have equivalent knowledge. T-SQL Querying delves into the fundamentals much more intensely, and then covers advanced aspects of querying and query tuning, focusing on both logical and physical processing.
If you read Inside Microsoft SQL Server 2005: T-SQL Querying, you will find plenty of new stuff in the new 2008 edition. There are four completely new chapters, and the existing chapters were updated to incorporate new features in SQL Server 2008, and new insights about existing subjects. Also, the appendix with the logic puzzles was rewritten with a new set of puzzles.
BTW, we made a poster available for download containing a diagram of Logical Query Processing from the first chapter. To me, this diagram captures the essence of SQL. You can download the poster from the book’s companion website, or from the following direct link.