SQL Server Books for DBAs

I decided that since people were interested in my SQL Blogger Rankings, then perhaps I should go one step further and help people stock their bookshelves. After all, I remember what it was like when starting as a DBA. How do you know who you can trust to give you quality information? You don’t, so you rely on your friends to recommend some good quality books.

If you only had time to read one book before taking on a project, do you know which book to reach for, or order? It is my hope that the books I list here will be able to help you along.

If you have a review you would like to give on a book you feel should be included, just drop me an email.

SQL 2014 Books

Here are the books I recommend that are currently available for SQL 2014.

Professional Microsoft SQL Server 2014 Administration

Pro SQL Server Internals

SQL 2012 Books

Here are the books I recommend that are available for SQL 2012.

Microsoft SQL Server 2012 T-SQL Fundamentals

Professional SQL Server 2012 Internals and Troubleshooting

T-SQL Fundamentals for Microsoft SQL Server 2012 and SQL Azure

SQL Server 2012 Query Performance Tuning

Professional Microsoft SQL Server 2012 Administration

Expert Performance Indexing for SQL Server 2012

Pro SQL Server 2012 Relational Database Design and Implementation

DBA Technical Books

Here are the books I recommend in terms of building a base technical knowledge on all things related to MS SQL Server.

Microsoft® SQL Server® 2008 Internals (Pro – Developer)

Microsoft® SQL Server® 2008 T-SQL Fundamentals (PRO-Developer)

Microsoft SQL Server 2008 Management and Administration

SQL Server 2008 Query Performance Tuning Distilled (Expert’s Voice in SQL Server)

Kimball’s Data Warehouse Toolkit Classics: The Data Warehouse Toolkit, 2nd Edition; The Data Warehouse Lifecycle, 2nd Edition; The Data Warehouse ETL Toolk

Pro SQL Server 2008 Policy-Based Management

Microsoft SQL Server 2008 Administrator’s Pocket Consultant

Windows Server 2008 Hyper-V: Insiders Guide to Microsoft’s Hypervisor

Securing SQL Server: Protecting Your Database from Attackers

Data Analytics and Insights

Here are the books I recommend for data professionals that are looking enter into the field of business analytics.

Predictive Analytics: The Power to Predict Who Will Click, Buy, Lie, or Die

Data Science for Business: What you need to know about data mining and data-analytic thinking

Super Freakonomics: Global Cooling, Patriotic Prostitutes, and Why Suicide Bombers Should Buy Life Insurance

Freakonomics: A Rogue Economist Explores the Hidden Side of Everything

DAX Formulas for PowerPivot: The Excel Pro’s Guide to Mastering DAX

PowerPivot for the Data Analyst: Microsoft Excel 2010 (MrExcel Library)

Visualizing Data with Microsoft Power View

Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model

Expert Cube Development with Microsoft SQL Server 2008 Analysis Services

Microsoft PowerPivot for Excel 2010: Give Your Data Meaning

Delivering Business Intelligence with Microsoft SQL Server 2012 3/E

DBA Professional Development Books

Here are the books I would recommend with regards to professional development for DBA’s. They are all focused on improving your soft skills. The other book libraries contain a wealth of information to help you with your technical skills.

Writing That Works: How to Communicate Effectively in Business

The Phoenix Project: A Novel About IT, DevOps, and Helping Your Business Win

Kitchen Confidential Updated Ed: Adventures in the Culinary Underbelly (P.S.)

The Jelly Effect: How to Make Your Communication Stick

Never Eat Alone: And Other Secrets to Success, One Relationship at a Time

The Whuffie Factor: Using the Power of Social Networks to Build Your Business

Driving Results Through Social Networks: How Top Organizations Leverage Networks for Performance and Growth (J-B US non-Franchise Leadership)

ProBlogger: Secrets for Blogging Your Way to a Six-Figure Income

How To Start A Conversation And Make Friends

The 21 Irrefutable Laws of Leadership: Follow Them and People Will Follow You

