Which Version of SQL Server should I Study?

  • Hello Everyone,

    I decided to become an SQL Server DBA and wanted to know which version of SQL Server I should start with. Should I start with SQL Server 2014 even though there is no certification yet, or should I proceed with SQL Server 2012 instead?

  • I would suggest studying 2014. Even if you take the 2012 exams you will have everything you need to know to pass them, plus something more.

    -- Gianluca Sartori

  • The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if you learn the more current mechanisms rather than the older ones. I would study SQL Server 2014 (in fact, I do). However, I strongly advise against studying for certification. I know all the arguments in favor of certs, but their value out in the industry is marginal, at best. Gain the knowledge, absolutely, but also find ways to gain experience. Experience is infinitely more valuable to getting a job than certifications are.

    "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

  • spaghettidba (10/28/2014)


    I would suggest studying 2014. Even if you take the 2012 exams you will have everything you need to know to pass them, plus something more.

    The MCSE exams should have been updated with 2014 content as well.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Grant Fritchey (10/28/2014)


    The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if you learn the more current mechanisms rather than the older ones. I would study SQL Server 2014 (in fact, I do). However, I strongly advise against studying for certification. I know all the arguments in favor of certs, but their value out in the industry is marginal, at best. Gain the knowledge, absolutely, but also find ways to gain experience. Experience is infinitely more valuable to getting a job than certifications are.

    Unfortunately certs are required to become a Microsoft Gold Partner.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (10/28/2014)


    Unfortunately certs are required to become a Microsoft Gold Partner.

    Or MCT

    -- Gianluca Sartori

  • Thanks everyone. This helps me a lot. And your right certs don't guarantee a job. Only experience.

  • Koen Verbeeck (10/28/2014)


    Grant Fritchey (10/28/2014)


    The fundamentals are the same from 2005 through 2014, so on lots of levels, it doesn't matter which you study. However, your knowledge will have a longer shelf-life if you learn the more current mechanisms rather than the older ones. I would study SQL Server 2014 (in fact, I do). However, I strongly advise against studying for certification. I know all the arguments in favor of certs, but their value out in the industry is marginal, at best. Gain the knowledge, absolutely, but also find ways to gain experience. Experience is infinitely more valuable to getting a job than certifications are.

    Unfortunately certs are required to become a Microsoft Gold Partner.

    True, but that's about meeting a Microsoft requirement, not about getting a job.

    "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

  • I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely see a lot more!

  • jeffgonzalez007 (10/28/2014)


    I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely see a lot more!

    Well, there's at least one.

    "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

  • Grant Fritchey (10/28/2014)


    jeffgonzalez007 (10/28/2014)


    I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely see a lot more!

    Well, there's at least one.

    Would you really trust the author of that book? :hehe:

    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
  • Luis Cazares (10/28/2014)


    Grant Fritchey (10/28/2014)


    jeffgonzalez007 (10/28/2014)


    I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely see a lot more!

    Well, there's at least one.

    Would you really trust the author of that book? :hehe:

    Well, it does depend on what we're going to trust him with. Do want him to guard your scotch? No.

    "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

  • Grant Fritchey (10/28/2014)


    jeffgonzalez007 (10/28/2014)


    I think I'm going to start with SQL Server 2012. I'm not seeing to many books out there yet on the 2014 version. For 2012 I definitely see a lot more!

    Well, there's at least one.

    Shame, he has none! 😉

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 13 posts - 1 through 12 (of 12 total)

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