Yay, I get to speak at a SQLSaturday… on a Friday! On April 1st at SQLSaturday Vienna, to be precise. And no, it’s not an April Fool’s joke :)
I will present my Biml for Beginners: Speed up your SSIS development session. This is one of my favorite sessions to present, and I look forward to presenting an updated version of it with a new section about BimlOnline, as well as some other new content.
The schedule looks great! I’m a little sad that Sonja Chèvre (@SonjaChevre) is speaking at the same time as me, because I really want to see her present. We met at SQLSaturday Oslo 2015, and I’m so happy to see that she is now speaking! Hopefully I’ll get to attend one of her sessions at another event :)
If you want to chat, have any Biml questions, or want me to go through some of the content from my more advanced Biml sessions – I will be available the whole day. Make sure you register now so you don’t end up on a wait list, and join the conversation on Twitter by using the hashtag #SQLSatVienna.
See you in Vienna in April!
Do you use C#/VB classes and methods in your Biml projects? One solution is to create class nuggets <#+ … #>, but they can only be used in their containing Biml file. You can move class nuggets to separate files and include those files, but a more elegant solution is to use C#/VB Code Files.
In addition to using C#/VB Code Files, there are four other main ways you can avoid repeating your Biml code:
In this post we will look at how to use C#/VB Code Files.
Continue reading →
Is it March yet? I’m very happy to announce that I will be speaking at SQLSaturday Chicago 2016! A huge thank you to the organizers who selected my session :D
This will be my first trip in 2016, and I’m really looking forward to visiting a new city. It’s going to be a long trip for just a few days, but it will definitely be worth it!
On Saturday, March 5th, I will present my Biml for Beginners: Speed up your SSIS development session. It’s an introduction to Biml for those who are just starting to learn Biml. I have presented this session at a few events now, and I always find something to improve. Some content will be familiar for those who have seen my slide decks already, but I’m currently working on a few tweaks.
If you’re already familiar with Biml, I’m sure you will be happy to see that Andy Leonard (@AndyLeonard) will present his Using BIML as an SSIS Design Patterns Engine session later that day :)
I will be available the whole day if you want to chat, have any Biml questions, or want me to go through some of the content from my more advanced Biml sessions. I’m slightly obsessed with the topic, and I’m happy to talk for hours if someone doesn’t stop me ;)
Take a look at the amazing schedule, register now so you don’t end up on a wait list, and join the conversation on Twitter by using the hashtag #SQLSatChi.
I hope to see you at SQLSaturday Chicago! :)
Are you using Biml so you won’t have to do the same tasks over and over and over again in multiple SSIS packages? If so, you probably don’t want to write the same Biml code over and over and over again either. Instead, you can move common code to separate files, centralize and reuse these files in many projects, and update code in one file to make changes to all projects. One of the ways to apply this Don’t Repeat Yourself software engineering principle in Biml is to use Include Files.
In addition to using Include Files, there are four other main ways you can avoid repeating your Biml code:
In this post we will look at how to use Include Files.
Continue reading →
Happy New Year 2016! :)
2015 was a year of highs and lows for me. I did so many things for the first time and really pushed myself out of my comfort zone. I made new friends and grew closer to old friends. At the same time I struggled more than ever with my old enemies depression, insomnia, migraine and impostor syndrome. All in all, I guess you can call it “life” :)
Continue reading →