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.
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
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
Constantly improving visualizations
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!
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.
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
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! :)