Retrieving Aggregate Data from Analysis Services for Reports

March 8, 2011

It’s the second Tuesday of the month, so that means it’s T-SQL Tuesday! This month’s host is Jes Borland (blog | twitter) and the topic is Aggregate Functions. I agree with Doug Lane (blog | twitter), who pointed out in his T-SQL Tuesday post that it’s best if you use the database engine to calculate [...]

5

I Hereby Resolve… (T-SQL Tuesday #14)

January 11, 2011

It’s time for another T-SQL Tuesday, hosted this month by Jen McCown (blog|twitter), on the topic of resolutions. Specifically, “what techie resolutions have you been pondering, and why?” I like that word – pondering – because I ponder a lot. And while there are many things that I do already because of my job, there [...]

2

My Right-to-Left Foot (T-SQL Tuesday #13)

December 14, 2010
Tags: ,

As a business intelligence consultant, I often encounter the situation described in this month’s T-SQL Tuesday, hosted by Steve Jones ( Blog | Twitter) – “What the Business Says Is Not What the  Business Wants.” Steve posed the question, “What issues have you had in interacting with the business to get your job done?” My [...]

5

SQL Server 2008 R2 Reporting Services – I’ve Got Your Page Number (T-SQL Tuesday #005)

April 13, 2010

As you might have guessed if you’ve been reading my blog lately, I’ve been spending a lot of time working with the business intelligence features in SQL Server 2008 R2. Not just Reporting Services, but the whole BI stack. However, it just so happens that today is T-SQL Tuesday and the topic this month is Reporting [...]

2