July 20, 2010

I’m an MCITP SQL Server 2008 DBA!

Posted in Certification, Learning, SQL Community, SQL Server, SQL University at 10:00 am by David Taylor

Last week, I passed the Microsoft 70-450 exam, PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008. I have the SQL Community to thank for it, and I’ll outline why as we go. Mainly, I was asked to write a blog post about how I prepared for the exam, so I will cover what I found helpful, and what I found not so much.

The preparation starts, as with all Microsoft exams, on Microsoft’s Learning site. For this exam, one would start at http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-450, which gives the overview, skills measured, preparation, and community links. The overview gives just that, the 50,000 foot look at the exam and the intended audience, along with what Microsoft thinks should be the set of features and concepts the candidate should have experience in. Good enough. I then skipped right to the Preparation Materials tab, thinking I would, like I did for the 70-432 MCTS exam, order up a Training Kit. How often do you see these two words together? #Microsoft – #Fail!

What I found was the following, copied verbatim from the page:

Preparation Tools and Resources
To help you prepare for this exam, Microsoft Learning recommends that you have hands-on experience with the product and that you use the following training resources. These training resources do not necessarily cover all of the topics listed in the “Skills Measured” tab.

Classroom Training
There is no classroom training currently available.

Microsoft E-Learning
There is no Microsoft E-Learning training currently available.

Microsoft Press Books
There are no Microsoft Press books currently available.


OK, plan B. Apparently Microsoft isn’t interested in training their users for a product that has been on the market for two years, and has actually been superseded by an R2 product! Looks like I needed to find my own way to study for this thing. Luckily, I am a member of the online SQL Server community, and can learn from the best! So, following Buck Woody’s school of thought, I turned to the Skills Measured tab.

If you haven’t seen it, this exam covers a lot. I mean a whole lot! The list of skills measured is actually kind of intimidating, at first. There are seven broad categories of features covered, with innumerable bullet points within each category, which in turn all have multiple objectives. I had taken the MCTS in February, and that was a little difficult, now I had scheduled the MCITP for July 6th, figuring that six months should be ample time to prepare for it.(I know, I know, I missed the Second Shot deadline, but there were reasons.) I was starting to wonder if that were long enough.

The first thing I did was look to see what was out there besides Microsoft’s non-offerings. I had heard good things about Train Signal, and they were having a sale, buy their Advanced SQL Server 2008 Database Administration Training DVD, and get their Windows Server 2008 R2 Training DVD free. Their DVDs do not come cheap, but one thing I had going for me was that getting certified was part of my annual goal at work, so they footed the bill.

So I sat through the 20-some hours of videos, thinking through 60-70 percent of it, ‘I know this stuff! And I am being talked to as if I were in the studio audience at a taping of Barney the Dinosaur!’ Really, it wasn’t that bad, but for something that bills itself as ‘Advanced Training,’ they sure spend a lot of time on the basics! Overall, I would say it’s a decent reference to have around, but I’m not sure it’s worth what they’re charging.

Next, I figured that I should have followed my first instinct, and turned to the community. I asked around a bit, and heard that several people had gone several ways, but the common denominators were Books Online, and Practice.

Always, it’s the basics that works. If you want to lose weight, eat less and exercise. If you want a good retirement, live frugally and save. How often is it that we lose sight of these things?

