The road to Microsoft MVP – Part 3

This entry is part 3 of 3 in the series The road to Microsoft MVP

In the previous posts, I’ve told you how I got my first MVP nomination, what i’ve learned from others about the MVP program in 2017. Next I’ve updated you on my activities in 2018, a post I originally started writing in october.
Now we’re december, and it’s time for the 3rd part of this installment!

Let me take you on a short journey

Imagine this.

Very busy year behind you.
You’ve seen a ton of “SQLebrity” people.
Kevin Kline came to your session (and didn’t leave!), you even had a great chat afterwards that HE initiated!
Steve Jones “crashed” your session, made you nervous by standing behind you during your presentation and you had to ask him to sit down.
And of course you’ve met Jen Stirrup again and had a great talk with her that almost made you late for your own session šŸ˜€
Let’s not forget Stephanie Locke who taught you a lot about diversity in tech over pizza and beer with Alex Yates, Rob Sewell and others
You’ve spoken to so many people who inspired you throughout the year.
And I mean, really inspired you. You’re so inspired that you could just as well be on fire.

Your year has been so awesome that you’ve actually stopped thinking about the MVP nominations during all of that. And then, on a saturday morning, after a tiring week you open your eyes. You’ve just slept great, birds are chirping outside and because you’re a bit lazy, you pick up your phone to check it in bed.
You’re not wearing your glasses and with your phone about 10cm from one eye, you’re looking at it. Because that’s just the way badly near-sighted people do that.
The next bit all happens in about 5 seconds.

You notice you’ve got some new mails as usual.

One of them is from Microsoft.

It’s from the MVP program.

“Must be some random notification again.” You think to yourself.

But before deleting the mail, you open it anyway. Because you’ve always been curious like that and you have time to kill on this lazy day. And who knows, maybe it’s actually a mail from a Nigerian prince!

But then you see it…

BAM! You’re awake!

You double check to see if it’s actually what you think it is.

Your heart starts racing and you just want this moment to never end.

Snap back to reality

I’m extremely happy and grateful to have been awarded Microsoft MVP in the AI category. It’s an incredible honor to be in that very small club of excellent people.
How small? Currently I’m the only one in Belgium.
And there’s 8 of us if you count all neighbouring countries (Belgium, Netherlands, Germany and France).
So out of 179 million people in those countries, only 8 got awarded in this category. That’s mindblowing.

Counting all categories, there’s 55 people who currently are awarded Microsoft MVP in Belgium.
And counting all neighbouring countries, we’re 8 MVP’s in the AI category out of a grand total of 417.
That’s really special!

However, all of this doesn’t change who I am, what I do and why i do the things that I do. It doesn’t change why people like or dislike me. It doesn’t change the fact that I value openness and helping others over other things. And it certainly doesn’t change the fact that i value the people in the community and their opinion more than any award.

Let’s not forget that there are still a LOT of people out there in the community who deserve this honor, maybe even more than me. And in the way (I think) I’ve learned how the program works, I’m sure they’ll be awarded as well in due time.

But why so quiet?

People have been wondering why I’m not screaming the news that i got awarded from the rooftops. I’ve actually had a lot of linkedin/facebook/twitter private messages and people tweet at/about me as well. All of them asking this question or making a remark about it.
The thread that below screenshot came out of was a nice example.

I’ve sent private mails and messages to the people who’ve been supportive with a nice “thank you”. But i didn’t feel the need to make a big deal out of this.
One reason is that there’s a lot of people out there who don’t like to see all the “OMG, I got awarded” messages every month, either because of various good or bad reasons.

Another reason is that, although I may be loud at times, I’m not someone who goes around and “promotes” himself.
I’ve learned to use all media to get content out there, but i still feel bad about talking too positively about myself.

What’s next?

