As one of the bloggers behind The Master Blog, Joe Sack is a public face for the SQL MCM program.  Joe also blogs at MSDN, and he manages the SQL MCM prerequisite reading list.  The MCM program isn’t even his “day job” – he’s also a Senior Premier Field Engineer, which means he sees a lot of high-end SQL Server challenges.  I emailed Joe to ask him a few questions about the program.

Brent: I hear Microsoft really encourages employees to move around and grow in the company.  Out of all the opportunities available to you inside Microsoft, why did you choose to work on the Microsoft Certified Master program?

Joe: Microsoft does indeed provide plenty of opportunities to move around; however my situation is a little different because I am based in Minnesota. Since Minnesota is decidedly my home and most jobs are in Washington – I have to look for creative ways to participate in projects from afar.

How did I get involved with SQL MCM? I attended the very first SQL MCM program in 2006 (back when it used to be called the “SQL Ranger” program) – and later on I participated in the team that launched the SQL Server 2008 MCM program.  When the previous SQL MCM Program Manager Ken Tanner got a new job last year, there was an opportunity for me to help out.  I couldn’t displace my “day job” though (I’m still a full time onsite support engineer), so we decided it would be best to have a job-share situation with another original SQL MCM, David Ikeda (from Microsoft Consulting Services).  We work really well together – and we tag team seamlessly.  David will be covering the upcoming March training rotation, and I’ll be covering the May training rotation.

Although it’s quite a bit of extra work on top of my day job – I appreciate the chance to meet new people and feel connected to a community. Between 2002 and 2008 my side project time was always invested in book projects – but moving forward I’m more interested in extroverted activities like this.

Brent: Who’s a good MCM candidate?  If someone’s out there reading this right now (don’t laugh, it’s possible – my mom tells her friends about my blog) and they’re thinking, “I could never be an MCM,” who should consider throwing their hat in the ring?

Joe: Aside from the requested prerequisites (years of experience, MCITP certifications) – I look for signs of a preoccupation with SQL Server.  I could use the word “passionate” – but that word annoys me slightly.  I think someone who reads SQL Server Magazine in the bathtub, or read SQL Server MVP Deep Dives on a cruise ship has a good chance of succeeding in the program.  You’ve got to really be interested in SQL Server in order to survive this intensive process.

Experience is also paramount.  What do you do? What have you done?  I don’t pay attention to job titles at all.  Ideally an incoming SQL MCM candidate has both something to learn and something to teach. I also want to be clear that you don’t need to be a famous speaker, published author, MVP, etc in order to become an MCM.  If you are quietly doing amazing things with SQL Server – I want to see you in the program.

Brent: You must have met a lot of people doing a lot of amazing things as part of the MCM application process, then.  What kinds of SQL Server achievements raise your eyebrows these days?

Joe: I like to hear about when people design or deploy “multi-jointed” solutions (a term I just made up – but meaning that I like to see creative or interesting applications of various SQL Server features used to solve a specific business need or problem).

I’m also impressed by concrete project examples establishing your ability to get results.  For example – let’s say you have an application that is processing 2,500 transactions per second, and you were asked to double that.  Did you do it?  And if so, how did you do it?

If your solutions are simple and elegant, that’s great too.  Tell us about it when you apply for the program.

Brent: For those out there who think they don’t have quite enough experience yet, but they’re aiming for it in 2011, what would you suggest they focus on?  Are there certain areas of experience that seem to pay off well for future MCMs?

Joe: If someone were aiming for 2011, I’d recommend they start going through the pre-reading list and try to get as much hands on experience as possible on the subjects they read about.  As a SQL Server professional, this is good advice whether or not you ultimately pursue MCM.  Today we have SQL MCMs across a variety of job roles – but I would say that those who have direct experience on both the DBA and SQL Dev side seem to do very well in the program.  SQL MCM is pretty flexible in how you gained your experience – across job roles.

Then there is the Microsoft Certified Architect program – which is a different discussion altogether.  The SQL MCA cert requires that you be a practicing architect in your current role (and have been a practicing architect for a few years).  SQL MCM is a prerequisite to SQL MCA – and in that case we require other skills related to business acumen.  If you’re interested in learning more about MCA someday – I’ll loop you in with David Ikeda to discuss.

Brent: Congrats on reaching 12 non-Microsoft people in the SQL MCM list!  I always used to say that more people have walked on the moon than achieved the SQL MCM, but now it’s a tie.  I gotta ask, though – what’s the pass rate for non-Microsoft employees?

