In April 2015 I set a goal to become a Certified Expert in Biml. On February 1st 2016, I became the second BimlHero in the world – the first female and the first in Europe :)
It has been a long journey, and I have loved every part of it! Varigence announced the certification program in March 2015, and in April I decided to go for it. I was accepted into the program, and in June I attended 8 hours of advanced training. I spent the next six months working on my Biml solution. I was unable to work full-time on it due to other tasks and responsibilities at work, so I spent quite a lot of time on it at home as well. In November I completed the BimlHero Certified Expert Test, and in December I submitted my Biml solution and my case study of how I implemented the solution at work. In January Varigence reviewed my test, solution and case study, and in February I had the final code review with Scott Currie. It was very nerve-wracking having the creator of Biml go through my code! :) But I received lots of useful feedback and finally a congratulations on passing and becoming a BimlHero.
This is an achievement I’m truly proud of. I worked hard for many months and spent a lot of evenings and weekends learning and experimenting…
… well, ok, I wasn’t always 100% focused on my Biml solution when I worked during weekends :) …
…and now I’m really looking forward to continue sharing my knowledge and helping more Biml users. I’m very thankful and honored I got to speak at so many events in 2015, and I’m already looking forward to some great events in 2016 – including my first full-day Biml workshop with Scott Currie! I will also continue to blog about Biml, and let me tell you… Varigence has some super exciting stuff going on that I can’t wait to dig into and share with you guys :)
Do you work on projects in Visual Studio? Are you looking for a free and simple way to source control your projects without sharing them with the whole world? Would you like to be able to manage your projects online and still be able to work on your projects offline? If so, you may want to look into using Visual Studio and Git.
As a speaker and blogger, I create projects for demos, videos and screenshots. When I only had a few projects it worked quite well to “source control” my projects: I kept them in a OneDrive folder, created copies of demo code for new presentations and maintained versions manually.
However, the projects grew in number and size and became more difficult to maintain. There were no easy ways to track how I changed and improved my code over time, and I couldn’t revert to previous code. I kept telling everyone else to use source control, so I decided it was finally time to source control my personal projects.
In this post I will show you how I added my first project to source control with Visual Studio and Git.
Continue reading →
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! :)