Archives

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

EMAG TRESNI and Data Warehouse Implementation

Those who follow this blog know that I’m a huge video game geek. I have a life-sized Mario statue and a fairly large video game collection which includes about 700 original complete in box NES Games.

Background

I also own almost 40 books about video game history. One of the best books I’ve read […]

What exactly are Dimensions and Why do They Slowly Change?

As I was writing the articles on handling Slowly Changing Dimensions with T-SQL Merge, I realized that some background on Dimensions may be necessary first. Astute readers may remember that I briefly covered Dimension table basics a few years ago, but we need to go into a bit more detail on how to build them […]

Using the Output Clause with T-SQL Merge

The Output clause, first implemented in SQL Server 2005, can be used to return information for each row modified by an Insert, Update, Delete or Merge statement. This functionality greatly increases the power and usefulness of Merge, and is required in the processing of Slowly Changing Dimensions.

This post is the second in a […]

Writing T-SQL Merge Statements the Right Way

In a previous article, I discussed Merge statement basics. However, in extensive testing I’ve come to realize that my article, like most articles I’ve read about Merge leaves out or mis-handles several important aspects. Rather than edit that article, I’ve decided to publish a series of articles which I hope will clear up some of […]

Setup and Performance Issues with the Integration Services (SSIS) 2012 Catalog

For those who don’t know, I’m currently the Data Warehouse Architect for a large scale and complex multi-tenant data warehousing project. Fortunately, the project is being created in SQL Server 2012 and I thrilled to be using the new features. Let me preface this blog post by admitting that my experience with using the SSIS […]

Upcoming Presentations This Week

I’m in for a busy week as I have back to back presentations this Wednesday and Thursday nights.

On Wednesday the 20th, the Forth Worth SQL Server User Group has asked me to present one of my favorites. I’m constantly revising this presentation as I encounter as I come across new mistakes to share. So, […]

Page 3 of 512345