SQL Server Transaction Log Management
Davis, Tony and Shaw, Gail
Simple Talk Publishing, October 2012.
Free PDF download
Yes, I recommend this book for any DBA working with Microsoft SQL Server. Gail and Tony do an excellent job of covering how Microsoft SQL Server uses the transaction log for a database. There are plenty of code examples to reveal the behavior they describe. In addition, they provide plenty of references to other sources which reinforce or expand upon what they cover in the book.
There’s a lot about this book I liked, so let me pick out the highlights.
Easy Reading Style:
Some technical books are hard to read. There’s a lot of jargon and a lot of assumptions are made as to the technical proficiency of the reader. Others have called this the Curse of Knowledge. Gail and Tony don’t have this issue. They make the book readable to a junior DBA level.
Extensive Code Examples:
Gail and Tony provide code examples for just about every behavior they describe. None of them were very long, but all were effective. Sometimes code samples are too long to reasonably type in. However, most of us learn best from learning, so typing in code is helpful. That means the code samples have to be reasonably small. They were in this book as I typed in nearly every example and then tinkered with them to see the behavior described. There was one example where there looks there was a printing/editing error, Listing 7.1), but the rest worked as long as I didn’t mistype. If you don’t feel like typing the code in, there is aprovided download (Listing 7.1 is correct in the download).
Coverage of Bulk-Logged Recovery Mode:
This book had an extensive amount of coverage on the bulk-logged recovery mode. Gail and Tony did a great job explaining why this mode exists as well as the pros and cons of using it. If you don’t get this book for any other reason, get it to review what you know about bulk-logged recovery mode.
There are only a couple of things I didn’t like.
Images Were Designed for an e-Book:
Some of the images used colors/shading that don’t show up well in a printed black & white book. Also, there were some references to shading in green and yellow. As a result, these particular images were hard to read, especially in chapter 2.
Oversight on Differential Backups:
Differential backups establish or re-establish a log chain with respect to future transaction log backups. However, most of the writing focused on full backups. The first time I noted this was in chapter 1, in the section titled Transaction Log Backup and Restore. Later chapters sometimes mentioned differential backups, but it was hit or miss.
Note: I was provided a free copy of this book for review.