Skip to content

Tag: Biml

Business Intelligence Markup Language

Create your own BimlExpress Keyboard Shortcuts

Are you tired of right-clicking on your Biml files to Check Biml for Errors or to Generate SSIS Packages? Did you know that you can create your own BimlExpress Keyboard Shortcuts? :)

Go to ToolsOptions:
BimlExpress Keyboard ShortcutsToolsOptions - Tools -> Options

Select EnvironmentKeyboard, then type Biml in the Show commands containing box:
BimlExpress Keyboard Shortcuts

Select a Biml command, click in the Press shortcut keys box, click the keyboard shortcut combination of your choice, and click the Assign button. In this example, I have used Ctrl+Shift+C, Ctrl+Shift+B (I chose C then B for “Check Biml”):
BimlExpress Keyboard Shortcuts - Assign Shortcut

Click OK, and that’s it! You can now use your keyboard shortcuts while having one or more Biml files selected. The shortcuts will appear in your BimlExpress menus in the toolbar and when you right-click on a file :)
BimlExpress Keyboard Shortcuts Menu

Presenting remotely for Malta Microsoft Data Platform User Group

Cathrine Wilhelmsen Presenting for Malta Microsoft Data Platform User GroupWoohoo! On Tuesday, March 28th, I will be doing a remote session for the Malta Microsoft Data Platform User Group. I will be presenting my Biml for Beginners: Speed up Your SSIS Development session, one of my favorites :)

The meeting starts with my remote session, then there’s a short break before moving on to Gossip Geek – “… your one and only source into the fabulous lives of Geek’s elite…”. I have no clue what that is, but it sounds fun, so make sure to attend if you’re in the area :D And if Business Intelligence, SSIS and Biml is not your thing, maybe Columnstore Indexes are? The meeting finishes with Slawomir Drzymala (@sdryzmala) presenting Columnstore Index – do we need another one?!.

The Malta Microsoft Data Platform User Group is brand new. It was started in January 2017, and this will be their third meeting. I’m very happy I get to help support a new local group! If you’re a speaker and want to do a remote (or on-site!) session, you can find Malta Microsoft Data Platform User Group on Meetup, Facebook and Twitter (@MMDPUG).

And of course, if you’re from Malta, make sure you join and attend the meetings! If the sessions that day aren’t super interesting, attend anyway for the networking :)

Wow, I haven’t written one of these posts for a long time! It feels great to slowly move back into the world of speaking again. Thanks for inviting me to speak, MMDPUG! I wish I could be there in person, but I’m really looking forward to presenting for you :)

Speaking at Microsoft Ignite and SQLSaturday Minnesota

Hello, cold weather! I can’t believe it’s the middle of September already. Since I last wrote here I’ve been on vacation in Colorado, organized the third SQLSaturday in Oslo, road tripped around the fjords and mountains on Norway’s west coast, and worked three days a week for my client in Stockholm. But those are stories for later blog posts, Instagram, Facebook and Snapchat :) Now we’re back to speaking season!

Microsoft Ignite

Cathrine Wilhelmsen Speaking at Microsoft Ignite 2016I’m speaking at Microsoft Ignite! Whoa! I decided to give it a try and submit a session, but I never thought I had a chance since I’m speaking about Biml, a third-part product. But whaddayaknow, they selected my session! And my hubtalk! I was shocked, now I’m just nervous :) I’ve never been to a conference this large before, so I don’t really know what to expect.

On Tuesday, September 27th, I will present Avoid repeating yourself – an introduction to Agile SSIS development. It’s a 20-minute version of my Biml for Beginners session. Since I don’t have a lot of time I will focus more on the why than the how. Exciting!

On Thursday, September 29th, I will host an Automate Data Warehouse and Business Intelligence development hubtalk. A hubtalk is more like a discussion than a presentation, and I will be drawing on a Surface Hub. (So nervous!) I will be talking about Biml and metadata-driven development, and I hope to get a good discussion going with the attendees and learn from their experiences as well.

SQLSaturday Minnesota

Cathrine Wilhelmsen Speaking at SQLSaturday Minnesota 2016Since I was already going to the US, I wanted to try to squeeze in a SQLSaturday as well. I may be slightly addicted :D I really wanted to go to Kansas City since they have a Biml track, but I just couldn’t get it to work this time. However, I managed to get good tickets to Minnesota the weekend after! I originally registered as an attendee, but offered to step in as a speaker when someone had to cancel.

So – I’m speaking at SQLSaturday Minnesota as well! :) On Saturday, October 1st, I will present my Level Up Your Biml: Best Practices and Coding Techniques session. Dave DuVarney (@daveduvarney) will present Building Metadata Driven ETL Solutions with BIML before me, so I hope it will be a great day for those interested in learning Biml.

Are you going to Microsoft Ignite or SQLSaturday Minnesota? See you there! :)

Speaking at SQLSaturday Sacramento 2016

Speaking at SQLSaturday Sacramento 2016On July 23rd I will be speaking at SQLSaturday Sacramento 2016! This will be my first time visiting California, so I’ve planned a day of sightseeing in San Francisco before heading up to Sacramento. There’s a big chance I’ll melt in the Californian summer heat and never come back, haha! But hopefully I’ll be able to finish my sessions first :D

This will be the first time I present two sessions at one SQLSaturday. My first session is Level Up Your Biml: Best Practices and Coding Techniques. Depending on your previous experience with Biml and C#, this is an intermediate or advanced session. I’ll cover things like code management, LINQ and how to create your own C# classes and methods.

If you’re new to Biml, you can get an introduction to Biml from Bill Fellows (@billinkc) who will be presenting his
What is Biml and why are SSIS developers excited about it?
session before mine. I definitely recommend attending, Bill is a great speaker :)

My second session is Tools and Tips: From Accidental to Efficient Data Warehouse Developer. This is a fun, fast-paced session with a whole bunch of tips and tricks. I don’t really go into details on anything, but I hope that new developers can pick up a thing or two. And here’s a little secret for you: I will be giving away a free software license to one lucky attendee in this session! And maybe a book or two. And definitely some Norwegian chocolate if you want to try it.

Outside of my own sessions I really want to attend Who needs SSAS when you have SQL? and finally see Meagan Longoria (@mmarie) present live.

Hope to see you at SQLSaturday Sacramento this weekend, and please come and say hi if you see me! :)