I’ve realised several things shortly after i calmed down again.

  1. I might not be re-awarded. Since before october, I’ve been telling everyone i was scaling down on the amount of talks i’d be doing in 2019. There’s a lot of stuff coming towards me, and i just don’t have the time or the money to be on the road for almost half of the year.
  2. We’re not even in the new year and i’ve already submitted to 13 events. 10 of those are in the first half of the year. But i’ve been pickier with the locations of the events. Let’s see how many accept me as a speaker.
  3. My MVP award means I’ll have my first ever award to put on display! Where will i put it?!
  4. I’m not sure what caused me to suddenly be worthy of the MVP award. And I’m still pondering about it. Since october, i didn’t have any activities anymore. Some people have told me to just accept it as one of the strange mysteries of the program and just do what I do as people at Microsoft seemed to have liked that.

I’m starting technical blogs again as well, so you’ve got that to look forward to.

Conclusion

Since december 1st, 2018, i’m proud to call myself the first MVP in the AI category in Belgium. 

Turns out, i do have some value šŸ˜‰

I’ll just keep doing what I love doing. Helping others and ensuring they grow as tech workers, as speakers and as a person. If i get re-awarded or not, i’ll still be part of this great community, which is more important than any award.

The road to Microsoft MVP – Part 2

This entry is part 2 of 3 in the series The road to Microsoft MVP

Warning

This is a less ranty than my first “road to MVP” post.
I’m finishing this post at the end of december. And while I know there’s already a 3rd part as well, I found it important to continue with my original plan for these posts. Which is, to document my journey towards becoming an MVP, no matter how long it would be or even if it would ever happen.
I do hope you as a reader have use for these posts, either way, don’t hesitate to contact me through the comments or on twitter or even linkedin if you have any questions.

Previously on this blog

About a year ago, I made a post about my experience and feelings about getting nominated for the MVP award by quite a few people I look up to.
I ended that post stating that while it had been 1-whole-full-year-omg-so-long of being nominated but not awarded, the fact that I had gotten nominated by people I look up to and the feedback I received from people in the community meant a lot to me. Maybe even more so than an award.

Fast forward a full year

Almost a full year has passed since that post.
I didn’t pay much attention to my MVP nominations anymore and when people asked if they could nominate me, I’ve been declining their offers. I’ve been declining nominations because this year, for me, was about getting even more involved with the community and just having some relaxed fun.
Due to all my new activities, this blog didn’t receive much new content, although I have quite a few new drafts ready!

Presenting at conferences & user groups

In 2018, I kept speaking at conferences and user groups, kept meeting people and most importantly, kept having fun. I’ve met so many great people and learned a ton from them in the past year.
Only issue I had, is that working full time as a consultant AND speaking this much tends to become a bit much. So I stopped all speaking engagements in october, with SQL Saturday Holland being the last event I spoke at.

Microsoft Advanced Analytics User Group

In the Microsoft Advanced Analytics User Group I organise, We’ve held 10 meetups in 2018, with quite a bit of wraps and pizza being eaten. Come join us if you’re into Big Data, Machine Learning, IoT or any related technologies

Power BI User Group

I started a Power BI User Group because we don’t have that yet in Belgium. We had 10 awesome meetups and I got to know a lot of great people who work with Power BI in Belgium.
Come join us next time if you’re working or even thinking about working with Power BI!
Our audiences tend to be a mix of everything in between deeply technical and pure business users. That tends to mean everyone wins as we can learn from each other!

Power BI Days conference

As we did our Power BI meetups, I got feedback from people. People who couldn’t make it during the week but also from people outside of Belgium who wanted to attend some meetups. So I started a free conference in september, and people seemed to enjoy it. One day in Belgium and one day completely virtual.
We had quite a few people for a saturday, but what surprised me was that the virtual event on Sunday had a ton of people as well!
Simply amazing to see how speakers and attendees invest in their future by attending events like this in the weekend.

Next up: Power BI Days 2019-01, come join us, either in Mechelen or online! www.powerbidays.com

Rest of the year

For the rest of the year, I haven’t planned much. A couple of user group meetups, catch up on work and just spend some time with my girlfriend.

Conclusion

It’s been a very busy year, i’ve met ton of new people, I did way too much and by september I was already telling people that I’d be scaling back on speaking at conferences due to my personal life getting much busier in 2019.

Either way, It’s been worth every minute of my time and I’ve had a blast doing all of this.
I can only say that you should try to speak at as many conferences and user groups as well. If you’d like some help in any form, let me know. From coming up with an idea together, to practicing your session together, I’m here for you. Others are here for you as well, check out www.speakingmentors.com.

