December 19, 2010

Drill down in SSRS Map Reports

I have been always interested in the potential of map reports. So naturally, when I found out a site which had quite a number of shapefiles for free, I decided to blog something just for the fun of working with […]
December 6, 2010

Subscripts and Superscripts in SSRS Reports

               Two weeks back, I was reading an insightful article by Thomas LaRock – Delivering a Great Presentation. A couple of lines kept on lingering in my mind, mainly – “Storytelling is a very powerful way for you to communicate […]
December 1, 2010

Conditional Navigation in SSRS

Why do people write blogs or help other people in the technical forums? This was a frequent question that I used to ask to people around me. For some reason or the other, I couldn’t fathom why people would want […]
November 12, 2010

Is it the end of the road for SSAS?

If you have been following the PASS summit notes coming from the attendees, you would have noticed an unmatched sense of pandemonium in the SSAS community. The reason is none other than the announcement of Microsoft’s decision to move from […]
November 5, 2010

The Curious Case of Joins while Cube Processing

One of those days, I was just chatting with a colleague of mine about some database designs and he was showing me some exquisite piece of work in the database. That is when I happened to glance upon a stored procedure […]
September 4, 2010

Import Shapefiles into SQL Server and Aggregate Spatial Data (Geometry)

Around 6 months ago, I was desperately looking for some online resources to help me implement some map reports. The shapefile I was dealing with was at a very granular level (which means that it had a lot of data, […]
August 24, 2010

Performing a Right Outer Join with a Left Outer Join clause

Most of the interviewers I have seen tend to prefer people with better problem solving skills rather than better knowledge on a particular technology. No wonder considering the fact that technologies change with each fleeting moment, while a good problem […]
July 27, 2010

London Ahoy!

To all those folks who have been wondering where I disappeared – I just relocated to London from Bangalore this Sunday, 25 July! I was extremely busy in the preparations and hence couldn’t blog much and by the looks of […]
July 3, 2010

Aggregate of an aggregate function in SSRS

I am worse than a child when it comes to colours and no wonder, spend a lot of time on the aesthetics whenever I am preparing an Excel sheet or a PowerPoint presentation. For me, this is rather a way […]
June 23, 2010

SSAS Dimension Attribute Properties : Part 2

Yesterday, I was reading through some articles and happened to glance through a very memorable quote by  Berthold Auerbach – “ The little dissatisfaction which every artist feels at the completion of a work forms the germ of a new […]