When I’m not busy writing about SQL Server, I quite enjoy reading books about it that look at things from a different point of view. I’ve been catching up on my reading lately, but getting behind on my book reviews. So here’s a few reviews I’d been meaning to write for some time. The authors asked that I review them on Amazon, but I don’t like either giving out personal information just to do a book review (too intrusive) or the idea of anonymous reviews/fake personal information (too easy to “stack the deck”). So I’m reviewing them here.
SQL Server 2005 Practical Troubleshooting (multiple authors, edited by Ken Henderson)
The is a superb book about internals, with each chapter written by a dev, a PSS support person, or a member of the Development Customer Support Advisory team. Who could ask for more of an insiders’ view? Maybe I like internals a bit too much, but I keep coming back to this book again and again. My favorite chapters are ones detailing the query cache and the query processor. I was originally put off by the number of proofreading/editing mistakes, but its worth getting past that and concentrating on the content in a hurry. Some excellent troubleshooting utilities are provided as well. A must read.
Expert SQL Server 2005 Development (Adam Machanic, Hugi Kornelis, and Lara Rubbelke)
I really wrote my “review” for this one on its cover, you’ll need to buy the book to read that part. This is not an overview book, nor does it try to be comprehensive in its coverage, but it covers, in depth, topics that you’ll see nowhere else. In amazing depth. Absolutely worth every minute you’ll spend reading and working the examples.
Pro SQL Server 2005 Service Broker (Klaus Aschenbrenner)
I haven’t received my copy of this one yet, but read a number of chapters as a reviewer before time constraints overwhelmed me. Based on the material that I did review, it’s well worth reading. If Roger Wolter’s Service Broker book was the seminal treatise on the subject, Klaus expands on the topics and provides quite a few examples and use cases.