John Desch (Microsoft Consulting Services Data Insights)

Article
2/7/2020

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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT Date: 05/13/2013

Analysis Services Proactive Caching Operations and Errors

One of the more interesting aspects of being involved in supporting Business Intelligence...

Author: John Desch MSFT 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...

Author: John Desch MSFT 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...

Author: John Desch MSFT Date: 05/16/2012

A colleague, with whom I work on a regular basis, recently pointed out a somewhat unexpected feature...