PASS Professional Development Virtual User Group: Certification Exams Inside Out

Thanks for the 90+ who joined today's PASS Professional Development Virtual Group webinar on Certification Exams Inside Out: How to Think Like a Certification Exam! This was a lot of fun. Thanks everyone for joining us! And great questions!

If you have any further questions on cert exams that we didn't get to during the webinar, reach out on Twitter or LinkedIn. And if you've become unemployed because of covid-19 and my wife Christine Assaf or I can help, let's talk. We're all in to help. Hit us up on LinkedIn.

Here's a link to the slide deck: https://github.com/williamadba/Public-Presentations/tree/master/PASS%20Professional%20Development%20VUG

Sorry about all the technical foibles that our Paresh and I encountered! We weren't able to record it for some reason. Here's a recording of a past presentation of this talk if you want to share with folks who didn't see it live: https://www.pass.org/marathon/2019/careerdev/Sessions/Details.aspx?sid=98558

Stay safe, stay home, wash your hands. Here's some further Q&A:

Q: Does it still make sense to get one of the "old" certifications (MCSA, MCSE) as long as they're offered by Microsoft? 

A: Sure. Exams are always changing generationally and expiring. If being a SQL DBA is still a big part of your career, those older exams do not expire until January 31, 2021 and they will continue to show on your public transcript until January 2023, and the certifications still count towards partner competency attainment through January 2022, I believe. I wouldn't dedicate a lot of time and treasure in achieving them, but if you think you're close, go right ahead. Eventually you will be able to and you'll want to get the newer certifications, as always. Learning new skills in your trade has always been part of the game.

Q: How does the new Azure Database Administrator Associate certification compare to the previous MCSA and MCSE certifications?

A: This is probably a question better answered by others. Aside from further emphasis on newer and especially Azure-hosted technology, I couldn't speak to question format or selection other than what is publicly available anyway. In general, the exams have for a decade been trending towards broader sets of experience (again, an emphasis on delivering solutions as opposed to mastering features).

Q: Tell me more about beta exams.

A: Not free any more, but check the Microsoft Learning community blog for opportunities like this, where you can take a beta exam for 80% off if you're early to it. And while beta exams aren't scored immediately, if you pass the beta exam, you do get credit for passing the exam.

Q: Can you spread crunchy peanut butter with a fork?

A: Yes. That's just science.

@william_a_dba Fantastic session on demystifying certifications. Excellent description on how questions are constructed and methods of deconstruction. #PASSprofdev #certification

— timothy carpenter (@DasCarp) April 3, 2020

Great learning session from @william_a_dba on Cert Exams Inside Out

— Richard Lewis (@gogorichie) April 3, 2020

A very interesting webinar session "Certification Exams Inside Out" by William Assaf @william_a_dba, who went through the process of designing Microsoft certification exams. One part impressed me a lot is that SQL server knowledge is still practically important in Azure databases pic.twitter.com/JZkkGDByen

— John fan Zhang, CFA (@JohnfanZhang) April 4, 2020

Thanks for this fantastic and funny webinar on certifications @william_a_dba! pic.twitter.com/pmXAmxkdwe

— k-m.p (@sql_kmp) April 3, 2020

The Business Case for SQL Server 2019

Thanks for joining us for the The Business Case for SQL Server 2019 webinar via Spark/Ed today, an overview of new features in and around SQL Server 2019's release but also including new features to be aware of in Azure, recent SQL licensing changes, and more.

The presentation deck can be downloaded here in PDF form.

Link to the Sparkhound SQL toolbox on Github:
https://github.com/sparkhoundsql/sql-server-toolbox

More about the Unlimited Virtualization with SA in Azure on Dedicated Hosts:
https://azure.microsoft.com/en-us/blog/azure-dedicated-host-new-capabilities-and-benefits/

Contact me for an opportunity to get involved in an early adopters preview program for Azure SQL Database Edge: https://docs.microsoft.com/en-us/azure/sql-database-edge/overview

"What did it take to become a MVP?"

@william_a_dba what did it take to become a MVP?

— kennyb7322 (@kennyb7322) March 3, 2020

This tweet made me pause. I'll explain.

