Improve your SSIS package’s performance

Hello everyone. I spent almost the whole last week and the first 2 days of this week trying to improve my BI solutions' performance. In my quest on learning the tricks to make my package faster, I came across SSIS Performance Design Patterns video by Matt Masson. A comprehensive discussion indeed, that I'm gonna list … Continue reading Improve your SSIS package’s performance

Making SSRS reports faster: get rid of Parameter Sniffing

Is your SSRS report running slowly? Are you using a stored procedure to pull the data and pass them to report? If your answer to these questions is yes, then you are a victim of SQL Server's Parameter Sniffing. The first question is, what is Parameter Sniffing? It refers to SQL Server's effort to reduce … Continue reading Making SSRS reports faster: get rid of Parameter Sniffing

Spliting records into multiple rows using SSIS Script Component

Hi folks. This is a post in response to Add Interim Rows Depending on Max and Min Values question asked in MSDN SSIS Forum, but it could be applied to any similar situation and problem. HEre I am gonna describe the steps needs to be taken to split the records coming from a data base table … Continue reading Spliting records into multiple rows using SSIS Script Component