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