Towards Personal Data Science with Power BI

I just finished my session at SQLGLA, with a full room there were more people than I could’ve hoped for.
Looking at the other speakers, I’m not even sure if i would’ve attended my own session!
But a small miracle happened and I got a full room aside from 5 badly placed empty seats šŸ™‚

 

On to the session!

I submitted one of the sessions I started speaking with several years ago.

Towards Personal Data Science with Power BI

After dusting it off and getting some new demos working, I was ready to go!
That is, up until a day before the event when I read this excellent post by Leila EtaatiĀ (twitter) on how to easily use the cognitive services in Power BI.

After blatantly stealing her code (and obviously giving credit) my demo went from way too many lines to easy to grasp!
So thank you Leila! šŸ™‚

Now the session basically contains a short summary of what you need to know about Machine Learning to get started.
Once you have that basic knowledge, it’s time to go into demo’s.

I show how to build a predictive model in Azure Machine Learning using the Titanic dataset, a golden oldie.
The dataset is small enough to use in a presentation and still explain some basic principles.
Added benefit is that you can keep the demo nice and simple.

Having built a predictive model in Azure ML and having deployed it to a predictive web service, I switch to Power BI.
In Power BI

 

We import the dataset and using the AzureML package in R we use the AzureML package to connect to the webservice and score our data.
Next up is visualising thatĀ scored data in Power BI.
For this session I built a very simple report, showing the results while also showing that cool Power BI Report Page Tooltip feature.

 

 

You can even take it a notch up and evaluate your models by having the output of your predictive models next to the actual values.

Here are the goods

So you want the presentation slides and the demo materials?
I’ve put them online on dropbox.

Citizen Data Science – A rant on why it is already reality

This rant is a reaction to a LinkedIn post I was tagged in because i promote citizen data science.

There’s a lot of bullshit being sold about data science.
And for every person who thinks they’re the data science unicorn and all the rest aren’t skilled enough, there’s a company proving otherwise.

I’ve talked with a lot of people about this topic and presented on why I believe Microsoft i supporting this with their tooling.

Read on for some ranting and reasoning.

Read moreCitizen Data Science – A rant on why it is already reality

The road to Microsoft MVP – Part 1

This entry is part 1 of 3 in the series The road to Microsoft MVP

Warning

This is a post about me and my reflection on the Microsoft MVP award.
It basically is a rant.

 

Some history

Back in january of this year, out of the blue, someone in the community I’ve looked up to since entering the data world asked if it was ok if they’d nominate me for the Microsoft MVP award.

For those who don’t know, being awarded the MVP status is considered by many as one of the highest honors you can receive in the Microsoft Community.
Even more so when you know that there are only about 4000 MVPs worldwide in all Microsoft categories and even less (about 300) in the Data Platform / SQL Server category [*].
With only about 150 people outside of the US being awarded MVP for the Data Platform category, you can quickly see what an honor it is to be one of the few people outside of the US to receive this award.

Not so fast

As I said, I got asked if I wanted to be nominated back in january.
While incredibly nice, I didn’t put a lot of value on the award since I was just having fun meeting new people and learning from everyone I met.
On top of that, I didn’t think I was near worthy enough for this honor. However, just the thought of having been nominated by someone known over the entire world and generally considered a community leader was already very cool!

Long story short, I didn’t let this person know it was OK to nominate me until May and didn’t even complete the nomination until the end of July.

Nomination != Award

At the end of July I had spoken internationally at a bunch of events and had met a ton of awesome people in the community. Quite a few of these people turned out to be MVPs and during dinners before or after the events we’d talk about things ranging from beer and food to the community in general.

One person I was talking with dove into his journey towards becoming an MVP. The part of his story that stuck with me the most was how he had been very active and even respected in the community and it still took him over 5 years after his first nomination before receiving the MVP award.

I received a similar warning in January from the person who wanted to nominate me. They warned me that they could nominate me but this didn’t actually mean that much.
It’s still up to Microsoft to select you.
And that apparently is the hard part of becoming an MVP.

What now?

