good SQL Server dba books

  • Hi.I am learning SQL Server in hope to get a job as dba.I'm early in my learning process.I watched some youtube videos and became familiar with basic queries,syntax and etc.My question is how to continue from now on?What are some good books(or other online resources) to learn about SQL Server and especially operational side of it(such as backup/restore, performance tuning, and security administration) .I'm learning by my own and any guidance really would be appreciated.Thanks.

  • One of the first, and most important resources, you've already found. SQL Server Central is one of the best places to get more learning. Not only from the forums like you have already found, but all the articles posted on here daily. In particular you should check out the Stairways over on the left. Another web site that's good is Simple-Talk.com. As far as books go, there are tons and tons (a few below in my signature are personal favorites for obvious reasons). If you're just getting started, the one book I always recommend is Itzik Ben-Gan's book on T-SQL Querying. It's a must have on every DBAs desk.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Troubleshooting SQL Server: A Guide for the Accidental DBA

    is a good one

    ---------------------------------------------------------------------

  • The books section in this site is a good source.

    http://www.sqlservercentral.com/Books/

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2
  • Ditto what was said thus far.

    ...and especially operational side of it(such as backup/restore, performance tuning, and security administration)

    I would add: Beginning SQL Server 2012 Administration 😉

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply