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.

    Richard Douglas

    Richard is a Systems Consultant for a vendor of SQL Server solutions where he specialises in SQL Server providing solutions and system health checks to organisations across the EMEA region. Richard has recently taken on the responsibility of being Editor in Chief of the community site SQLServerPedia which provides articles on SQL Server and a blog syndication service, other duties see him regularly presenting webinars to both US and EMEA audiences. He is also a keen member of the SQL Server community, he founded and runs a PASS affiliated chapter in the UK (www.SQLStudy.org) and is on the organising committee for a national event called SQLRelay. Read more about Richard.

    More Posts - Website

    Follow Richard here:
    TwitterFacebookLinkedInGoogle Plus