Just taken new Job as a SQL Server DBA, can anyone recommend some learning material?

  • I come from a SQL developer background but have now taken a position as a DBA. Recovery plans , security policies , are new to me. So need to gain some knowledge before I start the new role.

    I found this book does any know if its worth getting?

    SQL Server 2008 Administration in Action

  • http://www.sqlservercentral.com/articles/books/76296/

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]

  • The two books below in my signature can help with query tuning. I also wrote part of an introductory book called Begginning SQL Server 2012 Administration. After that, all the free books available from Red Gate are a priceless resource.

    "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

  • Thanks Guys appreciate your suggestions.

  • Hi Bugg,

    I think 'Trounbleshooting SQL Server, A Guide for Accidental DBAs' by Johnathan Kehayias and Ted Krueger, would be a good read before you start. It's available on the Red Gate site for free as an ebook. (Same link as posted by Grant).

    Dave.

    Dave Morris :alien:

    "Measure twice, saw once"

  • Dave Morris (10/18/2012)


    Hi Bugg,

    I think 'Trounbleshooting SQL Server, A Guide for Accidental DBAs' by Johnathan Kehayias and Ted Krueger, would be a good read before you start. It's available on the Red Gate site for free as an ebook. (Same link as posted by Grant).

    Dave.

    that one helped me get a rather large head start and would highly recommend it. Redgate just released a new one on backup and restores that im in the process of moving to my kindle as i type. but knowing redgate should be preaty good.


    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

  • Hey ,

    i think going with

    SQLSERVERCENTRAL books is good beside this

    for some Quick learning you can use

    SQL server 2008 for dummies

    and going through blogs of Experienced DBA

    will do it for you.

    Share the knowledege

  • Grant Fritchey's book SQL Server Execution Plans is also an excellent resource for learning how to tune your troublesome queries.

Viewing 8 posts - 1 through 7 (of 7 total)

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