…brew your own Business Intelligence

Home

Latest Posts

  • Speaking at SQL Saturday #320 – Raleigh, NC
    I know, I know… a terrible lack of content here over the past 2 months. Work has been crazy busy since July (read: 65+ hr weeks) and culminated in a (mostly) disconnected and work-free vacation with my favorite wife involving an in-no-hurry drive up the Pacific Coast Highway from San...
    Read more
  • Building an OLAP Farm in the Cloud with Azure Virtual Machines – Part 1
    The “OLAP Farm” is an Analysis Services architecture that makes use of remote partitions on the backend and linked dimensions and measure groups on the front end in order to support solutions where datasets and latency requirements simply can’t be handled by a single processing server. It was discussed in...
    Read more
  • SSAS Scale-Out Architectures
    Processing can be a very resource intensive task which will absolutely interfere with query performance when using a single server deployment. Most clients can get around this issue by simply processing after hours and/or designing and implementing a complex incremental processing scenario (e.g. process add + process partitions). However, when...
    Read more
  • Case Study Review: Using Tabular Models in a Large-scale Commercial Solution
    Just a few days ago, a case study was released by one of the top Microsoft BI folks in the world – Alberto Ferrari (b | t) – outlining the evaluation process of using SSAS Tabular in a large-scale commercial solution. This paper is a must-read for those considering the...
    Read more
  • MDX: MemberValue vs Member_Value
    Lately I’ve been doing a bit of MDX performance tuning and during the process I learned a new “trick” that blew my mind. Instead of just outright telling you what it is, I’d like to show you through an example. Original Query Take the following query shown below – which...
    Read more
PASS Business Analytics Conference 2014