Archives

Biml - Because I'm a Cheater

I’ll admit it, I’m a cheater. Now, before you click away in disgust, give me a minute to explain. Almost 15 years ago, when I felt stuck in my career as “The Made2Manage Guy,” I’d routinely run out of things to do. I mean, once you’ve learned all the pitfalls and gained a mastery of […]

HELLO to the WORLD of Biml

A “Hello World” program is an ages old traditional way to teach the basics of syntax for a programming language to a beginner. Since so many of us are just starting to use Biml Script, I thought it would be fun to start out with it. Also, I’ve made the entire solution available for download.

Before […]

Data Warehouse Initial (Historical) Dimension Loading With T-SQL Merge

If T-SQL Merge can only handle one changed record at a time, how can we use it for our initial/historical load? Further, how can we use Merge in those situations where the incremental load may produce more than 1 changed record per entity? Well, I’m glad you asked.

Welcome to the next article in the […]

SQL Saturday Oklahoma City Wrap Up

This past weekend I made the trek to Oklahoma City to participate in their latest SQL Saturday. It was the first time I had spoken there, but it didn’t feel that way. Kristin Ferrier (Blog/Twitter), Jeremy Marx (Blog/Twitter), Matt Brimer (Twitter), Allen Smith (Blog/Twitter), and the rest of the team were so welcoming, just what […]

Extracting Historical Dimension Records using T-SQL

Just because you can extract every single historical record for a dimension doesn’t mean you should. In this article, we’ll cover three basic extraction “methods” and when each of them may be preferred.

As with many of my Urge to Merge Series articles, this one will be presented in layers. In this case, each layer is […]

Loading Dimensions Historically

There isn’t a lot of information on the inter webs about designing the historical load of a Data Warehouse. Consequently I see a lot of confusion on the subject. Before we go farther down the Urge to Merge Series, I thought it would be beneficial to define the concept with some visual examples.

The Initial/Historical […]

Upcoming Presentations - NTSSUG and SQL Saturday OKC

Tonight at the North Texas SQL Server User Group

This is just a quick reminder that I’m presenting another hour in my continuing series Data Warehousing for the North Texas SQL Server User Group. We’ve already covered Dimension Tables in depth, so tonight I’ll be presenting, “Fact Tables – Show Me The Money!” I’ll explain the […]

Stop Clowning Around and use Biml

Sorry for my terrible photography.

Clowning Around

Friday, I took my girlfriend to see The Greatest Show On Earth. We love the animal acts, stunts, and the over-the-top atmosphere. However, I am always torn when watching these kinds of performers. On one hand, as anyone who’s seen me present can attest, I love performing. There’s […]

Why I Choose BIML Scripting

Welcome to a new series of articles, about Biml and Biml Scripting. Most of these will be fairly short personal essays about why I am investing my time in Biml Scripting. I’m hoping these will resonate with you and encourage you to start a similar journey. As I publish related articles, I will add […]

How to Properly Load Slowly Changing Dimensions using T-SQL Merge

One of the most compelling reasons to learn T-SQL Merge is that it performs Slowly Changing Dimension handling so well. This post is the fourth in a series called Have You Got the Urge to Merge?. This post builds on information from the other three, so I suggest you stop and read those before continuing, […]