Don’t Repeat Your Biml – C#/VB Code Files

Biml (Business Intelligence Markup Language) - C#/VB Code FilesDo you use C#/VB classes and methods in your Biml projects? One solution is to create class nuggets <#+ … #>, but they can only be used in their containing Biml file. You can move class nuggets to separate files and include those files, but a more elegant solution is to use C#/VB Code Files.

In addition to using C#/VB Code Files, there are four other main ways you can avoid repeating your Biml code:

In this post we will look at how to use C#/VB Code Files.

Continue reading →

Speaking at SQLSaturday Chicago 2016

Speaking at SQLSaturday Chicago 2016Is it March yet? I’m very happy to announce that I will be speaking at SQLSaturday Chicago 2016! A huge thank you to the organizers who selected my session :D

This will be my first trip in 2016, and I’m really looking forward to visiting a new city. It’s going to be a long trip for just a few days, but it will definitely be worth it!

On Saturday, March 5th, I will present my Biml for Beginners: Speed up your SSIS development session. It’s an introduction to Biml for those who are just starting to learn Biml. I have presented this session at a few events now, and I always find something to improve. Some content will be familiar for those who have seen my slide decks already, but I’m currently working on a few tweaks.

If you’re already familiar with Biml, I’m sure you will be happy to see that Andy Leonard (@AndyLeonard) will present his Using BIML as an SSIS Design Patterns Engine session later that day :)

I will be available the whole day 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’m slightly obsessed with the topic, and I’m happy to talk for hours if someone doesn’t stop me ;)

Take a look at the amazing schedule, register now so you don’t end up on a wait list, and join the conversation on Twitter by using the hashtag #SQLSatChi.

I hope to see you at SQLSaturday Chicago! :)

Don’t Repeat Your Biml – Include Files

Biml (Business Intelligence Markup Language) - Include FilesAre 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 Include Files.

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

In this post we will look at how to use Include Files.

Continue reading →

Goodbye 2015, hello 2016!

Happy New Year 2016! :)

Happy New Year 2016

2015 was a year of highs and lows for me. I did so many things for the first time and really pushed myself out of my comfort zone. I made new friends and grew closer to old friends. At the same time I struggled more than ever with my old enemies depression, insomnia, migraine and impostor syndrome. All in all, I guess you can call it “life” :)

Continue reading →

Biml Training Day at SQLBits XV

Biml Precon at SQLBits XV
Yay, I’m so excited to finally share these news! Join Scott Currie (@ScottCurrie) and me for a Biml Training Day at SQLBits XV in Liverpool on May 4th: Learn Biml Today: Start Using It Tomorrow.

Biml Training Day at SQLBits XV

Scott and I will guide you through everything you need to start using Biml in real projects. From installing the free Biml tools, to the basics of Biml and BimlScript, to creating a staging environment, to building a metadata framework, and finally how to organize your code, work in a team, and automate deployment. Yep, that’s a lot of content to go through in one day, but you will get all the sample code so you won’t have to start from scratch.

 

We have very different backgrounds and experiences. Scott created Biml and I work in-house with teams in different countries. We will focus on best practices and code standards, but I’m also looking forward to sharing how we’ve solved problems in different ways. We hope the day will be interesting for everyone, from those of you who are completely new to Biml to those of you who have already built a Biml solution. Bring your questions and real-life problems! And if one day isn’t enough? I’ll be there for another three days :)

Continue reading →

Page 6 of 23 « First...4 5 6 7 8 ...20 ...Last »