The Education of an Accidental CEO: Lessons Learned from the Trailer Park to the Corner Office

Secrets of Consulting: A Guide to Giving and Getting Advice Successfully 

DBA Database Design Books

Here are the books I would recommend with regards to database design something I consider to be a lost art these days due to advances in hardware. Powerful CPU, lots of memory, and fast disks are able to overcome and hide bad database designs. Typically bad designs are only exposed after being deployed to production. I hope these books can help someone to avoid such a situation.

Designing Effective Database Systems (Addison-Wesley Microsoft Technology Series)

Pro SQL Server 2008 Relational Database Design and Implementation

A Developer’s Guide to Data Modeling for SQL Server: Covering SQL Server 2005 and 2008

Kimball’s Data Warehouse Toolkit Classics: The Data Warehouse Toolkit, 2nd Edition; The Data Warehouse Lifecycle, 2nd Edition; The Data Warehouse ETL Toolk

The Data Warehouse Lifecycle Toolkit

Beginning Database Design: From Novice to Professional

DBA Database Modeling Books

Here are the books I would recommend with regards to database modeling.

The Data Model Resource Book, Vol. 1: A Library of Universal Data Models for All Enterprises

The Data Model Resource Book, Vol. 2: A Library of Data Models for Specific Industries

The Data Model Resource Book, Vol. 3: Universal Patterns for Data Modeling

Data Modeling Essentials, Third Edition

Data Modeling Theory and Practice

Data Modeling Made Simple with CA ERwin Data Modeler r8

Data Modeling for the Business: A Handbook for Aligning the Business with IT using High-Level Data Models (Take It with You Guides)

Some Favorite Non-SQL Books

Here are some of my favorite books that are not related to SQL.

The Rosie Project: A Novel

Pale Blue Dot: A Vision of the Human Future in Space

Shadows of Forgotten Ancestors

A Brief History of Time

Parallel Universes

Black Holes and Baby Universes and Other Essays

Why Nothing Can Travel Faster Than Light… : And Other Explorations in Nature’s Curiosity Shop

Physics For the Rest of Us

Enjoy!

35 Pingbacks/Trackbacks

