Archives

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

How to Import Existing SSIS Packages into Biml With BimlExpress

I’m asked the same question almost every time I present on Biml. “How do I import my existing SSIS packages?” Well in this post, I’m going to show you how to do it with BimlExpress 2019 for free.

This post is part of a series, Short Cuts to Biml Mastery which shows you […]

Short Cuts to Biml Mastery

I’ve been giving Biml related presentations for many years and shared what I believe are the most efficient ways to learn it. It’s possible to get enough Biml knowledge to become productive in a number of weeks, assuming one has time to focus on it. However context switching, commonly referred to as multi-tasking, kills the […]

Presenting Biml Frameworks Tonight at North Texas SSUG!

If you are in the DFW area, come down to the North Texas SQL Server User Group tonight at the Microsoft building in Irving, Tx. The meet and greet starts at 6:00pm and the presentation follows at 6:30pm. I’ll be giving the following brand new, deep dive presentation.

Creating Your Own ETL Automation Framework with Biml […]

I'm Presenting Agile Data Warehouse Design with #Biml Tomorrow at SQL Saturday Houston!

This is just a quick note that I’ll be presenting an updated version of the following talk tomorrow at SQL Saturday Houston.

Agile Data Warehouse Design with Biml

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate […]

Presenting Azure Data Factory and SSIS Automation With Biml Tonight in Fort Worth!

If you are in the DFW area, come down to the Forth Worth SQL Server User Group tonight at the Frees and Nichols Headquarters. The meet and greet starts at 6:30pm and the presentation follows at 7pm. I’ll be giving an updated version of the following presentation.

Azure Data Factory and SSIS Automation With Biml

SSIS was […]

Presenting Azure Data Factory Automation with #Biml at the PASS Summit!

This is just a quick shout out for anyone attending the PASS Summit. I am giving two presentations, and couldn’t be more pumped. First, I’m giving the following Lightning Talk in 2 hours:

Three Things You Won’t Believe I Do With Biml
Room: 618-620
Time: 4:45PM – 6:00PM

You may have seen a basic Biml presentation in the […]

Presenting SSIS Performance Tuning With #Biml Tomorrow at #SQLSatOKC

Just a quick shout out that I’ll be at SQL Saturday Oklahoma City tomorrow to give an updated version of the following presentation.

SSIS Performance Tuning with BimlScript

You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll […]