Speaking at SQLSaturday Oslo 2018

SQLSaturday Oslo 2018In exactly one month from now, on September 1st, I will be speaking at SQLSaturday Oslo 2018! This year is a small milestone for us, as it is our fifth SQLSaturday in Oslo. Woohoo!

SQLSaturday Oslo 2018 Schedule

I will be presenting… Actually, hang on! I will get back to that in a bit. Scroll down for some rambling about my session :) But first, the important stuff:

There are 30 sessions by 27 speakers from 11 countries scheduled this year.

Of the 27 speakers, there are 7 women, and 4 of the women are Norwegian! These are amazing numbers for an event like this. I am SO proud and SO happy :D Thank you to the organizers for encouraging and supporting women in tech, and a huge thank you to these amazing women for being great role models: Dagrun Haugland, Gabi Münster, Ida Bergum, Kathi Kellenberger, Sara Jønvik, and Steph Locke.

There are also 3 Norwegian men speaking! Very happy to see Helge Rege Gårdsvoll, Martin Keseler Barland, and Antonio Abalos Castillo back at SQLSaturday Oslo. That makes it a total of 7 Norwegian speakers this year. Woohoo!

Finally, there are 4 precons scheduled: You can learn about Azure SQL Data Warehouse from Simon Whiteley and Terry McCann, SQL Server Tools for Query Tuning from Grant Fritchey, PowerShell and SQL Server from Rob Sewell and Drew Furguiele, or R for Everyone from Steph Locke.

You definitely don’t want to miss this event. Register now! And follow @SQLSatOslo and #SQLSatOslo on Twitter to join the conversation. Hope to see you in September! :)

From SQLSaturday Oslo 2014 to SQLSaturday Oslo 2018

Ok, now that we have the important parts out of the way, let’s return to my session. Did you know that the very first technical session I ever presented was at the first SQLSaturday Oslo in 2014? I presented a session called Generate SSIS packages automatically with Biml and BimlScript. This year, I will be presenting my updated Biml for Beginners: Script and Automate SSIS Development session.

Same topic, same basic concept and ideas, some similar visualizations, but a very different session. And I mean in more ways than going from 4:3 to 16:9:

I have changed

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 1 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 1
My hair is much longer and my URL is much shorter. I’ve become a BimlHero and Data Platform MVP, and I’ve co-authored two Biml books. And it all started with this one Biml session back in 2014! Crazy :)

But I still like cats

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 2 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 2
I’m still very much a cat person. I mean… Cathrine. It was meant to be.

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 3 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 3
Like, I really like cats. Cute cats, funny cats, silly cats. I like all cats.

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 4 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 4
Apparently, I especially like this cat. I have a new favorite font, though.

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 5 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 5
Did I mention cats? Because I like cats. There’s a cat for every occasion :)

Constantly improving visualizations

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 6
The graphics have been updated over the years, and some visualizations have been simplified. Did you know that I have created all the new graphics myself? I’ve spent way too many hours having fun with SVGs!

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 7 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 7
Not only have the visualizations been simplified, but there have been many changes to the Biml software over the years. When I first presented, you had to use BIDS Helper from Codeplex. Now, BIDS Helper has been renamed to BI Developer extensions, and the project has been moved to Github. And! You don’t even use that add-in for Biml anymore. It’s all about BimlExpress these days.

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 8 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 8
I have presented this session many times and received many questions, but I’m always trying to improve the slide deck. One improvement has been to explain and visualize concepts in a simple way. I’m not entirely sure it’s perfect yet, but it’s better now than it was!

The software has also changed

SQLSaturday Oslo 2014 - Cathrine Wilhelmsen - Slide 9 SQLSaturday Oslo 2018 - Cathrine Wilhelmsen - Slide 9
And finally… Oh boy. Do you remember the good old days when you had to use a separate file in your project to save the compiled Biml to a file on disk so you could open it and see the flat Biml output so you could debug your code? No? You’re lucky :) Let’s just say that things are much, much, much better in 2018!

Thanks for taking a trip down memory lane with me. Hope to see you in September! :)

Who is Cathrine Wilhelmsen?

Cathrine is a Microsoft Data Platform MVP, BimlHero, Microsoft Certified Solutions Expert, author, speaker, blogger and chronic volunteer who loves teaching and sharing knowledge. She works as a consultant, architect and developer, focusing on Data Warehouse and Business Intelligence projects. She loves sci-fi, chocolate, coffee, craft beers, ciders, cat gifs and smilies :)

Comments

Hi! This is Cathrine. Thank you so much for visiting my blog. I'd love to hear your thoughts, but please keep in mind that I'm not technical support for any products mentioned in this post :) Off-topic questions, comments and discussions may be moderated. Thanks!

Click to Show / Hide Comments