It quickly became apparent that while most of these people weren’t an MVP at all, they were still extremely enthusiastic about what they do and most of them had even been actively sharing their knowledge with the community for a long time already.
For me this blurred the line between what defines a non-MVP and MVP person. They both seem to do the same thing for the entire community, only one gets recognized and the other one doesn’t.
Although I’m probably missing a lot of important details when making this comparison.

So knowing that this nomination would probably not result in instant “MVP-ness” and most likely not even in the long run, I filled in the forms at the end of July. With that, I had officially accepted the nomination itself.
While I still thought that this one person I looked up to considering me worthy enough was more awesome than actually winning some award from Microsoft.
This initial consideration gave me a better feeling than the thought of perhaps, someday, winning some award.

Back to the real world

As time went by, I slowly kept filling in my community activities in the nomination form.
Near the end of 2017 the pressure started growing as I received more nominations, 6 so far.

And so far I haven’t received an award yet. Some might get discouraged by this, but again, for me getting nominated by more and more by people I look up to means more than receiving an award.
Partly because the award is meant to recognize the work you’ve done for the community and these nominations basically do the same thing in my opinion.
But also because by just being active in the community, you already receive a ton of recognition and you learn so much.

* the amount of MVPs worldwide was borrowed from Kevin Kline’s MVP blog post here.

Unresolved reference in SSDT using old SQL Server system views

Issue

if you’re developing databases in SSDT, like you should, you’re probably getting a lot of build warnings.
One of the warnings you’ll see the most often is the “unresolved reference”.
Usually you solve these by adding either the master, the msdb or some application database as a database reference.
This post is about a warning you might get when out of habit (or, if like me, you didn’t know any better yet) you’re using old system views like sys.sysprocesses. You expect it to work but it simply doesn’t…

SQL71502: Procedure has an unresolved references to object sys.sysprocesses

Even after you try add the master and msdb databases as references you’ll notice that you’ll still see “SQL71502: Procedure has an unresolved references to object sys.sysprocesses”.

 

Solution

The view sys.sysprocesses and several other system views only exist for backwards compatibility but they should still work. At least for now…
So what’s going on and how do we fix this?

As it turns out, thereĀ seem to be a couple of possibilities to fix this issue.

  1. You should be in master database context as the documentation notes.
    This means you need to prefix with the relevant database as in: master.sys.sysprocesses
  2. Rename sys.sysprocesses to dbo.sysprocesses
    Gert Drapers provided this solution on the msdn SSDT forumĀ back in 2013 and it still works (at least for SQL Server 2014 with SSDT 14.0.61021.0)
  3. You might want to rewrite your specific query to use the new and relevant tables/views. This ensures your code won’t break in the future. Especially since you’re using a view that’s included for pre-SQL Server 2000 backwards compatibility.
    Refer to this mapping of system tables to system views in the documentation to help you rewrite your query.

The 3rd solution has my personal preference, as it seems to be the cleanest. But it does mean you’ll need to take a bit more time to rewrite and test your query.

What do you do when you come across this issue?

SQL Server 2017 Machine Learning Services – Offline Installer Issue

Situation

You’re trying to install SQL Server 2017 Machine Learning Services onto an existing SQL Server 2017 installation.
You select the checkboxes for R en Python because that’s how you roll.
And off you go to the next screens!

Issue

That’s when you remember it… Your server isn’t connected to the internet!
Pretty normal, but in your enthusiasm you completely forgot that SQL Server needs to download some binaries for the R and Python components you so desperately want on your precious machine!

Luckily, the installer comes to your rescue and shows you where to download those binaries it needs.
Turns out however… This link only is for one R component and the installer won’t let you pass to the next screen!

Solution

Microsoft has a complete list of all possible components you could ever want to install while offline. From SQL Server 2016 RTM, over to SQL Server 2017 CTP 1 and up to SQL Server 2017 CU 1.

You can find the full list over at docs.microsoft.com:Ā https://docs.microsoft.com/en-us/sql/advanced-analytics/r/installing-ml-components-without-internet-access

Hopefully, next time you’re installing ML Services, this will save you some time searching for why that “Next” button won’t become active.

 

SQL Saturday 642 – Sofia

