Grumpy Old DBA

SQL Server Resource for the DBA

Publications, Books and White Papers

alittle light reading   
  • Storage Networking Fundamentals

  • Storage Area Networks for Dummies

  • I'd recommend these books as an excellent starting point, don't be miss-led by the Dummies title, it's anything but!.
  • SQL Server 2000 Performance Tuning Technical Reference

  • I still think this is the best starting point for coming to grips with performance tuning.
  • The Guru's Guide to SQL Server Boxed Set

  • Available in a boxed set, yes I know it's sql 2000 again, but these books are just so good, every DBA should own them.  
  • Inside SQL Server 2005: The Storage Engine

  • Inside Microsoft SQL Server 2005: Query Tuning & Optimization

  • Inside SQL Server 2005: T-SQL Programming

  • Inside Microsoft SQL Server 2005: T-SQL Querying

  • I'm not so sure on the famous "Inside" series spawning so many volumes, I used to like the one book to carry and I miss the electronic version.
     
  • MSDN Magazine

  • A useful source of information.
  • Technet Magazine

  • Keep up with microsoft technology.
  • Windows IT Pro Magazine

  • A wealth of knowledge for the DBA covering all those non sql things you just might find handy.
  • SQL Magazine

  • Long established SQL Server magazine.
    What's good about both is that you can subscribe to a CD version, without adverts, which has all the content since the magazines started.
  • Storage magazine

  • If you work with enterprise systems and want a heads up on what your storage team might be up to this is a good read.
  • Classic Rock Magazine

  • All work and no play ? Source of new and old proper rock music.
  • Carve

  • Canoe and Kayak Magazine

  • All work and no play ? British surfing and kayaking magazines.
     
  • Advantages of 64 bit environment

  • Microsoft white paper detailing advantages of using a 64bit environment.
  • Predeployment io best practices

  • This paper provides guidance for validating and determining the capacity of an I/O subsystem
  • SQL 2005 Waits and Queues

  • This paper approaches the complex area of Microsoft® SQL Server™ performance tuning using a methodology called Waits and Queues