Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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