Categories: Certification

Stepping Stone Cert II

Comments: 3 Comments
Published on: April 20, 2010

Back on March 30, I wrote about a Stepping Stone Certification that seems to be missing between the MCM and MCITP.  I had planned on keeping regular updates about the topic on my blog and have been slacking a bit.  It is certainly time to post an update.

Since that post, the forum chatter has slowed a bit, but it has also been more focused.  Yes, we recently ran into a lull – but that is not an indication of the direction we hope to push with this effort.  Currently there are two threads at SQLServerCentral that discuss this middle ground certification.  We had been tossing the name MCJ around – that has changed.  You can find the threads here and here.  Jack Corbett has also posted a blog on the same topic, you can find his post here.  There has also been mention of it by Steve Jones in his blog here.

Recap

So what have we been up to?  We have been discussing the items listed under “Bridging the Gap” in my first article on the subject.

We have also been working on trying to spread the word and get a better feel for what the community wants and sees fit.  Several of us have taken the topic to our Users’ Groups and presented the idea.  There has been good feedback from those groups and many are on par with what we have discussed so far.  The biggest consensus is that the MCITP means little to nothing to a lot of SQL Server Professionals, and the MCM is too restrictive for many to even attempt.  Along these same lines, a SURVEY has been setup with a few questions to get a general feel for how the community thinks the certification should be handled.  We really want this survey to reach as many people as possible.  The more input, the more valid the findings would be.  Please take the survey – and pass it along to anybody else who you know.

We have also come to a decision that we need more help from the community in getting this thing rolling.  This is a volunteer type effort and would be a pretty big commitment.  It could mean quite a bit of change for the community as well.  More information on that will be forthcoming.

We also think there is a need to find a good name for the certification.  We do not believe at this juncture that the MCJ would be an appropriate name.  It should be something to designate that the certification is specific to SQL Server, but that it is not endorsed / sponsored by Microsoft (Microsoft would likely not be implementing this very soon).

Specifics

Time In Service

A general consensus on this topic was reached with the following criteria.  The candidate would sign a statement attesting to this.

The candidate attests to a minimum of 18 months hands-on experience in SQL Server. Willfully misrepresenting (lying) about this is subject to a permanent revocation of this certification.

This does NOT mean an equivalent of 18 months of 8 hr days with hands-on experience; this means 18 months of any hands-on experience. This can be as a developer, DBA, or in BI (SSAS/SSIS/SSRS).

Review Board

The review board should be a panel of 3-5 people (with a preference for an odd number).  The review board may consist of people from local chapters, at least one member of the review board must be a disinterested party (not from the local chapter).  These reviews may be done in person, via phone conference, and may or may not include an interview of the candidate.  Anybody on the review board will be required to sign an NDA as well as some confidentiality agreements.  This would be a volunteer type position.  Those we have discussed as being qualified to be on the board would be 1.  MVPs, 2. Individuals already holding the certification, 3. Recognized industry Gurus on the topic.  These review boards may also be potentially performed at User Conferences.

The review board will need to review all materials pertinent to the candidate being certified.  This includes reviewing the Time in Service, Labs, presentation reviews / scores, interview, and exam scores.

Renewal

There are three facets to renewal.  The first facet is a need for continuing education credits.  The idea here is that the candidate will continue to contribute in the community, provide evidence of the contributions or retake exams to maintain certification.  The second facet is that the candidate will have a review after a period of time (not yet determined as to the interval of the renewal requirement) by the review board.  The third facet is closely tied to the first two facets – a review is required for any elective exams taken after the initial certification.  These exams may be counted as continuing education credits.

Focus Areas for Exams

There is a need to test candidates in specific areas of SQL Server.  However, a candidate need not take all of these exams.  There should be a set of core exams and then some electives.  The electives allow you to add an emphasis to your certification much the same as many Bachelors Degree programs (i.e. MCJ with an Emphasis in DR/HA).

TSQL

  • Basic ANSI SQL
  • T-SQL Enhancements (from 2005/2008)
  • High performing T-SQL – Covering improvements that avoid RBAR type solutions and write code that performs extremely well.

HA / DR

  • Clustering
  • Mirroring
  • Log-Shipping
  • Backup / Restore
  • Replication

Administration

  • DMV
  • T-SQL
  • Backup / Restore
  • Indexing
  • Performance Tuning
  • Execution Plans
  • Corruption
  • Notification Services
  • Troubleshooting?
  • Event Notifications
  • Query Notifications

BI

  • SSIS
  • SSRS
  • SSAS Administration
  • SSAS Development

SSBS – SQL Server Service Broker

  • Not sure where to place this one.  I can see it fitting in a few spots.

