-
And so, it has been an eventful 3 months since I reached the US, and I must say I am really settling in well to my new job and life here. Also, it has been a full two years since I started blogging and a big shout to all those lovely people out there who have been tolerating me and my “random thoughts”...
-
How fast time flies! Another new version of SQL Server has been launched and it seems like it was only a few days ago that SQL Server 2008 was released. Those days, I was mainly focussing on SSRS, and I can’t express in words how happy I was when I saw all the new features in SSRS 2008 and 2008 R2. Today...
-
One of my first blogs here was based on the Rich Text functionality in SSRS 2008 . However I found very little use of that in my projects and did not explore that area much. However a recent question in the forums made me rethink on the way I thought about the rich text functionality. The question was...
-
I love working with map reports and I don’t miss a chance to fiddle around with it. In fact, I am such a big fan that I think there would be very few sessions (in English, of course!) involving SSRS and maps that I would have missed, both online and live. Also, this is one of those topics that can make...
-
As a BI consultant specializing in SSRS, I have had lots of frustrations and hard times because of Excel. Every now and then, I have some or other business user coming up to me and asking for some feature which is there in Excel but not in SSRS. If you have been following my blog, you would already know...
-
I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue. Situation : Duh, that’s strange! It’s a sunny day...
-
Do you know how it feels like to hear an old song and have a whole lot of memories come flooding back to you? Well, something sort of similar happened to me today. I was doing my weekly reading and going through a brilliant post by Microsoft MVP - Greg Galloway ( blog ). That was when I noticed that...
-
A reader asked me how to add grand totals a matrix ( A Sample of Matrix in SSRS ). It’s actually pretty easy to accomplish that in both SSRS 2005 and 2008. I am going to show a few screen shots here. Challenge Suppose you have a very simple table with sales data for products sold from each store...
-
Hi folks, Continuing from my last post on transformation task MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation Task MSBI # 59 – SSIS # 23 – Data Flow Task # 9 – Audit Transformation Task MSBI # 60 – SSIS # 24 – Data Flow Task # 10 – Cache Transform Task In this article we are going...
-
Note:- Please refer to post mentioned here to see why there are less number of log records. Actully this is not minimal logging but its less number of log records/ As per BOL ( here and here ), minimal logging is only possible in SIMPLE and BULK-LOGGED recovery mode using bulk operations and FULL recovery...
-
In my previous blog, SSRS & SSAS #63 – Stop SSRS 2008 MDX Query Designer from Overwriting Parameter Queries , I mentioned that you can manually remove the parameter default values in BIDS before you deploy your reports to your report server. But what if you already “infected” your...
-
Christmas time is one of my most favourite times of the year – the time when you can just lay back, relax, enjoy some quality time with your family and catch up with your old friends. While this Christmas time has been a little hectic for me considering that I changed my base from London, UK to Charlotte...
-
In a previous blog, SSRS & SSAS #61 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers , I complained about how bad the integration between Reporting Services and Analysis Services is. Complain itself will not solve any issue. But it drove me to focus on...
-
Hi Geeks, Continuing from my last post on SSIS – Data Flow Task MSBI # 57 – SSIS # 22 – Data Flow Task # 8 – Aggregate Transformation Task MSBI # 59 – SSIS # 23 – Data Flow Task # 9 – Audit Transformation Task In this article we are going to cover Cache Transform Task with points Why Cache Transformation...
-
I am a SQL purist, meaning that I have vowed never to use cursors in T-SQL to loop through rows record by record. In SSIS package design, however, I have used the Foreach Loop Container very often. I would not say that I have broken my vows though for the following reasons: 1. The record set I loop through...