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 →

Notepad++ Multi-Editing

Notepad++ Multi-EditingSome of my favorite time-saving features in Notepad++ are macros and column editing. But sometimes I need to insert, edit or delete just a few things in a file. With multi-editing enabled you simply hold CTRL while you click or select text. This allows you to insert, edit or delete text in multiple locations in your file at the same time.

Notepad++ Multi-Editing

This video will show you how to enable and use multi-editing. You can find step-by-step instructions with pictures below.

Continue reading →

Create SSIS Project Parameters from Biml

Project Parameters from BimlIf you are using BIDS Helper or BimlExpress to generate SSIS packages in the Project Deployment model, you have probably noticed that it is not possible to create project parameters from Biml. You can write Biml for the project and project parameters, but BIDS Helper / BimlExpress will only generate the SSIS packages for you and not the SSIS project parameters. The recommended solution is that you create the project parameters manually before you generate your SSIS packages from Biml.

(Want to know why? Read Scott Currie’s explanation in my blog post Why can’t I create SSIS Project Parameters from Biml?)

However, if you are a lazy developer like me, you probably don’t want to create and update project parameters manually. Perhaps you want to automatically create or update project parameters based on some metadata? You can do that!

Let’s take a look at a (semi-hardcoded, semi-hack) solution for creating SSIS project parameters from Biml in BIDS Helper / BimlExpress :)

Continue reading →

Get started with BimlOnline Beta

BimlOnlineBimlOnline Beta (@BimlOnline) has finally launched! I’ve been looking forward to this for months :)

There has been a large gap in functionality between BIDS Helper and Mist. BIDS Helper is free, but it’s limited and quite useless when you start writing BimlScript. Mist is an amazing IDE, but it can be difficult to justify the licensing cost if you’re just getting started with Biml.

BimlOnline Beta is a web-based IDE that fills the gap between BIDS Helper and Mist. You can create and manage Biml projects online in your browser and then build SSIS projects to your computer. It has a full-featured code editor with intellisense for Biml and BimlScript – bye bye red squiggly lines and nasty errors in Visual Studio! And the best part? It has an SSIS package importer so you can easily reverse-engineer your SSIS packages to Biml. Isn’t that awesome?

BimlOnline Beta features:

  • Code editor with full intellisense for Biml and BimlScript
  • Reverse-engineer SSIS packages to Biml with the SSIS package importer
  • Build SSIS projects to your computer, support for SQL Server 2005, 2008, 2008R2, 2012, 2014 and 2016
  • Work with multiple developers on the same project
  • Real-time updated and fully customizable documentation

BimlOnline Beta is free for a limited time only, so make sure you sign up and try it out today.

Continue reading →

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