Thursday, March 26, 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:

More about the Unlimited Virtualization with SA in Azure on Dedicated Hosts:

Contact me for an opportunity to get involved in an early adopters preview program for Azure SQL Database Edge:

Monday, March 09, 2020

"What did it take to become a MVP?"

This tweet made me pause. I'll explain.

(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.
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. 

Sunday, March 08, 2020

Thanks for joining us at SQLSaturday Baton Rouge 2020 Business Intelligence edition

Thanks for joining us at the first annual SQLSaturday Baton Rouge Business Intelligence yesterday, put on by the Baton Rouge Analytics and Intelligence Network (#GOBRAIN!), an official chapter of PASS. Congrats to Balaji, Thomas, John, Katie, Andy and the rest of the organizers and volunteers on a successful event.

It was great to see so many new and familiar business intelligence faces in the Speaker Room in the morning, and spending the day in the brand new Taylor Hall at LSU, which back in my day was called CEBA, and hosted the first few SQLSaturday Baton Rouge events starting in 2009.

I had the pleasure of facilitating a panel on Careers in Business Intelligence for a full room of students and jobseekers after lunch, with a fantastic panel featuring:

  • Ganesh Lohani
  • Chris Hyde
  • Sekou Tyler
  • Leslie Andrews
  • Anandi Subramanian
  • with guest appearance from Amy Herold. (lol)

Following the panel, Christine and I presented our talk on Ethics in Modern Data. This is an important topic that lives at the crossroads of both of our careers: my wife's career in organizational psychology, my career in data, and our joint passion for history and civil rights.

Eager for feedback on both sessions, please use the online feedback form if you haven't already.

Thanks again for joining us in Baton Rouge, where it was a pleasant break for me to be a simple, humble speaker and volunteer instead of a lead organizer at a SQLSat event in Baton Rouge. :) From all appearances, the veteran team handled their first event well, even with the expected problems like locked rooms, no-show sponsors, room changes, and sharing our space with an army of high schoolers thanks to mixed schedules from our host facility. I didn't see any problems or hear any complaints, and despite being very busy, the volunteer team did well!

Monday, March 02, 2020

SQLSaturday Baton Rouge 2020 Business Intelligence edition this Saturday!

The first of a double whammy of SQLSaturday Baton Rouge events over the next 5 months, SQLSatBatonRougeBI is this Saturday, March 7! The organizers of this event, from the Baton Rouge Analytics and Intelligence Network, have assembled a dynamite speaker schedule of business intelligence voices from around the country.

Christine and I will be speaking at 3pm on Ethics in Data. This is an important topic that lives at the crossroads of both of our careers: my wife's career in organizational psychology, my career in data, and our joint passion for history and civil rights. The effort of researching, paring down, and rehearsing our presentation together as a couple has been an exciting new challenge for us.

It's important to understand that when dealing with bias, outcomes matter, intentions don't. In this presentation we review historical bias, sources of bias, transparency in bias, patterns and anti-patterns, and disparate impact. We have loads of real-world examples and case studies pulled from journals and headlines alike. This has been a fairly interactive presentation in the past and we look forward to bringing this topic to the audience in our hometown.

I'll also be facilitating a Careers in Business Intelligence panel in the same room at 1:45pm, with a selection of speakers from the conference sharing their career progression and wisdom and experience. All students, educators, and job seekers are encouraged to join.

See you there!