John Desch (Microsoft Consulting Services Data Insights)
Finding the Last Processed Date for Analysis Services Cubes, Measure Groups and Partitions
Recently, a question was raised on one of the email aliases that I follow and I’ve seen the same...
Date: 09/20/2016
Using SQL Server Stored Procedures to Dynamically Drop and Recreate Indexes
Recently, I've been working on a project that of necessity involves periodically updating data in...
Date: 07/30/2016
Scaling Out with Analysis Services
Scaling Out with Analysis Services A few months ago, I had the opportunity to work with a customer...
Date: 08/17/2015
Notes on Deciding whether to implement a Tabular or Multidimensional Model
Within the Business Intelligence community, when the discussion comes to Microsoft SQL Server...
Date: 07/27/2015
Microsoft Analysis Services using ROLAP storage in Teradata.
I recently had the opportunity to work with a customer who was interested in implementing a...
Date: 12/23/2014
Using DMVs and XMLA commands to force a disconnect from an Analysis Server
At one time or other, just about every DBA charged with administering a Microsoft SQL Server...
Date: 11/14/2014
Using SQL Server to Analyze Analysis Services Profiler Traces from Tabular Models.
My last blog post was focused on using SQL Server to analyze profiler traces against...
Date: 06/26/2014
Processing Analysis Services. Notes on the Care and Feeding of an OLAP Database
Anyone who has had the opportunity to work with Microsoft Analysis Services, in multidimensional...
Date: 06/26/2014
Using SQL Server to Analyze Analysis Services Profiler Traces
In 2007, Carl Rabeler and Eric Jacobsen wrote a fairly detailed white paper entitled Identifying and...
Date: 06/02/2014
Using SSIS to Backup and Restore Extremely Large OLAP Databases
Working in the field of Business Intelligence I get the opportunity to work with some really large...
Date: 04/18/2014
Using DMVs to Monitor and Terminate Long Running MDX Queries
At one time or other, just about every DBA charged with administering a Microsoft SQL Server...
Date: 05/13/2013
Analysis Services Proactive Caching Operations and Errors
One of the more interesting aspects of being involved in supporting Business Intelligence...
Date: 12/17/2012
Using the RS.EXE utility to deploy a Report Server Project and Shared Dataset.
Since broadening my area of concentration and branching out from Microsoft Analysis Services to the...
Date: 12/17/2012
WebPage Error when running a parameterized report with parameters.
I was recently onsite visiting one of my customers when a rather interesting issue was brought to my...
Date: 05/16/2012
Filters aren't applied to related tables in PowerPivot unless a measure is added to the PowerPivot Workbook
A colleague, with whom I work on a regular basis, recently pointed out a somewhat unexpected feature...
Date: 05/16/2012
Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication
I'm not entirely certain how widely known, but it is quite possible to use a PowerPivot Workbook as...
Date: 04/23/2012
Parameterized Reporting Services Reports with Analysis Services as a Data Source
Microsoft Analysis Services is a commonly used data source for Microsoft Reporting Services reports....
Date: 04/16/2012
Planning for Disaster Recovery for PowerPivot Mid-Tier Server
Every experienced DBA is familiar with the software equivalent of “Murphy’s Law”...
Date: 11/28/2011