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:
We’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! :)
Portugal 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.
I 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.