Archives

Import Biml Metadata from Excel Advanced

This is the final post of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so. Our mission for this series was to quickly create many Flat File extracts from provided source queries using SQL Server Integration Services. […]

My Wife and I are Presenting at SQL Saturday Austin on July 13th!

*** Quick Update. I’ve been asked also present “SSIS Performance Tuning with BimlScript” this Saturday as well. Abstract is below.

One again, my my lovely wife Melissa and I will be giving Biml presentations.

She and I will be co-presenting the following:

The True Story of Learning Biml

How do you learn Biml […]

Import Biml Metadata Directly from Excel

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so.

It might surprise some of you that I use Excel extensively for Biml metadata. After all, I’ve ranted about the misuse of Excel in […]

BimlScript Code Nuggets and Mad Libs

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so.

Mad Libs?

Per Wikipedia, “Mad Libs is a phrasal template word game where one player prompts others for a list of […]

Generating Biml Scripts Using T-SQL

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so. In the previous article, I showed you how to use Excel generate Biml. In this article, we’ll generate the entire Biml Script for an […]

Generating Biml Scripts Using Excel

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so. In the previous article, I showed you how to simplify Biml code that was imported using BimlExpress or BimlStudio. All of the code […]

My Wife and I are Presenting at SQL Saturday Dallas on June 1st!

It might surprise some of you that my lovely wife Melissa is an ETL developer as well, and she’ll be giving her first presentation at SQL Saturday Dallas.

My Better Half

She will be giving the following presentation, while I act as her lovely assistant.

The True Story of Learning Biml

How do you […]

Simplifying Imported Biml

This post is part of a series, Short Cuts to Biml Mastery which shows you how to learn BimlScript through a series of short cuts and remain productive while doing so. In the previous article, I covered how to import existing packages into Biml using BimlExpress. In this article, we’ll examine that Biml and simplify […]

Loving What You Do

Ever heard the following quote?

Choose a job you love, and you will never have to work a day in your life.

I can’t credit that because nobody knows who coined it. I always thought it was pie in the sky thinking, and tended to lean towards a work to live philosophy.

Don’t get me […]