The Curious Engineer

All blogs / Databases

John Desch (Microsoft Consulting Services Data Insights)

learn.microsoft.com/en-us/archive/blogs/johndesch

DatabasesMicrosoft blogsMSDN archive

’15’20’25
Posts
18 from 28 Nov 2011 to 20 Sep 2016
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/johndesch/feed.xml

2016 2

  1. Finding the Last Processed Date for Analysis Services Cubes, Measure Groups and Partitions
  2. Using SQL Server Stored Procedures to Dynamically Drop and Recreate Indexes

2015 2

  1. Scaling Out with Analysis Services
  2. Notes on Deciding whether to implement a Tabular or Multidimensional Model

2014 6

  1. Microsoft Analysis Services using ROLAP storage in Teradata.
  2. Using DMVs and XMLA commands to force a disconnect from an Analysis Server
  3. Using SQL Server to Analyze Analysis Services Profiler Traces from Tabular Models.
  4. Processing Analysis Services. Notes on the Care and Feeding of an OLAP Database
  5. Using SQL Server to Analyze Analysis Services Profiler Traces
  6. Using SSIS to Backup and Restore Extremely Large OLAP Databases

2013 1

  1. Using DMVs to Monitor and Terminate Long Running MDX Queries

2012 6

  1. Analysis Services Proactive Caching Operations and Errors
  2. Using the RS.EXE utility to deploy a Report Server Project and Shared Dataset.
  3. WebPage Error when running a parameterized report with parameters.
  4. Filters aren't applied to related tables in PowerPivot unless a measure is added to the PowerPivot Workbook
  5. Using PowerPivot Workbooks from a Mid-Tier Server Configured for Kerberos Authentication
  6. Parameterized Reporting Services Reports with Analysis Services as a Data Source

2011 1

  1. Planning for Disaster Recovery for PowerPivot Mid-Tier Server