Post reply

Recommend a good SQL 2005 Book?

  • November 16, 2008 at 1:02 pm

    #126888

    I'm after recommendations on a book that will let me learn basic SQL 2005 administration.

    I'm a sysadmin (don't quite need a dummies guide) who will have to help setup, configure, and (importantly) maintain a new SQL 2005 box as our current dba is leaving the department (we're a small company so don't have a dedicated dba, in reality it's a guy who's done a course and has spent some time with SQL so knows the most about it).

    I guess what I want is something that will teach me the basics from a sysadmin point of view i.e. best practice, backup/restore and security/permissions vs. wanting to learn all the in's and out's of SQL as a language.

    Thanks in advance.

  • November 16, 2008 at 1:41 pm

    #899097

    I usually trust books from SAMS like Microsoft SQL Server Unleashed -in this case.

    just my personal choice/opinion.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  • November 17, 2008 at 4:50 am

    #899246

    BOL is also excellent source!!! just go through chapter vise i.e. Topic wise. It will give indepth knowledge.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • November 17, 2008 at 5:09 am

    #899252

    The SQL 2005 bible is one the best books out there in my opinion.

    http://www.amazon.com/Server-2005-Bible-Paul-Nielsen/dp/0764542567/ref=pd_bbs_sr_3?ie=UTF8&s=books&qid=1226923680&sr=8-3

  • November 17, 2008 at 7:15 am

    #899319

    This is also a good book that the DBA's in my department refer to:

    http://www.amazon.com/Microsoft-SQL-Server-2005-Unleashed/dp/0672328240/ref=sr_11_1?ie=UTF8&qid=1226931286&sr=11-1

    Gaby________________________________________________________________"In theory, theory and practice are the same. In practice, they are not." - Albert Einstein

  • November 17, 2008 at 10:28 am

    #899454

    i have books from Wrox which are fantastic

    Professional SQL 2005 programming

    Professional SQL2005 performance tuning

    I recommend these. They go into a lot of detail about the database engine (datafiles, logfiles, B-Tree indexes, etc)

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

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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