36 Comments

  1. Book Reviews | SQLBatman.com
    Apr 22, 2009 @ 11:15:05

    [...] I have decided to create a new page with some widgets that display books related to various topics. Right now, there are two libraries [...]

    Reply

  2. The SQL Doctor Is In | SQLBatman.com
    Apr 28, 2009 @ 21:45:24

    [...] SQL Server 2008 Relational Database Design and Implementation) by Louis Davidson et al., in my Technical Library. No question this is a must read for anyone interested in database design  and since Denis also [...]

    Reply

  3. There’s a SQL In My Pocket | SQLBatman.com
    May 05, 2009 @ 11:13:34

    [...] rack in the datacenter), it is nice to have this manual handy. And so, I have placed it onto my Technical Library bookshelf. Big hands mean big [...]

    Reply

  4. New Bookshelf | SQLRockstar
    Jun 07, 2009 @ 15:25:34

    [...] serve anyone looking to get a good base knowledge of the fundamentals, and that is why I gave them their own bookshelf. Enjoy. Tags: Book [...]

    Reply

  5. Windows Hyper-V Book | SQLRockstar
    Jun 26, 2009 @ 07:23:15

    [...] A few weeks back I had the good fortune to attend a seminar at which John Kelbley was presenting. He happened to mention that he had recently finished a book on Hyper-V (OK, he mentioned it a dozen times), and I made a note to include it in my library. [...]

    Reply

  6. PASS contest winner | SQLRockstar
    Jul 24, 2009 @ 06:57:31

    [...] Rank, perhaps you know him as a respected author of technical books because you found him in my library, or perhaps you know him because of his ability to bend spoons with just the power from his mind. [...]

    Reply

  7. Book Review: Twitter Wit | SQLRockstar
    Oct 28, 2009 @ 11:31:41

    [...] first few hours. If you enjoy using Twitter then you would enjoy this book. I have added it to my library, placing it on my Professional Development [...]

    Reply

  8. Book Review: Outliers, the Story of Success | SQLRockstar
    Jan 25, 2010 @ 13:17:09

    [...] still a good read, I enjoyed a lot of the stories, but I won’t add it to my library at this point. Tags: Book [...]

    Reply

  9. Book Review: The 21 Irrefutable Laws of Leadership | SQLRockstar
    Feb 04, 2010 @ 11:03:15

    [...] have added the book to my Book Review page at http://thomaslarock.com/book-reviews/, inside of the Professional Development [...]

    Reply

  10. Book Review: The Tipping Point | SQLRockstar
    Feb 25, 2010 @ 21:32:19

    [...] won’t put this book into my library, but I would still recommend it to [...]

    Reply

  11. SQL Server Training Resources | SQLRockstar
    Mar 10, 2010 @ 08:26:08

    [...] also happen to maintain a list of SQL Server books for DBAs. You can start adding these to your own personal library. Check out the authors I have on my shelf [...]

    Reply

  12. Book Review: The Education of an Accidental CEO | SQLRockstar
    Apr 19, 2010 @ 08:27:09

    [...] It’s well worth a few dollars to have this book on your bookshelf. In fact, I decided to add it to my library here as well. [...]

    Reply

  13. SQL University – Professional Development Week | SQLRockstar
    Apr 21, 2010 @ 09:00:28

    [...] you are looking for some professional development books then I can point you to my library as well as my own book, DBA [...]

    Reply

  14. SQL University - Database Design/Development Week | SQLRockstar
    Jun 30, 2010 @ 14:11:58

    [...] have a section of my library dedicated to database design books. I really like Beginning Database Design: From Novice to [...]

    Reply

  15. SQL University - Indexing Week | SQLRockstar
    Jul 20, 2010 @ 08:43:55

    [...] for you to know what you need, and when, is through experience. You can read all you want from a book about indexing, but the bottom line is your shop is unique, and your situation is not always going to fall into [...]

    Reply

  16. Book Review – the cult of the amateur | SQLRockstar
    Jan 04, 2011 @ 13:26:10

    [...] am not adding the book onto my bookshelf at this time, but feel free to browse around for anything else you might [...]

    Reply

  17. Book Review - The Secrets of Consulting | SQLRockstar
    Jan 11, 2011 @ 11:44:58

    [...] I’ve added this book to my library, it is in the Professional Development shelf. [...]

    Reply

  18. Securing SQL Server In My Library | SQLRockstar
    Mar 14, 2011 @ 10:41:45

    [...] Last month I told you about how Denny Cherry’s new book, Securing SQL Server had been released into the wild. Today I am here to tell you that I have added his book to my library. [...]

    Reply

  19. Time for a Little PD | Home Of The Scary DBA
    Jun 13, 2011 @ 07:46:45

    [...] Wuffie Factor: Got this one from Tom LaRock’s (blog|twitter) reading list. He has some good [...]

    Reply

  20. There’s a SQL In My Pocket | SQLRockstar | Thomas LaRock
    Jan 26, 2012 @ 20:19:16

    [...] rack in the datacenter), it is nice to have this manual handy. And so, I have placed it onto my Technical Library [...]

    Reply

  21. The SQL Doctor Is In | SQLRockstar | Thomas LaRock
    Jan 26, 2012 @ 20:20:45

    [...] SQL Server 2008 Relational Database Design and Implementation) by Louis Davidson et al., in my Technical Library. No question this is a must read for anyone interested in database design  and since Denis also [...]

    Reply

  22. SQL 2012 Books Available Soon | SQLRockstar | Thomas LaRock
    Mar 02, 2012 @ 14:00:59

    [...] soon as I get my hands on some of the SQL 2012 books that are coming out I will get them added to my library. __spr_config = { pid: '4ef2348c396cef53f800004f', title: 'SQL 2012 Books Available Soon', ckw: [...]

    Reply

  23. SQL 2012 Books I Want To Have | SQLRockstar | Thomas LaRock
    Mar 09, 2012 @ 10:42:50

    [...] can check out the other books I have selected for my SQL 2012 library. And if you think there is a book I need to include in my list just leave me a comment or drop me [...]

    Reply

  24. Predictive Analysis: I Bet You Didn't Know I Would Blog This Today | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:24:40

    [...] that is because I understand you cannot predict the future.Need another example? Well, check out my library bookshelf. I started placing reference books onto my site, and yes they link back to Amazon. If someone stops [...]

    Reply

  25. SQL University - Advanced Troubleshooting Week | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:28:31

    [...] that I consider to be very good when it comes to advanced troubleshooting. I can also point you to more than a handful of books. However, what you really need to do here is to build your own resource list. And you can get [...]

    Reply

  26. Book Review: The Education of an Accidental CEO | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:29:59

    [...] well worth a few dollars to have this book on your bookshelf. In fact, I decided to add it to my library here as well. sqlrockstar Book Reviews, Professional Development, SQLServerPedia Wiki 0 Book Reviews, [...]

    Reply

  27. Book Review: Outliers, the Story of Success | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:31:54

    [...] still a good read, I enjoyed a lot of the stories, but I won’t add it to my library at this point. sqlrockstar Book Reviews, SQLServerPedia Wiki 5 Book Reviews « New Tip at [...]

    Reply

  28. Windows Hyper-V Book | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:33:55

    [...] a book on Hyper-V (OK, he mentioned it a dozen times), and I made a note to include it in my library.I have been spending the past few weeks at work focusing on a server consolidation effort. Part of [...]

    Reply

  29. Book Reviews | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 09:35:41

    [...] Rankings a thought crossed my mind:Why not do something similar with books?So, I have decided to create a new page with some widgets that display books related to various topics. Right now, there are two libraries [...]

    Reply

  30. One Day Sale, e-book Only $15 at Apress | DBA Survivor
    Nov 26, 2012 @ 09:45:57

    [...] And you can also check out other books I have listed in my library. [...]

    Reply

  31. Buy Me For $15 Today | SQLRockstar | Thomas LaRock
    Nov 26, 2012 @ 10:17:25

    [...] (November 26th) over at Apress, you can get the e-book for only $15 USD.And you can also check out other books I have listed in my library. sqlrockstar Book Reviews, SQL MVP, SQLServerPedia Wiki 0 « All The Datas!/**/var [...]

    Reply

  32. Book Review: Pro SQL Database for Windows Azure | SQLRockstar | Thomas LaRock
    Dec 20, 2012 @ 09:30:38

    [...] now thinking of adding a new bookshelf to my library: http://thomaslarock.com/sqlserverbooks for Azure or Cloud topics in general, and placing this book there. If there are other books on [...]

    Reply

  33. Top 10 Learning Resources for Accidental DBAs | Glenn Berry
    Jan 03, 2013 @ 14:17:58

    [...] SQL Server Books for DBAs (Thomas LaRock’s list of recommended SQL Server books) [...]

    Reply

  34. Book Recommendation: Writing That Works - How to Communicate Effectively in Business - SQLRockstar - Thomas LaRock
    May 22, 2013 @ 10:21:48

    [...] added this book to my SQL Server Books page, you can find it in the Professional Development [...]

    Reply

  35. SQL SERVER tutorial
    Aug 21, 2013 @ 04:42:00

    fantastic collections….i learn many things about SQL…..really very helpful to implement the projects

    Reply

  36. Data Is The New Oil - SQLRockstar - Thomas LaRock
    Aug 29, 2014 @ 13:20:50

    […] to be a well written overview for the field of predictive analytics (PA). You can find the book in my bookshelf but I also wanted to share some thoughts on the book […]

    Reply

Leave a Reply

*