Development

  • CLR
  • PowerShell
  • TSQL

It has also been noted that we need to develop a curriculum with specific study materials and resources.

Conclusion

There are more areas to add.  We need more input on what needs to be added.  These are the groupings and notes I have to date.  I am sure I have missed something – however, this is a good amount of information.  So far, we have had some really good discussions.  We have many more good discussions to come.  I hope that this process takes on a high adoption rate and is accepted by the community.

Edit:  added Event Notifications and Query Notifications (left Notification Services though it is not in 2008)

Stepping Stone Cert

Comments: 7 Comments
Published on: March 30, 2010

A few of us have been deliberating and discussing the need for a bridge certification between the MCITP and MCM certifications from Microsoft.  This discussion was brought about due to an editorial by Steve Jones at SQLServerCentral.  As the discussion has progressed I believe there are some good ideas coming about from the discussions on how to create such a bridge.  I want to share some of that info here as well as some background on the topic.

Why is there a need?

Microsoft has two levels of certification that are of interest to many Database Professionals.  The first is the MCITP and the second is the MCM.  The MCITP is a series of exams taken from computer that are designed to test general skills related to one of the database roles and the exam topic in particular.  This certification is relatively accessible and has minimal relative cost (you pay for each exam and study materials).

The MCM is a higher achievement with considerably more cost.  The MCM is conducted via a “boot-camp” training session on the Microsoft campus for three weeks straight.  The cost is $18,500 for the three weeks alone.  Beyond those costs are all associated travel fees (lodging, food, transportation).  To be accepted into the program there is an application process and a non-refundable fee of $125.  There are exams and labs that must be passed in order to receive the certification.  There is also the time requirement of five years in the profession and be an MCITP.  Now, you do get to receive training at the hands of some MVPs such as Kimberly Tripp and Paul Randall – which could be quite an experience alone.  As you can see, this certification is designed for Senior level Database Professionals and has some high barriers to entry.

These two levels of certification create a chasm between themselves.  There is a lot of middle ground that is not covered.  Many can’t afford the MCM, and many won’t do the MCITP due to perception.  If there is something between the two that can bridge the gap, there will be change in perception from the community as well as business.  The certification in the middle needs to be able to build on the MCITP and serve as a building block for the MCM if one should desire to pursue it.  However, it should also be recognized as being able to stand on its own (which the MCITP does not) as a quality certification.

Barriers to Entry

Barriers to entry are requirements that must be met by an individual prior to being accepted.  This term is used in business and economics and denotes the difficulties a company may have when starting up in an industry.  Barriers to entry are good.  They help create competition and try to help create a perception of quality.

I believe the MCM has some high barriers for a few good reasons.  These reasons are:

  1. Prevent people from cheating the system.  Certifications have received a black eye in general due to people cheating the exams and through the use of widely available brain-dumps.
  2. Be a credible certification.  Since MS is controlling the environment of this certification, it would be difficult to cheat your way to being an MCM.  By being so difficult as well, it could garner more respect for the person having achieved it and thus instill a little more confidence in the certification system.
  3. Make the MCM prestigious.  With so much cost and so few people attaining the certification, it could become a desirable certification.
  4. In addition to those reasons for the barriers, there is the revenue that this program will generate for Microsoft as well.

Bridging the Gap

How does a company that sponsors a certification bridge a gap such as exists for Microsoft with the MCM and MCITP?  That is the dilemma that has several people talking and particularly in the discussion forum from the editorial mentioned already.  There is a foundation of ideas that are forming into a consensus on how to handle this middle ground.  This does not however mean that all of the questions have been answered.  Nor does it mean that these ideas are to be adopted by Microsoft or even PASS.  Here is a review of the foundation being proposed.

  1. MCITP Certified
  2. Lab / Project
  3. Review Board
  4. Presentation
  5. Exams
  6. Time in Service

This bridge would be akin to the Journeyman in the trades.  The idea being that the MCITP is more like an apprenticeship.  You have hopefully learned a little bit from the exams and studying performed to gain that certification.  The next step is to journey out as an apprentice and establish yourself in the industry.  Somebody signs off that you are able to perform the duties that to which you ascribe.  A journeyman can do the work without supervision and has the endorsement of his peers.  This is a formalized approval.  Does one need to be certified to be able to do the job?  NO.  This is a path for those that desire to be certified.  Will this path lend more credence to the person doing the job?  Potentially.  Since this certification is not in a bubble there will be some gaming of the system.  The amount of gaming and cheating will be considerably less.

MCITP Certified

Being certified at the base level should be a pre-requisite.  This requirement holds for the MCM and shows some level of competence and intent toward certification and the DBMS.

Lab / Project

