Archives

Agile Data Warehouse Design with Biml Videos

I had such a great time at SQL Saturday Indianapolis. The entire event was top notch. Everyone was friendly and almost everything ran smoothly.

As promised, I’ve uploaded two recordings which demonstrate how you can use a Biml framework to rapidly design and load a data warehouse.

Agile Data Warehouse and ETL Design with Biml […]

I'm Giving Two Biml Presentations at SQL Saturday Indianapolis!

This is just a heads up that I’ll be presenting at SQL Saturday Indianapolis on August 17th. I can’t wait since this is my first time speaking there and I’ll be giving newly revised versions of two of my favorite presentations.

Agile Data Warehouse and ETL Design with Biml

Business Intelligence Markup Language is literally […]

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 […]