Joe: Thanks – and I really want these numbers to keep increasing at an accelerated rate.  I want to expand our non-Microsoft MCM numbers, because that’s the point, right? If your business depends on a complex implementation of SQL Server – we want to make sure you have someone you can trust.   Part of the drive behind this certification is to provide another means of validation.  I want people to say “this person is a SQL MCM, so I know I can depend on her”.  As a support professional, I personally appreciate the value of people making good decisions in the early stages of a project and doing things correctly the first time.

As for the pass rate for non-Microsoft people – I pulled some approximate numbers – and as of today we are at a 65% pass rate for non-Microsoft people.  This number continues to get higher as people retake exams.  It is my job during these training rotations to set people up for success (without lowering the bar though).  People are accepted into this program who have the potential to pass – otherwise it just wouldn’t be a good thing.  Some rotations have a low initial pass rate, but after a few months of retakes, the pass rates increase significantly.

Brent: When people don’t pass, what do you think the biggest reasons have been?  Is it a lack of preparation, a lack of focus, a lack of experience, or something else?

Joe: Here are the common patterns I’ve witnessed and also heard about from my predecessors:

Fantastic candidates who don’t “test well”.  Most people haven’t taken a six hour hands-on qualification lab before. The good news? For these folks, retake success rates are high.

Cumulative Stress and keeping too much of an eye on “the prize”. Sometimes the stress of the experience causes unnecessary mistakes on the exams or labs.  People get so wrapped up in succeeding that they don’t focus on what is presently in front of them. If you spend your three weeks obsessed over achieving the certification, or you’re upset about failing the first exam, you’ll be missing out on the full experience and your performance will continue to suffer.

Getting stuck.  One key tip I gave in the last rotation is – if you get stuck – keep moving and re-route! Moving ahead or re-routing your efforts may be the difference between pass and fail.  I think this isn’t just an exam testing skill – but also a good life skill.

Preparation. Our second week of the training is often the most unpleasant for candidates because it really pushes them out of their comfort zones (for example – coverage of CLR, XML, ADO concepts).  The pre-reading list is very important to go through if you can.  It is a long list – but chances are you’ve read many of the items we have listed.  The pre-reading list is your friend.

Brent: People complain that the MCM is too expensive.  When I turn around and compare it to traditional MCSE boot camps that cost $5,000 for a week, the MCM doesn’t seem that expensive at all – especially when I look at the quality of instructors.  At the current discounts, it looks like an absolute bargain – it’s not much more than a one-week boot camp.  (Not really a question, just putting it out there.)

Joe: I appreciate the comment.  Right now the program fee is just enough to keep things running.  I think even if it were free, some people who make their living on billable hours would object to the “opportunity costs” of the three week timeline (and having been an independent consultant in the past – I understand).  I think if you’re in that situation, you may consider what MCM could mean to one’s billable rate after the training.  No guarantees – but I think it could only help you.

Brent: The three weeks of downtime for consultants is indeed significant.  When it comes time for renewal, when new versions of SQL Server come out, what’s the MCM upgrade process like?  How much work does an MCM have to put into upgrading their certification to, say, SQL Server 2008 R2?

Joe: We determine the upgrade path based on the nature of each new version.  For the move from SQL MCM 2005 to SQL MCM 2008, we determined that it was sufficient to give a six hour hands on upgrade lab.  Our next version of MCM will be for the next major version (after SQL Server 2008 R2).

We won’t be doing any major changes to the program until this next version after SQL Server 2008 R2 is released.  At that time, we’ll figure out the fairest upgrade path (could be one exam and one lab, or just one lab).  No matter what – the MCM will not be required to attend another rotation (unless they want to).   We do require that MCMs keep up to date though.  So our SQL 2005 MCMs must upgrade to SQL 2008 MCM before upgrading to SQL vNext MCM.  We’ll provide the MCMs with access to the current MCM course content and then when the MCM is ready, we remotely proctor the exam over web cam and a Live Meeting Session.

Brent: One of my big frustrations with Microsoft certs is that the mix of test questions feels totally off.  The vast, vast majority of SQL Server implementations don’t use Service Broker or XML, for example, yet the certification exams seem to focus an awful lot of time on those topics.  Do you feel that the MCM training is more (or less) representative of real-world SQL Server use than the other MS certs?

Joe: I do feel that the MCM training is “real world” – but we also have a responsibility to be holistic too.  Much of the content is 400-level, but depending on the subject, not always.  For example, the next rotation will be injecting some discussion of SQL Server 2008 R2 features, but since these features are so new we don’t expect people to be subject matter experts.  Our program has to be both pragmatic in our depth and comprehensive in our coverage.

Brent: Doing a version 1.0 of anything is always a learning experience.  Since launching the MCM, what feedback have you adopted from attendees to change the program?

