Recommended Books for SQL Server DBAs

There’s a ton of SQL Server books out there to help get you started on the road to becoming a database administrator.  I’m going to start at the start of your career, and go forward.

Category Beginner Books
Advanced Books
Performance Tuner Books
Production Database Administration:
Backups, restores, installing SQL, clustering, security.
SQL 2008:
SQL Server 2008 Administration in ActionSQL 2005:
Professional SQL 2005 Administration
SQL 2008:
SQL Server 2008 Management and Administration
SQL 2008:
SQL Server 2008 Internals and Troubleshooting(I coauthored this)SQL 2005:
Inside SQL 2005: The Storage Engine and
Professional SQL Server 2005 Performance Tuning
T-SQL Development:
Stored procedures, queries, views, triggers.
SQL 2008:
SQL Server 2008 T-SQL Fundamentals
SQL 2008:
Inside SQL 2008 T-SQL QueryingSQL 2005:
Inside SQL 2005 T-SQL Querying

SQL Server, Oracle, and MySQL:
SQL in a Nutshell

SQL 2008:
SQL Server 2008 Query Performance Tuning DistilledSQL 2005:
Same book as 2008. Almost everything applies.

My Favorite Non-SQL Server Books

These books aren’t specific to DBAs, but are things I’ve found really helpful in my career:

Getting Things Done

Getting Things Done by David Allen

Do you get nervous at the thought of opening your email in-box because there’s so much piled up, and you don’t know where to begin? Do you struggle with to-do lists and project management software? Tired of struggling to keep your dayplanner up-to-date? Feel like you’re never going to catch up? Jealous of those folks on Twitter who keep shouting “Inbox Zero!”?

David Allen’s book Getting Things Done has been the answer for me and for a few of the folks I work with. It’s a simple, no-nonsense approach to managing daily tasks. Knowledge workers these days have an unending stream of incoming “stuff”, and the GTD philosophy is about rapidly handling as much as you can, as fast as you can, and feeling absolutely comfortable knowing that you can’t handle everything.

I showed my current manager into the GTD philosophy, and he caught on right away. He went from hundreds of emails in his in-box down to less than half a dozen in a couple of weeks. He responds faster to requests, and clearly feels confident in managing his day-to-day inflow of tasks.

You can buy the paperback on Amazon, and there’s also a Kindle version.

Time Management for Systems Administrators by Thomas Limoncelli

If you’re not quite ready for the GTD strategy, check out this lighter version of the philosophy that’s tailored specifically for IT workers.  It’s a much smaller book, and breaks down just what you need to know in order to get your work done faster. One of my former managers gave this out as a Christmas present a few years ago to all of his staff after I converted him to GTD.

You can buy the paperback on Amazon, and there’s also a Kindle version.

The Whuffie Factor by Tara Hunt

Whuffie is slang for social capital: your reputation, your credibility, your personal bankability.  It’s not as simple as the number of followers you have on Twitter, because that doesn’t necessarily indicate your trustworthiness – there’s plenty of spammers who’ve mastered the art of the followback.  It’s not as simple as the number of posts you’ve made on a forum somewhere, because that just indicates you’re really good at clicking the Submit button.

This concept isn’t just for marketing people – it matters to IT professionals.  As we go through more and more layoffs, the concept of a lifelong career at the same company is nearly gone.  You need to find out how to market yourself to find a job before it’s too late – and when you’ve been laid off, it’s already too late.

You can read my review of the Whuffie Factor, buy the paperback on Amazon, and there’s also a Kindle version.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