The conducting of a hands on exercise is essential to testing the ability of the candidate.  Being able to perform a given task under pressure is what we do as professionals.  This will help to divulge the mettle of the candidate as well as demonstrate the skill set.  The administration of this exercise is one yet to be flushed out.  There needs to be a large pool of exercises for this to help prevent any brain-dumping of content or cheating of the system.

Presentation

Senior level professionals in the community need to be able to communicate effectively.  This presentation can be a topic of choosing by the candidate.  The presentation could be scored by the attendees to provide additional feedback for the Review Board.  A benefit of requiring this is to help build a Presenter pool for the various events in the community.  This also helps to provide additional material for review on how the candidate handled the task being presented and knowledge base.

Review Board

A panel of peers needs to review each and every applicant.  This will serve multiple purposes.  The primary purpose is to reduce the likelihood that somebody has gamed the system.  The board themselves should be Certified and well respected individuals in the SQL Community.  A nice example would be to have MVPs sign up for this.  A secondary benefit of this is that this review could serve as the application for the MCM.  The review will entail a review of a presentation (at minimum) the candidate has done, the lab / project, Exam Scores and potentially be an interview directly with the candidate.

Time in Service

This is the most controversial requirement for the certification.  If one is pursuing the MCM, then one must wait five years anyway.  If not then the candidate may or may not be intrigued by the need to wait for 2 years.  I feel that time in service gives more credence to the certification.  From Boy Scouts up through employment there are several time in service stipulations that one must meet in order to attain the goal.  I don’t think two years as a Database professional is a hard requirement (especially for those that have been working in the arena for several years already).  This time in service can serve as a fleshing out period.  I think there can be exceptions built in for this requirement.

Exams

This is pretty straight forward.  There are exams required for the MCITP, there need to be exams for this middle cert.  The exams need to entail greater difficulty and possibly be more specific skill-set.  This is an area for greater discussion.

Conclusion

These requirements are designed in an effort to build the community and bring a higher level of credence to the profession.  In no way should these be considered as an effort to esteem ourselves as the elite.  There are plenty of details to be discussed.  This is a worthwhile cause to champion and try to get PASS and MS on board with it.  Currently we call this certification the MCJ (JourneyMan).  I think that a renaming of the MCITP is also in order to help delineate the path from beginner to master.  MCITA would suffice for me.  Maybe the MCJ should also be more along the lines of MCITJ.  However, the MCJ works in coordination with the MCM as far as naming convention goes.

Certification

Comments: 4 Comments
Published on: March 25, 2010

There seems to be quite a flurry of talk these days about certification. There is evidence of it in the forums and editorials at SSC, as well as in several personal blogs of various SQL Professionals throughout the community. I even see it happening with the quarterly goals at my employer (yes we have quarterly goals).

I have, myself, taken several certification exams. I found them worthwhile for my personal and career growth. I haven’t taken an exam in probably ten years though. I have always found that studying by myself with the materials I could find online or via a bookstore was the best way to go. Studying in this fashion, I could drive the pace and spend as little or as much money as necessary to pass the exam. Through this practice, I have earned quite a few letters after my name from Cisco to Novell to Microsoft to Citrix to A+ and N+ (it all started with the A+ certification due to employment requirements). Each of the certs was job related and useful when working in a one man shop type of setting.

Well, it is time again to commit to getting certified. I doubt I will pursue the MCM any time soon. However, I will be pursuing the MCITP certification as soon as possible. I will probably pursue some other vendor specific certifications due to work related goals and prior personal goals I never fulfilled. As I progress, I will likely blog about my successes and experiences. However, don’t expect to find any information specific to my exams – other than general feelings upon completion.

page 1 of 1
Calendar
May 2012
M T W T F S S
« Apr    
 123456
78910111213
14151617181920
21222324252627
28293031  
Follow me on Google+

In 0 people's circles

Add to circlesi
Content
Categories

Categories

Now Reading

Now Reading

Planned books:

Current books:

  • ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running

    ChiRunning: A Revolutionary Approach to Effortless, Injury-Free Running by Danny Dreyer, Katherine Dreyer

  • Advanced Marathoning – 2nd Edition

    Advanced Marathoning – 2nd Edition by Peter Pfitzinger, Scott Douglas

  • SQL Server MVP Deep Dives

    SQL Server MVP Deep Dives by Nielsen Paul, Delaney Kalen, Machanic Adam, Tripp Kimberly, Randal Paul, Low Greg

  • A World Without Heroes (Beyonders)

    A World Without Heroes (Beyonders) by Brandon Mull

Recent books:

View full Library

SQLHelp

SQLHelp


Welcome , today is Thursday, May 17, 2012