Blog

A few weeks ago, Microsoft unveiled changes to the Microsoft Certified Master (MCM) of SQL Server program and showed off new free video training materials by SQLskills.  I was curious to hear what the community would think about the new certification and our training materials.

Jason Strate (Blog@StrateSQL) was the first to blog about trying to pass the MCM.  There’s two parts to the MCM test now: a written multiple-choice exam, and after passing that, a six-hour hands-on lab exam.  Jason didn’t pass the written exam the first time, and I applaud his honesty in blogging about that.  It’s valuable for readers because you need to look at Jason’s credentials before making a run at the exam yourself.  I usually recommend that senior DBAs just “Iron Man” the MCITP exams – take the exams without studying, then decide what areas of your knowledge need some improvement.  I don’t recommend that at all for the MCM exam; spend some time – or a lot of time – going through the training material first.

The easiest way to get started is by watching the free training videos we recorded.  I shamelessly copied (plagiarized?) Paul’s opening line of his videos: “(These videos) are not a replacement for the experience you’ll need, but they will show you the breadth of material you’ll need to know, and the depth to which you should know it.”  Candidates can watch all 40 hours of training videos and still not be ready for the exam.

For example, my SQLOS video is 30 minutes long.  I just can’t teach SQLOS concepts in 30 minutes – Gert Draper’s SQLOS talk consumed 4 hours when I was at the MCM – so I had to pick specific areas to cover.  Rather than trying to do justice to CPU scheduling, memory management, and SQLOS’s services, I focused just on CPU scheduling. If you watch the video, you’ll see how deep you need to go on CPU scheduling, and you’ll see the other parts of SQLOS that you need to research on your own.

Recording those free training videos proved way more challenging than I’d expected.  How much could I assume that the audience already knows?  If I only had 30 minutes to cover a particular topic, I didn’t want to waste time on something most senior DBAs already knew.  The MCITP DBA and MCITP Database Developer are prerequisites for the Microsoft Certified Master program, so I assumed anything MCITP-testable was too basic.  However, the MCM requires knowledge of things outside of the MCITP, like virtualization.  How much should I assume that the viewer already knows about virtualization?  Should I define the terms “guest” and “host” or just skip right past that?  I found myself thinking about my SQLcruise attendees.  I thought, “Would Dave Levy know this?  Would Crys Manson know it?  Is this something Yanni Robel has talked about?”

After the first round of videos went live, I gritted my teeth and braced for the feedback.

Nothing came.

The silence reminded me of what happened when we published our book.  I had expected a furious roar of people pointing at various lines in the book, yelling, “THIS IS BOGUS!  THIS IS ALL WRONG!”  Only one or two bug reports trickled in over time, and in the quiet, I wasn’t sure if people were getting any value out of the book, or if maybe, just maybe, we got everything right.  In the year since we published the book, I’ve gradually heard good things from readers, so I know it worked out well.

We slowly started getting feedback.  Andre Kamman sent me an email questioning something I’d said in the Baselining & Benchmarking video.  I’d said Page Life Expectancy can drop during backups.  I’ve seen that happen time and again during my career, and it’s why I discard memory statistics from times when backups are running.  Unfortunately for me, Andre is one smart fella (and a gentleman, one of the many great people I love seeing at SQLbits) and he also included a link to a Paul Randal blog post saying PLE isn’t affected by backups.  Uh oh!  So now I have to do some rigorous testing to prove that out – I’ve got a hunch that it’s caused by the third party backup software I use, which consumes memory during backups, and might be putting SQL Server under memory pressure.  It shouldn’t, but…

From that point on, as I recorded MCM videos, I kept rerecording the same slides trying to make sure I didn’t misstate anything.  My regular speaking style is very fast, loose, and animated.  I jump into impromptu soliloquies on a topic, thinking of new ways to explain stale topics, and this carries a huge risk with recorded videos – especially those with a big audience.  The PLE quote was a great example, because I spoke off the cuff trying to explain reasons why PLE usually drops.

