-
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...
-
I have always been inspired by a particular quote from Arthur C Clarke - “ The only way of finding the limits of the possible is by going beyond them into the impossible ”. The more you think of it, the more you make sense out of it. If you decide in your mind that something is impossible, you will never...
-
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...
-
I don’t know about you guys, but I am really petrified of public speaking. So I always try to read about it and it really gives me some comfort to know that I am not alone. In fact, if your fear of public speaking is between mild anxiety and complete terror, you are said to be well within the normal...
-
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...
-
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...
-
The Row Count transformation is a pretty straightforward transformation. It does the following two things: 1. It counts rows as data passes through a data flow, and 2. it stores the final count in a variable . (Note that the variable is only populated when the data flow is finished, not while the data...
-
A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube . If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much in terms of solving real problems in your work. The...
-
Hi folks In my all previous post for SSIS I have cover almost all introductory part for all Data Flow Task ,from now onwards we are going to cover Detailed information & Explanation with example , Use & Properties for each task individually. My last post link so not to break continuity...