78 Responses to Recommended Books for SQL Server DBAs
  1. David Stein
    August 15, 2008 | 8:13 AM

    Is it appropriate to share our SQL Server book recommendations here?

    My first SQL book was “Sams Teach Yourself SQL in 10 Minutes” by Ben Forta. Ben is one of the best technical writers around and this book is an excellent introduction to SQL language. It introduces topics and then shows how the syntax differs for MS SQL, Oracle, and others.

    I still refer to this book for quick answers, and in my opinion is a great first book for aspiring DBA’s such as myself.

  2. [...] Brent Ozar provides a great list of Recommended Books for SQL Server DBAs. [...]

  3. mimi
    April 30, 2009 | 5:30 PM

    what does DBA stand for?

  4. Brent Ozar
    April 30, 2009 | 5:31 PM

    DataBase Administrator.

  5. Scott Herbert
    April 30, 2009 | 10:56 PM

    I wish I had a photo of your face when you answered that question.

  6. Daniel
    June 4, 2009 | 6:03 PM

    Hey Brent,

    Have you ever read Oreilly’s book? I found it to be quite a good read on the fundamentals of relational database theory.

    Daniel

  7. Daniel
    June 4, 2009 | 6:04 PM

    Wow, how did I manage to screw up that HTML tag? That is embarrassing!

  8. Brent Ozar
    June 5, 2009 | 7:17 AM

    Daniel – no, I haven’t read that, but I did save you from that awkward comment booboo by editing it, hahaha.

  9. Fran
    June 15, 2009 | 9:42 AM

    I want to become better at SSIS. What book do you suggest is good to get started?

  10. Brent Ozar
    June 15, 2009 | 9:47 AM

    Hi, Fran. I’ve never done SSIS work, so I wouldn’t be able to recommend a good book myself. I do know a few of the authors of this book:

    http://www.amazon.com/Professional-Server-Integration-Services-Programmer/dp/0764584359/ref=sr_1_1?ie=UTF8&s=books&qid=1245073594&sr=8-1

    And they’re really smart folks.

  11. Fran
    June 15, 2009 | 10:42 AM

    Thanks Brent…

  12. JamieK
    June 23, 2009 | 3:52 PM

    Hi Brent,
    Do you have any recommendations for T-SQL books for administrators? I am looking at SQL 2005 and 2008 if that makes much difference.

    Thanks!

    JamieK

  13. Brent Ozar
    June 24, 2009 | 8:35 AM

    Jamie – good question. As crazy as this sounds, I like recommending SQL for Dummies – it’s good because it teaches proper ANSI syntax. If you write T-SQL with the ANSI syntax, your skills are more portable across different RDBMS’s.

  14. James Park
    July 14, 2009 | 9:18 AM

    Hi, Brent. I accidently found your website today and enjoyed reading about you and your career.

    I’ved worked with DB2 on z/OS. But our recent major project will shift me to SQL Server. Which book would you recommend to read as a beginner?

    • Brent Ozar
      July 14, 2009 | 9:20 AM

      James – it depends. What kind of work will you be doing on SQL Server? Writing T-SQL, administration, business intelligence, etc?

  15. James Park
    July 14, 2009 | 9:30 AM

    Basically everything, I believe.

    There is no SQL DBA right now, only contractors in our agency. We are a DB2 shop on z/OS. There is one person who does a SQL DBA role, but he doesn’t have a SQL dba background. His position now is a help desk. Two of DBAs on z/OS (including me) will be shifting to SQL Server soon or later. I believe we will be doing all aspects of SQL server. I am interested in reading Administration since that’s what I have been doing.

  16. Brent Ozar
    July 14, 2009 | 9:41 AM

    James – okay, great, take the Administration book that’s on the top of this page.

  17. James Park
    July 14, 2009 | 9:48 AM

    Thank you, Brent, for your valuable advice. I would regard your advice as highly valuable and buy a book and start reading before I am shifted.

  18. Sarath
    July 16, 2009 | 3:59 PM

    Hi how r u Brent Ozar ?
    I just want to no the book which will be easy read and follow for the sql dba so please same me a book which will be most use full for me .. please send me the link to my mail sarath_e_chandra@yahoo.co.in

  19. Louis naylor
    July 19, 2009 | 10:29 AM

    i have just finished college and looking at courses,books and online material for any introduction into DBA jobs i want to be a DBA and have all the qualifications such as SQL,MYSQL ect and i want to work on unix. is there any specific courses or type of job that is ?
    also is becoming certified that important or does it just boost your pay levek

    • Sarath
      July 21, 2009 | 3:29 AM

      hi lousi naylor
      how r u ? i also completed my course friend .. i am in search of a book for dba … so sorry that i cant help u in this one but one thing if ur going to do unix it is good but one thing .. just try on one thing .. it will be good ………………….

    • Brent Ozar
      July 23, 2009 | 10:17 PM

      Louis – if you click on the Becoming a DBA tab at the top of my site, I’ve got several articles about this. Hope that helps!

  20. Sarath
    July 21, 2009 | 3:25 AM

    Hi how r u Brent Ozar ?
    I just want to no the book which will be easy read and follow for the sql dba so please same me a book which will be most use full for me .. please send me the link to my mail sarath_e_chandra@yahoo.co.in

    • Brent Ozar
      July 23, 2009 | 10:16 PM

      Hi, Sarath. Click on Becoming a DBA, and I’ve got several links with recommended books.

  21. Sarath Chandra Edupalli
    July 29, 2009 | 2:32 AM

    Hi Brent thanks for ur information

  22. Dave Schutz
    August 4, 2009 | 2:50 PM

    Brent,

    I’ve been reading Itzik Ben-Gan’s book SQL Server 2008 T-SQL Fundamentals and it’s a great book on T-SQL. He starts with set theory and shows lots of examples. Choose this book because Itzik is supposed to be the T-SQL guru. I’m a sys admin and also a accidental DBA .

  23. JamieK
    August 4, 2009 | 3:09 PM

    Thanks Brent and Dave S, both of your suggestions are very helpful!

    JamieK

  24. ball
    August 7, 2009 | 3:08 AM

    hi Brent. i am very much impressed with your answers.i m gerate fan of u Brent.i started reading sql server dba in online.but i want one hardcopy book.so please suggest me which book is good for starter of sql server dba 2005 and 2008. please suggest me book name and author. thank you.

    • Brent Ozar
      August 7, 2009 | 8:01 AM

      Ball – hi, thanks for the compliments. What kind of work would you like to do with SQL Server? Management, T-SQL development, business intelligence, etc?

  25. ball
    August 8, 2009 | 1:55 PM

    hi brent thanks for your responce. i am getting training in sql server production dba. my kind of work is backup and restore, logshipping,replication,miroring..etc. i am strong in sql and plsql and i worked as a plsql devolper. now i am going to place as a sql server production dba according to my client requirement. pease think that i am starter to sql server dba and suggest me good book with author name for 2005 and 2008 editions. thank you.

    • Brent Ozar
      August 8, 2009 | 7:04 PM

      OK, I would recommend the first book on this page, SQL Server 2008 Management and Administration by Ross Mistry.

Leave a Reply

Wanting to leave an <em>phasis on your comment?

Notify me of followup comments via e-mail. You can also subscribe without commenting.