SSAS Data Mining – Time Series Algorithm

At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics.  I thought I’d...

The Changing World of BI, A New White Paper for Magenic

In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic,...

Low-rate recruiters – The bane of my existence

There is nothing more annoying to me in my profession than getting calls and emails from recruiters who are looking...

Pivoting weird data in SSIS – Sort of…

Sometimes we get data in some bad forms. For example look at the below table:

The names and the amounts are...

Reading Traces

Capturing information is useless unless you know how to use it. Here’s what I use to get the most out...

Speakers: Rehearsals Help

Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m...

SQL Server – Update Table with INNER JOIN

Often we may need to update a column in a table based of another column in another table.
In SQL Server...

SSAS – Automatic Inventory Generation – 24 Columns – HTML Attachment

Inventory is a vital information,whether you’re a consultant or an in-house DBA, you need to have a reliable inventory of...

Interesting Approach-One Time Tools

Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...

Is $160 Per Day a Lot?

Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...