Backstory (skip if you're not interested):

On Sunday March 1, I got an email awarding my Microsoft Data Platform MVP status for 2020-2021. The first person I told was my wife and some close friends we were hanging out with. The first person I thanked was Melody Zacharias, my good friend, co-author, and the MVP who nominated me in 2019.

Fast forward past the coronavirus pushing the MVP Summit to virtual-only, past my supportive wife being my supportive wife and supportive Randolph being supportive Randolph. @KennyB7322 replied with the above question, and I was stopped in my tracks. I didn't know how to reply because to be frank, I had thought MVP was something that was out of reach for me.

Years ago I'd made my peace with not being able to attain MVP status, despite being nominated several times over the years via the various processes that existed at the time. I had periodically provided my MVP-qualified activities list in all via the various ways that one self-applied over the past decade. I even got an unexpected MVP email rejection while I was leaving Seattle after PASS Summit 2018, an ill-timed punch in the gut after what was otherwise a really active and positive week of community interaction.

I'd made peace with my level of activity and involvement and location and travel not being enough, and I'd moved on. I still organized SQLSaturday Baton Rouge, helped run the SQL User Group, raised up and megaphoned the tech community how I could, spoke to other SQLSat events regionally and user groups groups when I traveled, though I never invested heavily in travel. I volunteered for local STEM initiatives and nonprofits and folded them into the overlapping audience that attended SQLSaturday Baton Rouge. I enjoyed being a regional mentor for PASS and sharing at PASS organizer meetings at Summit for the past 3 years. I was very fortunate to be on the international author team of a couple Microsoft Press books, a circle for which I have my old friend Patrick Leblanc to thank for roping me into initially. I'm not suggesting these are common everyperson activities, I'm only suggesting that I was doing them despite having long since acquiesced not having MVP recognition. When Melody nominated me last year, I begrudgingly updated my activity via the new MVP status site, and months later, I got the email.

What did it take?

When reviewing the last decade of my career, and all my active and passive efforts towards MVP, I replied as honestly as I could.

Woof. I'm not sure I can answer this, Kenny.
To be honest, I've been doing my thing with PASS/SQLSaturday and in local STEM and in consulting for a decade. Those are intrinsically good activities for you and your local community, that's all I can really encourage anyone to do. https://t.co/OM3WLODui0

— William Assaf (@william_a_dba) March 3, 2020

I feel this answer was a bit of an easy escape for me, but I didn't have a better answer.

I talked it over with other MVPs and Melody Zacharias was most clear and concise to what I was trying to capture with this blog post:

"The biggest issue people have is trying to guess what Microsoft is looking for and in that forgetting to be themselves. MVP is not something you try to attain, that it is something the community and Microsoft use to recognize your commitment and contributions to community."

So without knowing or having any specific guidance on becoming an MVP, here are a few pieces of advice:

1. Understand that I don't know - I'm not sure if any MVPs do - what exactly was the special sauce that got them awarded or renewed, other than the accumulation of individual activities that enhance the community in a positive way. Microsoft has a qualitative process they discuss here and here, and they are - from what I gather - pretty dialed into the community. For the Data Platform MVP process, they are clearly dialed into PASS, among other circles. If you have questions about this process, a Community Program Manager (CPM) from Microsoft will explain this better than I, their contacts are listed here.

2. How many DISTINCT talks are you giving at user groups and SQLSaturdays and other tech conferences? In a conference call Q&A that Microsoft hosted for nominated MVP candidates in December 2019, one bit of feedback that caught my attention was that they didn't want to see the same presentation over and over again in your activity list. (They specifically gave an example of an MVP with a rotation of 7 different talks in the field.) I've had mainstay presentations on DMVs and also Security for a decade that I've presented dozens of times... so it was initially scary to hear that. But upon review, I have mixed in other topics, including current events topics like "What's New in SQL 20nn?" and non-technical topics, and also different educational settings. For example recently my wife and I have started jointly presenting a session on Ethics in Modern Data, which has been a great experience itself.  

3. What can you do to uplift others in the tech community? I was encouraged by other MVPs after I was nominated to provide much more on my MVP activity list than just PASS events, including: volunteering and organizing events and groups, nontechnical blog posts about community activities, articles or other activities published or picked up by other websites, collaborations with other technical and STEM groups and events, hackathons, volunteering, mentorship. (Note that paid stuff you do via your job is probably not supposed to be part of your MVP activity list.) I did not go so far as to add each of my blog posts to the activities list, only the most substantial and relevant. And certainly, I have not provided a complete list of all things you could put on your activity list.

4. On that note, my wife had a great idea during her job search in the completely unrelated field of I/O Psychology, to add a chronology of speaking or other public engagements to her blog. It was a long list once she started adding training she'd led, community workshops, and events she'd facilitated for various organizations, in addition to groups and conferences. So I did the same on my blog. I don't believe this helped me because the timing doesn't work out, but it couldn't hurt your online presence. Before you are nominated for MVP, this might provide a nice historical list of your qualified activity.

I hope this blog is helpful and constructive, without over-promising. If you have anything to add, please do, and link to it the comments below. Happy to discuss.