Browse by Tags

Tagged Content List
  • Blog Post: Microsoft Analysis Services using ROLAP storage in Teradata.

    I recently had the opportunity to work with a customer who was interested in implementing a Microsoft SQL Server 2012 Analysis Services database, using ROLAP storage, with Teradata as the relational data source. With a week to build a Proof of Concept (POC) solution using Microsoft SQL Server Analysis...
  • Blog Post: 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 Multidimensional Analysis Services databases, so I though it only appropriate to follow-up with a post on using SQL Server to analyze profiler traces from a Tabular Analysis Services database. In July of 2013, John Sirmon...
  • Blog Post: 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 (read that as multi-terabyte) OLAP databases. Multi-terabyte OLAP databases, while not yet common place, are being seen with greater frequency and they do present a few interesting challenges to developers...
  • Blog Post: 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 Analysis Services server has encountered a long running query that seems to consume machine resources with a voracious appetite. Those queries are typically executed by "Power Users" and almost invariably at...
  • Blog Post: Analysis Services Proactive Caching Operations and Errors

    One of the more interesting aspects of being involved in supporting Business Intelligence applications is the opportunity to investigate behaviors that are either unexpected or perhaps not so intuitively understood. Proactive Caching is one aspect of Analysis Services that is not well understood by some...
  • Blog Post: 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. The combination provides an environment for creating and rendering interactive reports that are highly performant, flexible and rich in functionality. One of the features of Reporting Services that provides...
Page 1 of 1 (6 items)