Script for Creating and Generating members for Date Dimensions: General Purpose

Posted by on Jan 9, 2013 in Business Intelligence, ETL, SQL Server, T-SQL | No Comments

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. ...

Read More

I Re-Awarded MVP for 3rd year

Posted by on Dec 31, 2012 in Awards | No Comments

First of all; I wish a happy and Prosperous New Year for all of you my friends, family and visitors of my blog. I wish you all the best in 2013. Today I re-awarded for the 3rd times for Microsoft MVP Award in Microsoft SQL Server. I really appreciate support of all of you my ...

Read More

PIVOT Transformation – SSIS 2012 – Complete Tutorial

Posted by on Dec 30, 2012 in SSIS | No Comments

Following the previous PIVOT Transformation Tutorial which was in 2008 R2 and earlier versions of SSIS, I got some feedback recently to create new version of that Tutorial for PIVOT transformation in SSIS 2012. Fortunately Pivot Transformation GUI improved too much in SSIS 2012 and you don’t need to set PivotUsage in the Advanced Editor ...

Read More

Capitalize Function (Version 2.0) – T-SQL

Posted by on Oct 28, 2012 in SQL Server, T-SQL | No Comments

Hi folks, I’ve changed the t-sql code for Capitalize function, the previous capitalize function worked only if there is one space between words, but this version works even if there be more than one space between words. with this version of Capitalize; you can run the function like this: select dbo.Capitalize(‘st    charles‘) and this ...

Read More

SSAS Dimension Processing: Be Careful about Case Sensitivity

Posted by on Oct 26, 2012 in SSAS | No Comments

Hi folks, Yesterday I faced a situation in one of SSAS cubes, which dimension processing was failed because it found two different members with different attribute values, like Auckland and auckland ! I found out that reason of this problem is SSAS dimension will inherits its collation from underlying database and if you don’t change ...

Read More

T-SQL Function for Capitalize Word and Sentences

Posted by on Oct 25, 2012 in SQL Server, T-SQL | No Comments

Hi folks, Today I faced a situation that I need to capitalize sentences in one column of a SQL Server database table, so I created a function to do that, I put this here to share with you. this function will change sentences like  : select dbo.Capitalize(‘sample text for capitalization!‘) to : Sample Text For Capitalization! Here ...

Read More