Recommended SQl Server 2005 Books

  • I have worked with SQL Server from version 7 for 8 years and I am looking for a good book or books on SQL Server 2005. Here are the areas where I think I need the most help in 2005:

    Schemas - I understand what they are but need some practical uses

    Encryption

    CLR Integration

    CTE's

    Where to find things in SSMS - I miss EM

    And always performance tuning and optimization

    I like to think I am competent in Admin and T-SQL Basics, but I know I can learn more. In addition to the things above if you have any recommendations on:

    Service Broker

    Notification Services

    I realize that each of the topics could probably fill a book I'd like to get 2 or 3 indispensable ones.

    Thanks in advance.

  • All three of the Inside SQL Server 2005 books provide information you'll need.

    "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

  • For SQL Server Management Studio, do a search on Amazon.com for Dale Elizabeth Corey. She wrote a book on SSMS that used to be distributed via SSC. I don't know if SSC still does.

    For encryption (and security matters), I shameless point to the book I contributed to, How to Cheat at Securing SQL Server 2005. I didn't write the chapter on encryption, but it is decently sized and covers the topic.

    K. Brian Kelley
    @kbriankelley

Viewing 3 posts - 1 through 2 (of 2 total)

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