Skip to content

Tag: Biml

Business Intelligence Markup Language

Speaking at PASS Summit 2016

Speaking at PASS Summit 2016

The first time I submitted to PASS Summit was in 2015. My Lightning Talk was accepted, and I was so excited about getting the opportunity to speak at the largest SQL Server conference in the world! I had a fantastic time, so I decided to try again and submit for PASS Summit 2016 as well.

While on vacation in Spain with my family, I woke up to an e-mail from PASS HQ. The Call for Speakers Results! I was reading the e-mail on my phone, so it felt like I was scrolling and reading and scrolling and reading and scrolling and reading until I finally got to the actual results.

Accepted!

Accepted!?

ACCEPTED!??

I didn’t just get one of my sessions accepted. I got 2 general sessions and 1 lightning talk accepted. I nearly fainted! I had to read it several times before it sunk in. I’m going to speak at PASS Summit 2016. Not once. Not twice. But three times in one week.

…WHOA!

Wuuut!?

I have mixed feelings. I’m super excited, super happy, and extremely honored to be selected! But I also know several amazing speakers who definitely should speak at the PASS Summit who weren’t selected this year. In one way it feels like I stole a session from someone who deserves it more than me. At the same time, I literally jumped around of joy when I read my e-mail. It’s difficult. I’m happy that I was selected, I’m happy for the other speakers who were selected, I’m especially happy for my friends who are speaking at the PASS Summit for the first time, but I’m also sad to hear about all my friends who weren’t selected. But next year! I’ll cross my fingers that it’s their turn next year :)

My sessions at PASS Summit 2016

I will present three sessions at PASS Summit 2016:

Biml for Beginners: Speed Up Your SSIS Development (General Session, 75 minutes)
Advance Your Career by Becoming a Volunteer (General Session, 75 minutes)
5 Ways to Advance Your Career by Becoming a Volunteer (Lightning Talk, 10 minutes)

The Biml for Beginners session is one of my favorites, and I’m so happy I get to present it at PASS Summit! :D I’m happy I have 15 minutes extra compared to the usual 60-minute sessions at SQLSaturdays. It allows me to go a little more into detail on some of my demos, or spend more time on audience questions. This is going to be fun!

I’m also really excited about presenting a Professional Development session and a Lightning Talk version of it. Volunteering has truly changed my life. I would not be where I am today if it wasn’t for getting involved in the PASS and SQL Server community. I hope that I can pay it forward and inspire someone else to get involved – maybe an upcoming SQLSaturday organizer or speaker? :)

Every PASS Summit I’ve been to has been a new and unique experience. I can’t wait to see what PASS Summit 2016 is going to be like! I’m sure I will be freaking out about my sessions :D But I also know I will have lots of fun, and I can’t wait to see lots of friends from all over the world again. YAY!

Abstract Feedback

Several speakers have shared their abstract feedback after the results were made public. Brent Ozar has added a list of these speakers to his own feedback post. I appreciate the transparency, I learn a lot from reading other people’s feedback, and I hope that it will help the community as a whole and improve the selection process next year – so I’m jumping on the bandwagon :)

Continue reading →

Speaking at SQLSaturday Iceland 2016

Speaking at SQLSaturday Iceland 2016On 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 :)

Why can’t I create SSIS Project Parameters from Biml?

Biml (Business Intelligence Markup Language) - Why can't I create SSIS Project Parameters from Biml in BimlExpress or BIDS Helper?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 →

Get started with BimlExpress

BimlExpressSay 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 →

I’m a BimlHero Certified Expert

Cathrine Wilhelmsen is a BimlHero Certified ExpertIn 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 :)

Cathrine Wilhelmsen is a BimlHero Certified ExpertIt 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 :)