SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.

Posted on June 3, 2013 by Reza Rad

This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error. Reason: There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups. for example you might find some membership entries with GUID listed Read more about SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.[…]

I am speaking at Pass Summit 2013

Posted on May 23, 2013 by Reza Rad

I am delighted to say that I will speak at this year’s Pass Summit 2013 in NC Charlotte. Session that I will speak on it is: SSIS Package Failed in Production? Here’s How to Troubleshoot This will be my first attendance in Pass Summit and I am looking forward to see many of you, and Read more about I am speaking at Pass Summit 2013[…]

SQL Down Under Pod Cast

Posted on May 12, 2013 by Reza Rad

Last week I’ve talked with Greg Low from SQL Down Under, and Greg published the podcast talk in his website. I really appreciate Greg’s idea an hard work on podcast shows series on his website. I enjoyed when I read podcasts from many SQL Server MVPs about their area of expertise. I strongly recommend to Read more about SQL Down Under Pod Cast[…]

MDS: Deploy Master Data Services Model with Data From One Server to Another

Posted on March 18, 2013 by Reza Rad

In a multi environment system which you might have Development, UAT and Production for your master data services, the requirement for transfer MDS models across different master data services will be sensible. sometimes you just need to transfer model structure (metadata) from one server to another, but in some situations you will need to have a Read more about MDS: Deploy Master Data Services Model with Data From One Server to Another[…]

Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012

Posted on March 15, 2013 by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at evening of 3rd day of conference. here you can find presentation file of my speaking session about Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Title: Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012 Description: Read more about Presentation files for Hong Kong TechDays 2013 : Knowledge Driven Data Quality with DQS and Microsoft SQL Server 2012[…]

Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence

Posted on March 15, 2013 by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at morning of 3rd day of conference. here you can find presentation file of my speaking session about Choosing the right Visualization Tool with Microsoft Business Intelligence Title: Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI) Description: Microsoft BI stack Read more about Presentation files for Hong Kong TechDays 2013 : Choosing the Right Data Visualization with Microsoft Business Intelligence[…]

Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling

Posted on March 14, 2013 by Reza Rad

Thank you all for attending at my presentation in TechDays 2013 Hong Kong at 2nd day of conference. here you can find presentation file of my speaking session about SQL Server Analysis Services Tabular Modelling Title: SQL Server Analysis Services Tabular Modelling Description: SQL Server 2012 provided another method for modelling BI presentation named SSAS Tabular Modelling. Read more about Presentation files for Hong Kong TechDays 2013 : SSAS Tabular Modeling[…]

DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo

Posted on March 7, 2013 by Reza Rad

If you faced this error when you want to connect Data Quality Services (from Data Quality Client or from SSIS DQS Cleansing component); Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo You can fix it in following way; Why this happens: When .NET Framework Read more about DQS Error : Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate “SetDataQualitySessions” – SetDataQualitySessionPhaseTwo[…]

SSAS Tabular – Microsoft Technical Articles

Posted on February 27, 2013 by Reza Rad

Yesterday in New Zealand Business Intelligence users group, attendees asked some questions that encouraged me to provide some links to Microsoft Articles written on SSAS Tabular. Here you can read more about these articles; Using DirectQuery in the Tabular BI Semantic Model Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services Read more about SSAS Tabular – Microsoft Technical Articles[…]

Presenting at TechDays Hong Kong 2013

Posted on February 21, 2013 by Reza Rad

I will present three sessions at upcoming TechDays conference in Hong Kong at 12-14 March 2013. My sessions are : SQL Server Analysis Services Tabular Modeling Data Cleansing with SQL Server 2012 Data Quality Services Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI) Here are description of my sessions: SQL Server Analysis Services Read more about Presenting at TechDays Hong Kong 2013[…]