Skip to content

Don’t Repeat Your Biml – CallBimlScript

Biml (Business Intelligence Markup Language) - CallBimlScript

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 CallBimlScript.

In addition to using CallBimlScript, there are four other main ways you can avoid repeating your Biml code:

In this post we will look at how to use CallBimlScript with Parameters.

Continue reading →

SQLSaturday #414 Oslo 2015 is live and Call for Speakers is open!

SQLSaturday #414 Oslo 2015We’ve been waiting for this since last year, and today I’m happy to announce that SQLSaturday #414 Oslo 2015 is live! This full day of free training will be held on Saturday, August 29th at Westerdals in central Oslo. New this year is that we will also offer a full day of paid Pre-Conference workshops on Friday, August 28th.

Pre-conference Call for Speakers was open until March 31st
Call for Speakers was open until May 31st

Whether you’re a first-time speaker or an expert, with a non-technical or advanced topic – we are thrilled to see your session submitted! You can submit sessions in either English or Norwegian, choose the language you’re most comfortable with so you can deliver your best presentation.

Join us and help spread the word to make this SQLSaturday a great event for everyone. If you’re on Twitter, follow @SQLSatOslo and use the hash tag #SQLSatOslo to join the conversation. SQL Server User Group Norway and the SQLSaturday team look forward to seeing you in August! :)

Speaking at SQLSaturday #369 Lisbon

Speaking at SQLSaturday #369 Lisbon, PortugalPortugal will always be special to me because they were the first to give me a chance as a brand new speaker. That’s why I’m so happy and honored that I get to come back and speak for a second time at SQLSaturday #369 Lisbon on May 16th!

I will present my Tools and Tips: From accidental to efficient Data Warehouse developer session. It’s a fast-paced walkthrough of things that make me more productive: from keyboard shortcuts, to tools and scripts, to how you can use Biml for SSIS development. There was a time when these things were completely unknown to me, and I hope that I can help other developers work even better.

Don’t forget to register for one of the two great pre-conference workshops!
Mastering Execution Plan Analysis by Paul White (@SQL_Kiwi)
Data Mining Algorithms in SQL Server, Excel, R and Azure ML by Dejan Sarka (@DejanSarka)

First Webinar for Pragmatic Works

Pragmatic WorksPragmatic Works hosts and records free webinars every Tuesday and Thursday, called Training on the T’s.

In March they will focus on Women in Tech and have some great speakers lined up: Mickey Stuewe (@SQLMickey), Hope Foley (@hope_foley), Jessica Moss (@jessicammoss), Amy Herold (@texasamy), Ginger Grant (@DesertIsleSQL), Shannon Holck (@SQLShannon), Melody Zacharias (@SQLMelody) and Wendy Pastrick (@wendy_dance).

On Thursday, March 26th I will present Table Partitioning in SQL Server: A Magic Solution for Better Performance? This is actually a presentation I created for my coworkers during one of our projects, but I hope it can be useful for others as well :)

(It’s my first webinar, wish me luck!)

SQLKonferenz 2015

SQLKonferenz - Name BadgeI spent the past couple of days in Darmstadt, Germany for Deutsche SQL Server Konferenz 2015. This was the first time I spoke at a conference (not a SQLSaturday), and it was an absolutely amazing experience. I want to thank PASS Deutschland for doing a fantastic job to make this a great event!

The one thing I would like to have changed is that I should have learned German before going to Darmstadt :) The quality of speakers, sessions and topics covered was very impressive, and there were many sessions in German that I wanted to see. But I can’t complain at all, I got to see some great sessions and have learned new things that I look forward to trying.

Continue reading →