Turns out that even just mentioning Page Life Expectancy and possible thresholds for it is fraught with peril.  Someone posted a completely misleading blog entry about why PLE should be exactly 300 – which is wildly incorrect – and that led Paul to imply that there’s no such thing as a threshold for PLE.  I agree that there’s no black-and-white good/bad number, but the lower PLE gets, the more turnover you’re experiencing in memory.  That doesn’t necessarily mean your server needs more memory, and in fact, buying more memory may not be the best way to improve performance.  The classic example is a query doing huge table scans because someone added an additional field to a commonly used report, and the query no longer uses just a covering index.  Adding the new field to the index (or removing the field from the report, ha ha ho ho) might improve performance more than adding memory.

At the MCM level, there’s even religious wars about which terms to use.  The term active/active clustering refers to a SQL Server cluster where multiple nodes are running active instances of SQL Server on each node – but so does the term multi-instance clustering. The term multi-instance is more technically correct, but it’s not a commonly used term – the market standardized on active/active clustering a long, long time ago.  I used the more common wording in my clustering video, but I took pains to explain why that term (as well as the term shared-nothing clustering) is misleading.  Geoff Hiten, a clustering MVP that I very highly respect, took me to task for using the misleading term.  He’s totally right in that multi-instance is better, but that wasn’t an objective I wanted to pursue in the MCM videos.

You know the drill with SQL Server answers – it depends.  As much as we try to clarify points in the videos, there’s always going to be contentious points that people will debate.  To help facilitate that, Microsoft is putting together a forum where viewers can discuss questions and MCMs can offer guidance.  In the meantime, feel free to email the presenter of each video directly with your questions.  Please email us, rather than tweeting, because the 140-character Twitter limit doesn’t do justice to questions or answers.  If you’d like to crowd-source your question before the forum goes up, feel free to post programming questions on StackOverflow and admin questions on ServerFault.  That way, you can elaborate in detail on your question, and we can get lots of brains involved.  You can then tweet a link to your question with the #SQLhelp hash tag to get the Twitterati’s attention.

Finally, I’d like to give you one more point of contact.  Joe Sack (@JosephSack) leads the SQL MCM program.  He’s put in endless hours to help craft the entire experience.  He listens patiently to feedback, takes action, and believes in doing the right thing for everybody involved.  He’s been the driving force between getting the tests right, getting the testing facilities to obey the rules, and what might even be my favorite thing of all, getting freely available MP4 versions of these videos available for download from Microsoft.  No matter what kind of device you use, there’s free SQL Server training videos available for you right now.

Happy learning, and good luck with your exams!  If you pass the written test (and even better, the lab), please let me know – I’d like to congratulate you personally and interview you.  I know the rest of my readers would love to hear your MCM story.

