Archives

Announcing Two Biml Presentations Next Week

My enthusiasm for Biml must be catching because I’ve been asked to give two presentations next week.

I’ll be giving a brand new presentation on Tuesday, November 12th, at 4:30pm for the MSBIC group at the Microsoft Building in Irving, TX. This presentation is targeted towards Business Analysts, management, and other members of the data warehouse […]

Biml Makes You THE ONE

The Matrix is one of my favorite movies. The story, special affects, and the theme are so compelling that I’ve watched the movie at least a dozen times. I referenced it in the introduction for my SQL Saturday 255 presentation, Biml – The Next Step in Agile Data Warehousing, and it fits in perfectly with […]

Upcoming Presentations at NTSSUG and SQL Saturday Dallas

Just wanted to give my readers, both of you, a quick heads up on my upcoming presentations, both of which deal with BimlScripting.

“Biml Basics” Tuesday Night at NTSSUG

Tuesday night (10/29) I’m presenting the final session (for now) of my Data Warehousing Basics and Beyond series for the North Texas SQL Server User Group. We’ve […]

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

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

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

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

Page 3 of 41234