Please, PLEASE stop calling stuff like this a 'Design Pattern' - this is maybe a template, maybe a 'tip' - but it's not a 'Design Pattern'.

Go look up the GOF...

Please please please refer to these sorts of articles as 'techniques' or 'methods' or 'solutions' -valuable mind you, but 'design pattern' mens something quite specific, and strategies for using sql...

Rule 0 -

Bring doughnuts! 😀

Correctly configured, SSAS is capable of giving you answers in a fraction of the time a SQL query will, and (correctly configured) can answer questions that would require extensive coding...

Forgive me if you are aware of this already, but if you are using Excel, you don't *need* anything else.

You may want to explore the new tool, but you do...

I have a major issue with your statement that 'sharepoint is a major component of the bi stack'.. ms would certainly love to sell more of it, but there's no...

DOH please disregard prev. post.

I fixed this by:

1) installing SP2 on my local PC to get the latest RSPrintClient cab files

2) deleted the RSPrintClient files from C:\Windows\DowloadedProgramFiles

3) renamed the existing...

Um, just ooc - I didn't see any discussion of just doing this in SQL?

Why use SSIS at all?