Tag Archive: certification

SQL Server Certifications: What to Take and How to Prepare

Whether you’re already a database professional or would like to become one, you’ve probably thought about getting certified in SQL Server. Do you need to be certified? What certifications are available and which should you take first? How should you prepare for the exams? Kendra Little is a Microsoft Certified Master in SQL Server. She’ll explain what certifications are available, what the advantages are of becoming certified, and give practical tips for making the most of your exams.

Want to see the links from the video? Scroll on down– the links are at the bottom of the post.

SQL Server Certifications: Helpful Links

Certification Exams for Microsoft SQL Server 2008

MCTS MCITP MCM MCA
Database Administrator Exam 70-432 Exam 70-450 Exam 88-970
then
Exam 88-971
MCA Board Exam
Database Developer Exam 70-433 Exam 70-451
Business Intelligence Developer Exam 70-448 Exam 70-452 N/A N/A

Studying for SQL Server Certifications

Tools to Build Your Own SQL Server Lab

Low Cost (or Free!) Virtualization Products

Using Amazon’s EC2 as Your SQL Server Lab

Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. Read more and contact Kendra.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Brent Ozar PLF Adds Another MCM

Nope, we didn’t clone Brent. I am honored to say I’ve earned the Microsoft Certified Master SQL Server 2008 certification.

Seriously honored.

I feel awesome.

What’s the SQL Sever MCM?

“MCM” stands for “Microsoft Certified Master.”

As Microsoft describes it, “the MCM program is the highest level of technical certification; it helps recognize and validate an individual’s ability to design, implement, and troubleshoot solutions built on Microsoft software and technologies.”

As I describe it: The MCM is the biggest, baddest technical certification you can get for SQL Server. This isn’t a certification you can earn by memorization. You need to find the devil in the details and demonstrate you can send him running home screaming. Again. And Again. And again.

What Am I Most Excited About?

This isn’t the only way to show I have an enduring passion for learning, for databases, and for scaling software. There are many ways to do that!

But to me, this is a big symbol of how much I love what I do.

I’m excited to keep learning about technology– that’s not changing. As an MCM, I join a very cool, very smart community of people who are invested in learning and developing new solutions.

I’m most excited about helping others understand the MCM program and work toward their own goals. If you’d like to work toward this certification— I made it! I can help out. Unsure if this is the right thing to aim for? I know how to help you figure it out.

Learn more on our SQL MCM page.

Kendra Little

Kendra specializes in high availability and performance tuning. She is a Microsoft Certified Master in SQL Server-- the highest technical SQL Server Certification available. Kendra loves databases and software development more than long walks on the beach. Those cartoons in her blog posts? She draws 'em all. Read more and contact Kendra.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube

Changes to the Microsoft Certified Master of SQL Server Program

Microsoft just announced major changes to the Microsoft Certified Master of SQL Server program. I’m excited about the new direction of the program, although I’m a little biased – I helped with the program’s changes to reach the right audience.

The Original Microsoft Certified Master Program:

  • $18,500 entry fee for 3 weeks of training (and possibly certification)
  • MCITP: Database Developer 2008 and MCITP: Database Administrator 2008 required first
  • You had to show up onsite in Seattle for 3 weeks straight
  • Three written multiple-choice exams onsite during the training
  • One six-hour final lab

This setup had a few problems. It was tremendously expensive – both in terms of the entry fee and the 3 weeks of downtime. It was hard to schedule 3 weeks off in a row even if you had the vacation or your company was willing to eat that expense. You might not have needed all 3 weeks of training, and you might not have been able to travel around the world to get it.

Bottom line – having the training and the certification as an all-in-one package just didn’t scale, and that’s evidenced by the fact that only a handful of us outside of Microsoft were able to pull it off. I know a lot of people who are more technically qualified than I am, but they couldn’t justify the Master program. So how could we get more qualified people to be Masters?

The New Microsoft Certified Master Program:

  • MCITP: Database Developer 2008 and MCITP: Database Administrator 2008 still required
  • Certification and training is totally separate
  • Initial written multiple-choice exam – $500, and can be taken at Prometric testing centers around the world
  • 6-hour lab exam – $2,000, and can be taken at select secure Prometric testing centers around the world

The two biggest barriers to entry – a huge initial price tag and 3 weeks of lost work time in Seattle – are now gone! It’s now easier to prove that you’re a Microsoft Certified Master of SQL Server. (Note that I did not say it’s easier to be one, because it’s still very, very, very tough.)

Since the training is now separate, it’s up to you how much training you want to get, and who you want to get it from. If you’re already an expert on some subject areas, maybe you’ll only get training on the areas where you’re weak. Perhaps you’ll choose to get the training in chunks – one week’s worth this year, one week’s worth the next year, and then make a run at the exam. I would advise trying not to pass the lab exam cold, because this is most definitely not the MCITP.

To help you get up to speed, Microsoft partnered with SQLskills to provide dozens of hours of video training online completely free. Bob Beauchamin, Kimberly Tripp, Paul Randal, and I recorded some of our best presentations on internals, CLR, storage, performance tuning, and more. You can watch our free Microsoft Certified Master online courses all in the comfort of your cubicle. (That link may not be live yet – check again later in the day.)

If you want more personal, interactive training, you’ll be able to get it from more places. I’d argue that you still want to get it from the most qualified, highest rated trainers around. You want to get it from people who aren’t just experts at training – you want your instructors to be hands-on consultants who live this work every single week. When we’re not training or helping the community, we’re consulting in some of the toughest environments around. Yes, of course I mean SQLskills – we’re offering a series of events around the United States in 2011 to give you Microsoft Certified Master approved training. We’re the only trainers that have been involved with the MCM program from the very first rotation, and we’re the best people to help you achieve the highest level of technical certification on SQL Server. You can check out our upcoming SQLskills Immersion Events here.

I really passionately believe in where the MCM program is going. There’s going to be more people recognized as Masters, and that’s a good thing, because there’s a lot of really qualified people out there. I’m not worried about the MCM becoming the next MCITP – a certification seen as having too low of value due to the braindump factor – because I was a contributor to the new MCM program. It’s a seriously high bar to pass, but I believe a lot of you can do it.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

More Posts - Website

Follow Me:
TwitterFacebookLinkedInGoogle PlusYouTube