My Upcoming Speaking Engagements: Belgium and Iceland!

Before talking about my upcoming speaking engagements I would like to tell you a little story. And it goes like this.

How it all started

Back in 2018 I started my journey of getting more involved in the SQL and Power BI community. It actually all started with a Power BI User Group (the Dutch Data Dude Farewell Tour with Jeroen ter Heerdt (B | @jeroenterheerdt)) organized by PBIG (and me) at the Van Lanschot Kempen office in Den Bosch, on which I wrote about earlier last year. Jeroen Schalken (B | @JeroenSchalken) and me did a little introduction talk (around 15 minutes) about our implementation of Power BI at Van Lanschot Kempen. It was frightening and exciting at the same time. During the break of the evening Edgar Walther (B | @edgarwalther) of PBIG came to say it was a very interesting presentation and if we would like to extend that and come talk at the Power BI User Day in March 2019. It was right there that I (and Jeroen) made the decision to say YES. We still had to make a one hour presentation, but also had plenty of time left.

After that presentation I really got the feel of it and started looking for other opportunities to speak. Eventually this turned out in speaking at Power BI Days Belgium with a session and a workshop, followed by SQL Saturday Prague together with Jeroen, dataMinds Connect in Belgium, and even the Power Platform World Tour in Dublin!

It brought me so much more than I could have imagined.

The first thing is that I get the chance to share my knowledge with like-minded people. Next, it was not only amazing to travel to these venues with great speakers and people I look up to. There were also awesome social events during every trip. And that's where the real magic happens. You make contacts, chat a bit, have a beer (or drink of your choice) and make new friends. And at another event you meet even more people to connect with, but sometimes also catch up with the newly made friends from the previous conference. It's been an amazing experience so far.

It was amazing being part of this #PowerPlatformWT! Thanks @pbiusergroup @benrebooted @DublinPUG for the opportunity!
My slides are uploaded to the PPWT site and can also be found at my blog: https://t.co/qnuW3ALWFu https://t.co/FLVSH5rLz0

— Nicky van Vroenhoven (@NickyvV) October 31, 2019

Upcoming events

But now back to the title of this blog post: it was time again to update my Speaking page, because I already have a few very nice events in my calendar.

