MDX #43–Find a MDX Calculation Script

Finding out MDX calculation scripts is a common task
A co-worker recently asked me what the calculation for a calculated measure...

MDX #42–IsEmpty? or = 0 ? or IS NULL?

In SQL, NULL means undefined value
Any SQL programmer can tell you that zero is not NULL, NULL is not zero, and...

SSRS #75 – Use RunningValue() Function and VB Script to capture discrete dates

Drill-down report is a common design
In SSRS, it’s a common design to allow users to drill down to more granular...

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to...

PASS Summit 2014 in Review

I’m finally completely recovered from a great week in Seattle last week for PASS Summit.  Now that it’s back to...

TSQL Tuesday #60: Something Learned This Way Comes

It is once again time to come together as a community and talk about a common theme.  This monthly gathering of the community has just reached it’s 5th anniversary....

TSQL Tuesday #60: Something Learned This Way Comes

It is once again time to come together as a community and talk about a common theme.  This monthly gathering...

Thanks, Vets

Power Testing ETL with Power BI – The Process

This is a short blog series on using Power BI tools to support testing ETL processes. I have presented on...

T-SQL Tuesday #60 – Something New Learned

It’s been five years, and that’s amazing. Not many things last for a year, much less five, but the T-SQL...