Joe: Each training rotation evolves. We administer surveys every day (so much that we get feedback on how much we ask for feedback) and we apply our feedback to future rotations. From rotation to rotation we adjust content, drop subjects that aren’t deep enough, add subjects that are timely, and deepen existing topics when possible.  I also heard feedback about how the training days were too long – so in the latest rotation I made sure that we gave more study time and ended class on time for the majority of the instruction days.  After that – we figured out we could have stuffed more content in – so we’ll adjust again in March.  So we do listen to the feedback and will continue to keep making adjustments for every single rotation.

Brent: Interesting about the surveys – how does Microsoft gauge success of the MCM program?  What’s the end goal for Microsoft?

Joe:  The program mission is to provide top tier training and the most advanced certification available for SQL Server for the benefit of building a community of trusted experts who successfully address the most complex customer requirements.   Success for our training program is measured via the feedback that we receive from candidates – but the bigger picture of success means that we have more trusted experts “out there” doing things correctly the first time.  Successful implementation of SQL Server is good for our customers and good for Microsoft.

Brent: One of the benefits touted by the MCM program is being able to call on the MCM community for answers.  How is this different than, say, the MVP program?

Joe: The big difference – our community is smaller and relatively new. The MVP community is large and very established.  MVP grants awards annually and is not a certification.  MCM is a certification and is product version dependent (in the case of SQL MCM) and we provide upgrade paths for it. The SQL MCM community value is still growing – and it will take ongoing care and attention to make sure that we continue to cultivate it.  I hope that our community overlaps with MVP community too – as there are many MVPs that I would love to see become MCMs as well.

Brent: How do MCMs interact with each other?  Please, for the love of God, tell me it’s not an NNTP server.

Joe: We have a set of email distribution lists that MCMs are added to upon certification – and they can (and do) use it communicate with one another.  I “haunt” these DLs and make sure that most questions get answered, and when not, see if there are opportunities to forward to the SQL dev or the SQL CAT team.

We also have monthly education sessions which are a great way to connect with our product team.  Once a month (or sometimes twice) I schedule a Live Meeting session – asking a SQL Program Manager or Developer to talk about something interesting.  The MCMs can ask questions – and it is also an opportunity to give feedback directly to someone who can actually do something about it.

Brent: When I talk to MVPs about the MCM program, it seems like the universal reply is, “Microsoft needs to fix the MCITP program and make a real production DBA certification based on experience.”  The MCM is only seen as something for consultants, not real-world DBAs.  I know it’s not your program, and I know you’re bound by NDAs so tightly that Microsoft will sue you just for thinking about your answer to this question, but do you have any thoughts about it?

Joe: Let me address the feedback that MCM is not for the “real-world DBA”.  I believe that “real-world” DBAs need to know about high availability, disaster recovery, performance-tuning, storage, security, manageability, and data distribution technologies. The SQL MCM program trains, tests, and validates these areas.  Let’s say you are the Lead DBA for a Fortune 500 company and you support a SQL Server environment that would cost the company millions of dollars if something went wrong.  As that Lead DBA’s employer or manager, anything I could do to bolster that person’s skills would be worth the investment of time and money so that I could sleep at night. I’m not saying that MCM is the only factor – experience is king. But after experience, I pay attention to signs of that person’s drive.  If I saw MCM on your resume, this would be further validation of your capabilities. SQL MCM holds weight because there are no shortcuts to getting it – you’ve got to put your time in.

Brent: That’s an interesting point.  So for the DBAs out there who might be interested in applying, but they’re afraid their boss will say no, how would you help justify the program?  Is there somewhere DBAs can go to get help “selling” their bosses on paying for the MCM and giving them the time?

Joe: If I were selling this to my organization, I would first try to link the mission critical needs of my company with the necessity for ongoing training and cultivation of the company’s technical leaders.  Per my earlier example – how much would it cost the company if there was a major issue in their SQL Server environment?  Now compare that to the cost of certification and training.

I would also recommend laying out a full description of the program (in person – or whatever media is most effective in your organization) so that you can make sure they get an accurate picture of the program.  We have the MCM: Microsoft SQL Server 2008 datasheet – if your manager likes glossy marketing materials.

As for detailing benefits – we also have a few testimonials on The Master Blog which may be helpful (from SQL and other MCM programs):

Testimonial from a SQL MCM (who doesn’t work for Microsoft)

Testimonial #2 from a SQL MCM (who doesn’t work for Microsoft)

ROI from MCM: A look back 6 months later.

MCM Directory ROI from a Student Perspective

And if all else fails, don’t be afraid to send me an email and see if I can help!

I’d like to thank Joe for taking the time to answer my questions and offering to answer yours too.  In tomorrow’s post, I’ll talk about something I really like about the SQL MCM reading list, something I think is changing the way certifications work.

Continue to My Thoughts on the MCM Reading List