This year will start with SQL Saturday Belgium (#956) on March 7, where I will deliver (an updated version of) the presentation that started it all.

Next up is SQL Saturday Iceland (#937) on March 28, where I will deliver my new session A Form, a Flow and a Power BI Streaming Dataset Walk Into a Bar. This session is based on the lightning session I gave at the Dublin Power BI UG during the Power Platform World Tour in Dublin.

Next to those two SQL Saturday events there's also a UG meeting planned, but not officially released yet. So more info on that one later.

Teaser

And last but not least: I will have some very exciting news to share in the coming weeks hopefully. I'm currently finalizing everything, so I'll let you know when everything is signed, sealed and delivered :-)

@NickyvV

Speaking at SQL Saturday Prague 2019

Last weekend I had the great opportunity of speaking at my first SQL Saturday, in the beautiful city of Prague in the Czech Republic. Together with my colleague Jeroen Schalken (B | @JeroenSchalken), we travelled to Prague to deliver our session on implementing Power BI (Premium) at Van Lanschot Kempen.

I also was very active on twitter during the weekend on the hashtag #sqlsatprague, I embedded every first tweet of my daily threads in the blog.

Friday

All settled and ready to go to #sqlsatprague with Jeroen Schalken! We are going to present the Tips & Tricks from our #PowerBI Implementation at Van Lanschot Kempen tomorrow at 17.15! #pbifamily https://t.co/6g7aGMQbDg

— Nicky van Vroenhoven (@NickyvV) September 20, 2019

We started Friday morning with our travel to Eindhoven Airport. After a little delay in Eindhoven, we were just in time to drop our bags at the hotel and get ready to be picked up for the speaker's dinner. It was in restaurant Kuchyň, with a beautiful view over the city next to Prague Castle.

Having a great speaker's dinner at #sqlsatprague! With @JeroenSchalken @JiriNeoral @pinaldave @christinaleo @Neil_Hambly @SQLSwimmer @tomaz_tsql @MatijaLah @sqlpass_cz @jardaminha @SQL_Alex @DejanSarka @DamianWidera @TomasTucek @jaroreken @malekpav pic.twitter.com/7gLfFy8Rkr

— Nicky van Vroenhoven (@NickyvV) September 20, 2019

We shared some starters on the table and then could pick our own food right from the kitchen, which was very nice. We were very well taken care of by the SQL Saturday Prague team!

Saturday

I started the SQL Saturday with a short run around the convention center and through the park and after having breakfast in the hotel we headed to the conference.

Rise and shine! It's #sqlsatprague time! pic.twitter.com/TLqGgG4apQ

— Nicky van Vroenhoven (@NickyvV) September 21, 2019

During the day I attended these sessions:

• Profiling Your Data by Angela Henry (B | @SQLSwimmer)
  Angela showed how you can use Power BI or the SSIS Data Profiling task (also available in Biml) to profile your data. Oh, and you should do that before the start of your project btw.
• Power BI Row Level Security Deep Dive by Jiří Neoral (B | @JiriNeoral)
  Jiri showed RLS in Desktop, from defining your security in a (hidden) table to dynamic RLS.
• Power BI as a universal analytic tool by Michal Chmelár (B)
  Michal showed several Cognitive Services for analyzing and translating text to sentiment analysis and also how to integrate the PowerApps visual into a Power BI report.
• Designing your tabular/PowerBI model for performance and scalability by Ivan Donev (B | @ikdonev)
  Ivan showed us several best practices of creating an SSAS model after breaking down Hash, Dictionary and Run Length Encoding.

There was also time for relaxing in the speaker room and taking some fresh air outside. And then finally of course our own session at the end of the day:

Tips and Tricks of a Power BI (Premium) Implementation at a Financial Institute by Jeroen Schalken and me. Because we were the latest slot of the day quite a few people already left, but our audience was very interactive and had lots of questions, so thank you!

We also went to restaurant Na Pekařce for the SQL Saturday after party, where we were joined by the speakers, organisers and also around 40 attendees.

Sunday

We had this day to enjoy the beautiful city of Prague, together with a few other speakers and Jarda, who was our awesome guide for the day!

Sightseeing after #sqlsatprague with @pinaldave @jardaminha @christinaleo @SQLSwimmer @JeroenSchalken pic.twitter.com/6Le9LbgYJo

— Nicky van Vroenhoven (@NickyvV) September 22, 2019

Monday

Because our flight was at 9.30 AM we started this day very early with a quick breakfast and on to the metro and bus to the check-in and security at the airport. It all went very smoothly so I even had some time to work on this post. At 11 o'clock we were back again on Dutch soil. As a surprise my wife and 2 youngest kids were there to pick me up.

Dobrý den: Final preparations before going back home from #sqlsatprague. Massive thanks to all the organisers @sqlpass_cz , sponsors, attendees and other speakers! A special thanks to @jardaminha for taking such good care of us and taking us on the sightseeing tour yesterday! pic.twitter.com/cXI4awH0Ah

— Nicky van Vroenhoven (@NickyvV) September 23, 2019

Closing words

All-in all it was a wonderfull weekend and I met many new great friends from the SQL Community. I hope I can some day go back to (SQL Saturday) Prague!

I also made a short video of my adventures during the weekend, so enjoy!

My Takeaways For SQLSaturday 551: #SQLSatHolland

Finishing this post was on my list for quite some time now, but I gave my post last week about the Technical Preview for Power BI in SSRS priority because of the "hotness" of the topic. So without further ado, here's my SQLSatHolland write-up.

It's that time of year again: it was SQLSaturday in the Netherlands, a.k.a. SQLSatHolland!

It's always nice to meet up with SQLFamily, (Twitter) friends/old colleagues and new friends.

This year I also volunteered for the first time by being a timekeeper for the speakers and making sure the session evaluation forms were distributed before the sessions started and collecting them at the end of the session. It was a good and fun experience and I will try to keep giving back more to the community where I can.

I wrote down some notes of the following sessions:

If a machine can learn, why can't YOU learn Azure Machine Learning? by André Melancia (t)

This was an introduction into AML by André where he started out with some theory and explained what ML is not and the difference with AI. We learned how to create a free Azure subscription, set up a ML workspace and start using ML Studio, which is very much alike the Integration Services graphics of connecting processes through intermediate steps using arrows. He then walked us through the demo of creating our first model and experiment in ML.

Using PowerShell for SSIS by Joost van Rossum (b|t)

Joost used the first few minutes to explain what PowerShell (PS) is and goes right into the demo's after that. He even ignores the best practice of not typing in a demo, but all goes well fortunately :-) He showed us some neat Star Wars "song" of PS-beeps and also explains what you can actually use PS for: a.o. deploying IsPacs and environments, download packages from the catalog, search within multiple packages/projects and setting authorization.

Azure SQL Data Warehouse by James Rowland-Jones (t)

James starts with explaining what SQL DW is and is not. Analytics, aggregates and large data volumes are the key words when you want to use SQL DW. When NOT to use it: RBAR-processing, OLTP, incompatible formats like JSON and XML. You pay for the data you store and the compute you provision. You can choose between Hash and Round Robin (default) distribution, where you have to take into account that the distribution key is read only.

Continuous Integration and the Data Warehouse by John Tunicliff (b|t)

You can watch (a shorter version of) this session recorded at an earlier conference on YouTube. John talks about the problems why CI is still not a basic part of database development, the main point being the data in the database. TeamCity Build Server, PowerShell and psake is mentioned also for implementing CI, all with different use cases. Another key point to CI is a test framework, e.g. NUnit BI which is an open source framework to test BI solutions. A best practice when using SSDT for database design is not to upgrade projects, but to start over with a clean import and transfer over the pre- and post-deploy scripts.

Q&A BI with Joost van Rossum, Jan Pieter Posthuma (b|t) en Remko de Boer

These Q&A sessions were a try-out to see if we liked them and they could be a succes. Our BI session was mostly questions to the speakers but sometimes turned out to be a discussion between several attendees and speakers. It was really an open hour, and I really enjoyed it. Questions ranged from performance of Azure, Power BI, the new MS Certification paths (which I wrote about here) and the Master Data Services session from Remko, which was a very good session I heared from several people.

Introducing the SQL Server 2016 Query Store by Enrico van de Laar (b|t)

I didn't actually attend this session, but rumors say it was an exciting one so I have to share it with you. Let's start with some pictures, they say more…

It all started when he was about to begin with his session:

That time when Windows 10 decides to install updates automatically... pic.twitter.com/GZT5ew3Gvf

— Klaus Aschenbrenner (@Aschenbrenner) 15 oktober 2016

He even did some Windows updates that morning "to be sure". Well, that clearly didn't help…

The view for 50 minutes of my Query Store session. thankfully it still turned out good thanks to a very interactive audience! #SQLSatHolland pic.twitter.com/SLlSaPAzNV

— Enrico van de Laar (@evdlaar) 15 oktober 2016

Poor man's Query Store by @evdlaar :-) pic.twitter.com/QNGMcPGPMn

— Klaus Aschenbrenner (@Aschenbrenner) 15 oktober 2016

What I heard from a lot of people (and also from Enrico himself), is that the session still was great and he turned it into a Q&A. He even turned to the whiteboard to get the picture across! Well done for the professional approach and for thinking in solutions when this happened.

My presentation and demo's from #SQLSatHolland are online now https://t.co/lBKFD3LZBj. Now you can "see" what I talked about :-)

— Enrico van de Laar (@evdlaar) 15 oktober 2016

If you want to know more about one of the sessions listed above or are just interested in any of the other sessions of SQLSatHolland, the session materials can be found at the SQL Saturday website, although at the time of writing not all materials have been added to the site.

I hope to also see you next year at SQLSatHolland!