Slowing Changing Dimension (SCD) demystified – Part 1

SCD is a basically a concept that explains how historical data/values are stored within a data in a database.

There are...

SQL Rally–1 week out

It’s hard to believe that after all the hard work, planning, and prep, that SQL Rally Dallas is just a...

Win a Free SQLRally Admission!

As those of you in our local North Texas SQL Server User Group are aware, we have given away one...

Building an Intel Ivy Bridge Desktop System, Part 2

A few weeks ago, I wrote about buying some of the components that I needed to build a new 22nm...

Choosing the Right Microsoft Reporting Technology Part 6: Making the Decision

We’ve completed reviewing the major Microsoft tools and now you have to make “The Decision”.  Which tool(s) is the best...

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON )

AlwaysON Availability Group:

is another very important achievement done by development team project...

Fast Track Data Warehouse Reference Guide for SQL Server 2012

I have previously blogged about Fast Track Data Warehouse, a reference configuration optimized for data warehousing (see Microsoft SQL Server Reference...

Identity Crisis

I’m sure most people have identity values lurking somewhere in their databases.  In fact I would guess that most people...

One Week from SQLRally!

SQLRally is a week away (pre-cons start on Tuesday, conference starts on Thursday). I have the privilege of two sessions to...

Presenting at SQL Saturday 119 Chicago!

First thing in the morning Saturday May 19th:

I will be presenting with my colleague from House of Brick David Klee...