On June 18th I will be speaking at SQLSaturday Iceland! This is my first time visiting Iceland (and not just the airport in Reykjavik), and I’m really looking forward to spending a couple of days there. I get to celebrate Iceland’s national day on June 17th, and it’s also right before the summer solstice so the days will be looooong and bright :)
I will present my Biml for Beginners: Speed up your SSIS development session. This is one of my favorite sessions to present, and I will also be around the rest of the day if you want to chat, have any questions, or if you just want me to go through some of the content from my advanced Biml sessions.
If you want more hands-on Biml experience, check out Rasmus Reinholdt’s pre-conference workshop Building tomorrows ETL architecture with BIML and MDS today. You’ll get a full day of training for a very reasonable price. Just note that the SQLSaturday Iceland pre-conference workshops are on Thursday, June 16th, because Friday is Iceland’s national day.
Also, last week I started working for Advania, an Icelandic company. I hope to meet some of my new coworkers there! :D
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 #SQLSatIceland. Hope to see you in a couple of weeks! Come and say hi when you see me :)
BIDS Helper and BimlExpress does not support creating SSIS project parameters from Biml out of the box. There are workarounds (and I have previously blogged about my solution for creating project parameters from Biml), but why is this not a standard feature in BIDS Helper or BimlExpress? Many people have asked about this, so I sat down with Biml creator Scott Currie (@ScottCurrie) to get the full story.
Why doesn’t BIDS Helper or BimlExpress emit SSIS project parameters from Biml?
Well, technically it could, but it shouldn’t. The user experience would have serious issues, leading to confusion, frequent errors, and the potential for data loss. How can that be?
Continue reading →
Say welcome to BimlExpress – the newest, shiniest and completely free Biml toy! :) I first mentioned BimlExpress at SQLSaturday Vienna and have been waiting for the official release since then. I’m very happy that I can now send you all over to Varigence’s website to download the Visual Studio Extension!
What is BimlExpress?
BimlExpress is a free Visual Studio add-in for working with Biml in your SSIS projects. It allows you to add and edit Biml files, generate SSIS packages from Biml, and the code editor is fully featured with syntax coloring, error highlighting, intellisense and a preview pane.
If you are already using BI Developer Extensions (previously known as BIDS Helper), you will see that BimlExpress works the same way and includes all the same Biml features as in BI Developer Extensions – just with a new and improved code editor. No more squiggly red lines, yay!
Which versions of Visual Studio / SSDT does BimlExpress work with?
BimlExpress 2018 (released in June 2018) works with Visual Studio 2010 – 2017.
BimlExpress 2017 (released in July 2017) works with Visual Studio 2010 – 2015.
Should I use BimlExpress or BI Developer Extensions?
Both! :) BI Developer Extensions is a fantastic, free add-in with a ton of useful features for your Business Intelligence projects. The release of BimlExpress simply means that Varigence can update the add-in and the Biml engine with new features more frequently and separately from BI Developer Extensions. When BI Developer Extensions is updated it will include the latest Biml engine. Keep using BI Developer Extensions, and install BimlExpress as well for the latest Biml features.
And all of you Biml fans agree with me that the new code editor is worth it, right? Right!? :)
Continue reading →
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 :)
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!