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

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

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

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

Presenting on Biml 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.

Biml Baby Steps – Automation for Everyone

Biml […]