I was lucky enough to get selected as one of the speakers for SQL Saturday 642 in Sofia this year.
Let’s do a quick review of my session and some sessions I visited.

Enabling Citizen Data Science with Microsoft

As a speaker you’re lucky enough to teach people what you know and experienced but also to get feedback from people in your session.
For the people who haven’t seen or heard my session before and who can’t make any sense from the abstract, I’ll slowly be blogging my entire session over the coming weeks. The very short version is: that while data science has become somewhat of a buzz word and a lot of people suddenly want that title. As BI Developers, Analysts, etc. it often is hard to know where to start. I guide you Microsoft’s 3 month long self-paced Data Science course, which covers theory and practice. And I cover the tools you need to get started.

I included the new Azure Machine Learning Services in my slides. Mainly because it’s new and actually very useful.
And one of the things I learned from my audience is that Microsoft’s announcement of these services is actually a bit confusing for people who are getting started. They now get the impression that this is something they NEED. While incredibly useful, when starting out it’s more important to get the basics right instead of trying to perfect the entire lifecycle.


Other very popular sessions were the “Database Continuous Delivery on the Microsoft Platform” by Gavin Campbell (blog | twitter) and “PowerBI for Rookies” by Miroslav Dimitrov.

Gavin Campbell talked about the theory, practice and different parts that make up a Continuous Deployment pipeline. From dacpac’s to version control to testing, building and onto automatically releasing your database.
Basically a must see session for everyone who’s developing databases.

Miroslav Dimitrov guided his huge audience through everything anyone would need to get started with Power BI.
From getting data, to creating a report and publishing a dashboard. Beyond that he talked about some security aspects and cool features like for example QuickInsights and publishing to the web.


Apart from these sessions there of course was a lot of food and enough drinks to be had by all the speakers who gathered on friday and saturday evening.Ā  For me those tend to be the most memorable of an entire event because there’s always people at the table that I look up to.
This time I had the honor of sitting next to Dejan Sarka (blog | twitter) who’s advanced sessions at conferences and even pluralsight courses will teach something to even the smartest people (but also give them a headache because of the difficulty).

Lastly there’s the non-technical things I learn from people and speaking during dinner or the conference itself.

 

So thank you to the entire SQL Saturday Sofia team for organizing this great event and ensuring everyone had a great time.
For everyone who hasn’t attended one of these yet, start doing it! SQL Saturday’s, other conferences and user group meetings both virtual and real life are a good way to learn more and to get to know new people.

 

Microsoft Professional Program – Data Science

Last year, from oktober 2016 up to january 2017, I participated in Microsoft’s Professional Program, specifically the Data Science track.
It was only the 1st public iteration of the program but back then it already felt like a mature course.
This probably had to do with the fact that there had already been a private run of the course in the months before.
David Eldersveld (twitter | blog) was one of the participants in that original run and he gives you a high level overviewĀ on his blog.

In this post I’ll be going into a bit more detail and explain how I experienced the program.
In short, there was joy and there were tears.

Read on for the full story!

Read moreMicrosoft Professional Program – Data Science

I’m attending and presenting at… ALL THE EVENTS!

This year I’ve already presented at more events than I dreamt off at the start of the year (5).
And theĀ invites keep coming in! (5 more!)
This is going to be a long read, a punishment from me to me because I slacked off in blogging in the past months.

So apart from being bored, there’s 2 reasons why you would want to read this post.
1) Interest in, but some fear of, attending and presenting at conferences, user group and community events in general.
2) You’re me from the future and you’re wondering about that amazement and the exciting feeling the young Jan had about these first events. You’re wondering about what fears you overcame and you want to look back at how it all started.

Expect to find the following:

  • UK Power BI Summit (2017/02/17)
  • Denver SQL Server User Group (2017/03/17)
  • Battle of the Beards (2017/03/29)
  • SQL Saturday Israel (2017/04/26)
  • Belgian Information Worked User Group (2017/05/09)
  • in short: 5 more events to find me at before the end of june!

So whichever reason you have,Ā come on in and start reading!

Read moreI’m attending and presenting at… ALL THE EVENTS!

%d bloggers like this: