Slowing Changing Dimension (SCD) demystified – Part 3

I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e.  in most business scenarios)
Unlike...

The Tally Table and Expanding Rows

Suppose you had some data like this:
Class           Limit
————— ———–
Calculus        5
History         4
Physics         2
But what you really want is this:

Class          ...

Being careful in SSAS to not make a cube/dimension unprocessed

A big headache in SSAS, especially when dealing with a large cube, is making a change that when deployed, causes...

BIxPress 3.5–Now With More Awesome!

Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...

Denali – Day 21: Security

Denali – Day 21: Security

 
Security wise Microsoft sql server is going great and on compare with other RDBMS in the market...

Is Dynamic T-SQL a Good Design Pattern?

In a recent discussion it was suggested to me that not only is dynamic T-SQL useful for things like catch-all...

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...

SQL Server 2012 Certifications Revamped

Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...

SQLSaturday #119 Chicago – In the Books

As I write this, I’m enjoying a margherita pizza and a Miller High Life in my room.  The SQLSaturday #119...

SSRS: FORMAT option for milliseconds

Some of our reports have hyperlink enabled on few metrics which points to an internal website. Recently there was a...