Recommended SQL Books – Professional SQL Server 2008 Internals and Troubleshooting

One of the most frequent questions you will find on SQL forums and mailing lists is “which book should I buy?”, having bought quite a few SQL 2008 books recently I thought I would review one of my favourites:

Professional SQL Server 2008 Internals and Troubleshooting

 

 

 

 

 

 

 

By far the best book I have been reading recently is: Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton and Justin Langford. It’s geared far more at the DBA market than the SQL Developer market but if you are a developer and are sick of your DBA berating you for not doing something a certain way then it might be worth picking up a copy.

There are 16 chapters which I have listed below (the 16th chapter is available to download from the Wrox website):

  • SQL Server Architecture
  • Understanding Memory
  • SQL Server Waits and Extended Events
  • Working with Storage
  • CPU and Query Processing
  • Locking and Latches
  • Knowing Tempdb
  • Defining Your Approach To Troubleshooting
  • Viewing Server Performance with PerfMon and the PAL Tool
  • Tracing SQL Server with SQL Trace and Profiler
  • Consolidating Data Collection with SQLDiag and the PerfStats Script
  • Introducing RML Utilities for Stress Testing and Trace File Analysis
  • Bringing It All Together with SQL Nexus
  • Using Management Studio Reports and the Performance Dashboard
  • Using SQL Server Management Data Warehouse
  • Shortcuts to Efficient Data Collection and Quick Analysis
  • This really is a deep dive into many of the key areas that DBA’s need to know about in order to manage their servers affectively. One of the things I like best about this book is that it doesn’t just deal with SQL Server but how the hardware level can affect performance. If you have Kalen Delaney’s Internals book this is the perfect companion.