MS2005 OR MS2008?

  • Hello,

    I would like to get certified using MS Server but don't know if I should take courses in

    the 2005 or 2008.

    Advice appreciated.

    Thanks

    CK;-)

  • I'd have to say 2008... if you're qualified in 2008, most people will consider you qualified in 2005.... but not the other way around.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thanks. Is there a big difference between the 2?

  • There are a fair number of enhancements when comparing 2008 to 2005 but the basics are the same. There're things like new ways to monitor the system, new data types, new ways to index, new types of backups, and more. You can find the complete list at the following URL:

    http://www.microsoft.com/sqlserver/2008/en/us/whats-new.aspx

    As a friendly side-bar, one of the most important aspects of becoming a successful DBA or SQL Developer is being able to use search engines to find MSDN and Books Online (BOL) articles that contain the authoritive answers to the types of questions you just asked. The most important reason for that is although there is a huge amount of information available on the internet and you can use forums to get some direction on problems, non authorative sources can and frequently are wrong. In the primary DBA areas of protecting the integrity of the data and the performance of the server, trust no one... test everything. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • I'd agree with Jeff on this one. If I were to be working on certification I'd go with 2008.

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

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