Harnessing the Power of both worlds

  Harness the Power of Both Worlds –SQL Engine and Analysis Services Introduction The combination of the SQL Engine and Analysis Services is awesome because it lets you harness the power of both worlds: columnstore Indexes in the SQL engine and real-time or relational OLAP (ROLAP) in Analysis Services. Recently I have done some testing…


System Patching: Steps need to follow on SSAS Server before applying Windows Patches

  Generally when we apply System Level patches we tend to reboot Machine / Server multiple times based on Patch requirement. In this blog I am trying to cover points we need to keep in mind while applying System Level Patches: Reboot can cause SSAS Database Corruption (refer this link for more details), before applying…

Analysis Services MOLAP Performance Guide for SQL Server 2012 and 2014

  This white paper describes how business intelligence developers can apply query and processing performance-tuning techniques to their OLAP solutions running on Microsoft SQL Server Analysis Services. This paper is based on the performance guide for 2008 R2 and has been reviewed and updated to validate performance on SQL Server 2012 and SQL Server 2014….

Tabular: Cant see Databases in Management Studio

  Background You have a Role which got only Read Permission for Tabular Database with users who can only query Databases which means they can use any client tool and should be able to query Tabular Databases from any tool which they prefer like SSMS, SSRS, PPS, Excel, etc. Roles and Permission shown in Figure…