SSAS M2M

Many 2 Many dimensional modeling is one of the most powerful capabilities in OLAP. It can reduce the need for a lot of complex SQL, and also improve report execution time.

Read more

SSAS Hardware Tuning

Project REAL: Enterprise Class Hardware Tuning for Analysis Services Here is a whitepaper I had authored long back – after months of testing AS processing and querying.  It uses state of the art hardware at that time. http://download.microsoft.com/download/4/1/F/41F09116-19B3-40FE-9D54-D1E9B7AF9E82/REAL_Ent_HW_Tuning.doc My hope is to demonstrate the importance of hardware tuning for Analysis Services performance. Feedback welcome!

Read more

SSIS Generating Surrogate Keys

Here is something interesting I wrote to bridge the gap of surrogate keys in the slowly changing dimension transform that comes out of the box in SQL Server Integration Services. Generating Surrogate-Keys for Type 1 and Type 2 dimensions using SSIS http://www.sqlservercentral.com/columnists/hbhaiya/2783.asp (You may have to log in to view the article). Please download the sample [...]

Read more

SSAS Security Architecture

Here is one of the most secure deployment architectures for SSAS in a DMZ / intranet / Internet facing scenarios. But it does require some custom code. I will later post some of the details on how to achieve this deployment.

Read more