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

SSIS 2012 Tutorial Vidoes – 1 : Introduction

Posted by on Oct 17, 2012 in SSIS, SSIS Tutorial Videos | No Comments

Hi folks, I started to create a full set of tutorial videos for SSIS 2012 here. You can view the first video (Introduction to SQL Server 2012 Integration Services) here. This video covers below headlines: Introduction to SQL Server 2012 Integration Services        Requirements for a Tool        ETL        What is SSIS        Which ...

Read More

Speaking about Master Data Services

Posted by on Sep 27, 2012 in MDS, SQL Server | No Comments

Hi folks, I’ll speak about Master Data Services at Microsoft Venue in Auckland on 9th of October of 2012. Session Topic and description: Managing Reference Data with Master Data Services In most of companies there are some reference data which are in use from different applications and databases, This reference data should be consistent and ...

Read More

I am Trainer of SQL Server for the Oracle DBA Course

Posted by on Aug 28, 2012 in Presentations, SQL Server | No Comments

Hi folks, I want to give you a heads up about my new course which will be presented at 15-16 of November in Auckland. Title of Course is : Microsoft SQL Server 2012 for the Oracle DBA. Registration are open now under this website: http://www.auldhouse.co.nz/courses-schedules/vendors/microsoft-technical/sql-server/microsoft-sql-server-2012-for-the-oracle-dba This is a 2 day course, and I and Dave ...

Read More

SSIS Catalog: Part 6 – Operations

Posted by on Aug 20, 2012 in SSIS, SSIS Catalog | No Comments

In previous post of SSIS 2012 Catalog series, I talked about Logging and query log tables from Catalog. In this post you will read more about Operations tables about different tasks like deploy project with detailed information about each operation. I also provide some helper tables to help for writing more descriptive queries on operation ...

Read More