↑ Back to top
  1. The links to the videos all point to Jason Strate’s About page (not that one couldn’t stand to read it. :) ).

  2. So if I got it right: the correct answers for the MCM exam are always:
    “D – It depends”

  3. Pingback: SQLskills MCM Videos: Behind the Scenes

  4. Your link to the free training videos is pointing to http://www.jasonstrate.com/about/, not the free training videos.

    B

  5. Brent – I think making these videos available for free is a tremendous service to the SQL Community (both for aspiring MCMs and for those just looking for additional training). I expect them and the additional resources Paul published for each to keep me busy for a LONG time to come. Many thanks to all involved.

  6. @Brian: I completely agree with your comment. I am nowhere closer to taking the MCM, but the videos are wonderful and has given me a very detailed insight on the SQL Server internals, indexing, etc. The fact that it comes out from people who have dedicated years of their lives in SQL Server makes it very authentic. I listen to some videos at my work, and got some really good ideas. Today at work, I re-factored some of my codes and could notice blazing performance increase. Thank you sqlskills!

  7. Hi Brent,
    I have been working through these videos over the last few weeks and they are priceless.
    I have no real intention of taking the MCM – until the company starts paying for training.

    Even watching videos I thought would have not immediate use I found myself putting it on pause to make changes to my standard scripts. Your one on base lining got me adding an extra counter to my perfmon collection – and removing a couple.

    Thanks to you and the other SQLSkills team for these early XMas presents!
    Seth

  8. Thank you Brent!

  9. It’s amazing how much time it takes to make a recording (or chivvy people along to record theirs :-) and we thought long and hard about how to break down the topics to give people a good feel for the breadth of the MCM.

    Glad everyone’s liking them!

  10. Easiest way to sum up my initial experience… not only did I watch a few of them (Brent’s – SQL Sever Virtualization, Paul’s – Filestream, for example), I recommended them to others for review. That recommendation went out as soon as I finished watching the videos on Saturday night, others on Sunday afternoon (limited to other DBA’s in my group). When I got into work on Monday, we were in a situation where I could immediately apply some of the content from the virtualization video, I proceeded to recommend the videos to other groups that I interact with and my boss so that he could better understand the troubleshooting effort that we were about to set out on. Good stuff!

  11. I’ve currently watched about a quarter of the videos and they have all been really well put together. I’ve been recommending them to other team members and members of the community. Thanks for putting these together!

  12. The videos are a real asset to the community, whether the audience of a particular video is studying for an MCM or not. I watched the storage monitoring video a few hours before a workshop about that very subject and all the way through I was thinking “what could I imagine Brent saying”, used wisely they have a much wider use than just the MCM exams.

  13. Great job on the videos Brent. I’m still going through them in preparation for the exams I plan to take this summer.

    When I first saw the significant changes to the MCM program. The first thing that came to my mind was that although the program may be more flexible it will now be more difficult. Before there were 4 exams: 3 written and 1 lab take in 3 weeks. Now it is 1 written and 1 lab. It seems that they bundled all of the prior 3 written exams into 1. So instead of being able to focus on fewer areas for each of 3 exams (granted within 3 weeks) you now have to be ready in every area for 1 exam. Thats a lot of content and I expect, a more difficult exam. I would love to hear your thoughts on this?

    • Hi, Ellon! I don’t agree that you have to be ready in every area for 1 exam. Passing score isn’t 100%.

      Before, we had 3 tests, and we had to pass all 3. That meant we had to know a majority of all 3 weeks of material. One week focused on development, for example, and I had to know the majority of those topics.

      Today, you only have 1 test, and you have to know the majority of that content. I would have completely ignored some of my weak areas (like CLR and XML) if I only had to pass 1 exam, but I couldn’t afford to do that when CLR and XML were much bigger chunks of one of my 3 tests.

  14. Ok.. Fair enough. I think completely ignoring weak areas puts you in a position where you have very little room for any wrong answers in the other stronger areas though. So it probably wouldn’t be my approach but to each his own I guess and it is a very valid point and probably the path quite a few will take. Personally, I find breaking exams into smaller chunks makes things more manageable. Unfortunately (for me) it’s no longer an option.

    I was looking through the schedules for the SQLSkills courses and it seems they are spread over quite a few months. Do you know if there are any plans to have a longer more condensed course covering everything similar to the original at any point? I’m one of the unfortunate few that made plans around the old MCM program (including accruing 3 weeks of vacation time) only to find out that all the logistics changed on me and now I’m looking at multiple flights/trips and more like 4-5 weeks to get through all the classes plus exams.

  15. @Ellon – the only back-to-back set of classes we have planned is in Bellevue, WA in August. Hope to see you there!

  16. Thanks for the free videos although Paul is talking a bit quick in the one I saw ;-). Even though Microsoft changed the Certification path it is not very easy to any information about it in europe. Perhaps I am trying that in summer.

    • Alex – you’re welcome! The tests are available at select ProMetric testing centers in Europe. Check out Microsoft’s site for that. We’re going to be offering some of the MCM training in London this year too.

  17. These videos are priceless, and are giving me a new (dare I say “lazy”?) route into driving my own professional development from the MCM curriculum. I am far from being MCM material, but have a healthy interest in internals, and the videos are great for identifying my weak areas, as well as challenging or confirming already-held beliefs.

    Here’s hoping I get to attend one of your classes some day!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

css.php