On May 12th, I will be speaking at SQLSaturday Finland 2018 :D This will be a milestone weekend. It’s the first ever SQLSaturday Finland! And that means that when this event is over, all the Nordic countries will have had a SQLSaturday. So cool.
It’s always great to see SQLSaturdays in new countries. I’ve been poking my friends in Finland for years encouraging them to organize a SQLSaturday. Both because I wanted to see a SQLSaturday in each of the Nordic countries, but also very selfishly because I wanted to go there myself ;) I have never been to Finland before, so I’m very excited I finally get to visit.
As soon as the event was announced, I registered and decided to go. Later I was honored to get selected to speak as well. After this event, I will have presented at a SQLSaturday in each of the Nordic countries. All I can say is wow. I’m so grateful for each of those opportunities.
Did you know that SQLSaturday Finland was the last event I published on my last day working for PASS? No? I don’t blame you! It’s not something I expect anyone to know or remember except me. But it was a big day for me, and that’s why this event is even more special to me personally. I got to know the amazing team of organizers while helping them get started. I’ve seen the time and effort they’ve put into it, and now the event is just around the corner. Yes, I’m definitely proud of them for everything they’ve accomplished :)
SQLSaturday Finland Schedule
I will be presenting my Biml for Beginners: Script and Automate SSIS Development session. But don’t worry! If you’ve already seen my session or don’t really care about Biml, you have over 20 other amazing sessions to pick from.
See you there?
Are you planning to attend? While we’re waiting, please join the conversation on Twitter. Follow @SQLSatFinland and use the hashtag #SQLSatFinland.
I hope to see you there. Please come and say hi if you see me! :)
At SQLBits 2018, I presented my Level Up Your Biml: Best Practices and Coding Techniques session, and the session recording is now available! :) You can also view the entire slide deck (including lots of slides I didn’t show during the session itself) on my SlideShare, and download my Biml Demos so you can dig into my code examples.
Level Up Your Biml: Best Practices and Coding Techniques Session Recording
Watch the video on the SQLBits Website:
What did I learn and how can I improve?
In a previous post about presenting webinars, I recommended that everyone should do a few things afterward: watch the recording and take notes about what you can improve, and write about it.
The same goes for session recordings. My sessions are rarely recorded, especially not with video of me (eeeeek!), so I decided to take this opportunity to learn more about how I deliver sessions in-person. By sharing my thoughts, I hope to improve my own skills and maybe even help a few others so they can pick up a few tricks and not make the same mistakes as me.
And if you’re wondering, yes, it still feels extremely awkward watching and listening to my own session recording :D
Continue reading →
From May 14-16 I will be in Wrocław attending SQLDay 2018, the 10th edition of the largest Microsoft Data Platform conference in Poland. I have never been to Poland before, so I’m very excited that I finally get the chance to attend, yay! :)
SQLDay 2018 Workshops and Sessions
SQLDay 2018 has 6 workshops and more than 50 sessions over three days. Check out the amazing line-up!
I will be presenting my Level Up Your Biml: Best Practices and Coding Techniques session, covering topics such as CallBimlScript, LINQ (Language-Integrated Queries), and C# helper classes and extension methods. I have added a couple of new things to this session since the last time I presented it, and I hope this will help fellow Bimlers become even more productive.
See you there?
Are you also planning to attend? Let me know, and come and say hi if you see me! :)
Biml objects have many built-in attributes. For example, all Tables have SchemaName and all Packages have ProtectionLevel. When your Biml solution starts to grow, you will quickly see the need for adding additional metadata that can be used in other Biml files. A common use case in Data Warehouse Staging projects is to store the source schema and source table name on your staging table objects. This allows you to use the source metadata in a higher tier Biml file that generates the SSIS packages to load the tables. To store and use this additional metadata, you can use Biml Annotations or ObjectTags.
Biml Annotations and ObjectTags are both Key/Value pairs. Annotations are String/String pairs intended for storing simple text metadata, while ObjectTags are String/Object pairs that can also store more complex metadata in .NET objects.
Continue reading →
Do you want to learn more Biml? Have you always wanted to visit Chicago? Are you free on March 16-17? Then check out this amazing, once-in-a-lifetime offer just for you! …
Ok, ok, ok, I may have gotten a little carried away :) But I am excited to announce that I will be presenting a precon at SQLSaturday Chicago 2018! The precon will be held on Friday, March 16th, and is called Level Up! From Basic Biml to Automated Data Warehouse Frameworks. I will also present a general session on Saturday, March 17th.
Continue reading →