So for the last few weeks before the exam, that’s what I did. I went down the list of objectives in the Skills Measured list, looked up each term I didn’t already know in BoL, and tried each thing out that I could on a test server (my home computer, really – I don’t have a real ‘test server.’ At the time, (and even this moment) I did not have the proper setups to actually practice or perform any of the multiserver HA stuff, like clustering, or replication. I only have one little server box at work, with a whopping 2GB ram, and my home computer to play with. So really, I just read through everything I could about those technologies, trying to at least make sure I had a proper understanding of the concepts.

Throughout, as I said in the beginning, I had the community of which I am so proud to be a part. Every day folks were writing multiple blog posts, SQL University had a week on Certifications, just all kinds of resources to learn from. Actually, some of the best tidbits came from people’s #sqlhelp questions on Twitter, as they tried to figure out why one or the other of the things listed in the Skills Measured wasn’t working, the answers given were actually found as some of the multiple choices on the exam!

So that’s how I prepared. I found out what the requirements would be, I determined how to learn those requirements, I got a nifty couple of training videos, then I followed the community’s recommendation – I got back to basics. I followed the RTFM method, and practiced all I could. Now, because of all that, you are now reading the words of a Certified Professional.



  1. Upon reflection, I actually felt this blog is relevant and timely,
    either) and living free, living life in full appreciation of the natural world, keeps people feeling grounded.
    Philosophizing about deep philosophical subjects
    is likewise some other sort of experience that can assist us to
    make the discovery of self understanding. http://www.wir-sind-paderborn.de/cgi-bin/suchen.pl?suchworte=Massage-Schule%20ist%20der%20Weg%20zur%20Heilung

  2. Upon reflection, I felt like your blog is timely and relevant.
    Thank you exceedingly for writing this trove of information; if more writers wrote intelligent and time-worthy musings, I think we’d all be
    in a better situation. I, personally, consider it at truth that we should place our attention more on fitness
    and diet and escape from being perpetually in front of
    the computer or cell phone screen. Go outside!! (and not being
    glued to the cell phone all the while, either) and living life in full appreciation of
    the randomness and patterns of nature, helps people feel sane and feeling joyous.
    Philosophizing about vital topics is likewise an experience that can aid
    us make the discovery of self understanding. http://njmassages.com/Massage-Learning-Center/

  3. Whats up very cool blog!! Man .. Excellent .. Superb .. I will bookmark your web site and take
    the feeds additionally? I am glad to seek out
    numerous useful info right here within the post, we’d like
    develop extra techniques on this regard, thanks for sharing.
    . . . . .

  4. Hi to every body, it’s my first pay a quick visit of this web site; this webpage consists of amazing and truly
    good stuff in favor of visitors.

  5. Robin said,

    This piece of writing presents clear idea in support of
    the new viewers of blogging, that truly how to do blogging.

  6. I have read so many articles on the topic of the blogger lovers but this post is
    really a pleasant paragraph, keep it up.

  7. Para se ter uma ideia de sua relevância, nos Estados Unidos eles são responsáveis por 50% do PIB
    vernáculo, na Mulata por 60% e no Brasil já chegaram à morada dos 21%, afirma Augusto Athayde, Consultor de Mercado do Banco do Brasil. http://ascensionbuilds.com/forums/index.php/394016-o-que-sao-sites-responsivos/0

  8. Hello to every single one, it’s truly a pleasant for me to visit
    this web page, it contains valuable Information.

  9. Thoae web sites managed tо doo welⅼ for ѕometime althouցh tһey havе been a nuisance
    ɑnd most people usе to run away from these websites.

  10. David Taylor said,

    Thanks, folks. I realize there is debate within the community regarding the perception, effectiveness and necessity of obtaining SQL Server certification. For me the reasons are twofold. One, when it was review time, and my boss and I were trying to hash out what I could do this year for my professional continuous improvement, I picked obtaining my MCITP DBA and the ASQ CQE as goals. Secondly, I am hampered at every turn for not ever having earned my degree. Now one could argue that if I had earned my degree (nearly thirty years ago), I would be conversant in VAX systems and PASCAL, and it would be useless today anyway. Regardless, people seem to hold them in some esteem, so I need to do something to try and make up for the lack. Earning my certs in SQL Server I consider steps towards covering that perceived lapse.

  11. John Sansom said,

    Excellent news, great work and welcome to the club 🙂

  12. That’s great! It’s great to know that you can do it -even if it isn’t necessary.

  13. Glenn Berry said,

    Good work! It is always good to make the effort to pass those exams.

  14. Kevin Mckenna said,

    Congrats! 🙂

    And thanks for the Blog post – I’m gonna bookmark it for when I get there

  15. Once again, congrats on the accomplishment! Always glad to see folks succeed and forge ahead and continue thriving within the community. May your bacon always be crisp, good sir!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: