…brew your own Business Intelligence


Latest Posts

  • SSAS Tabular: Scale-Out Query Architecture
    Earlier this week, while discussing high-concurrency architecture options for SSAS multidimensional, a colleague asked about options for SSAS tabular and mentioned there was very little information available online specific to tabular…and so, a blog post is born. The short answer is that Scale-Out Query Architecture for Tabular is essentially identical...
    Read more
  • 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
  • Jar-O-Skittles: Benefits of Table Partitioning
    Quick note to the regular reader: don’t worry, still planning on finishing the series on Building a Scale-Out OLAP Farm in the Cloud with Azure VMs. But I’m afraid there’s not much time to work on that until we ship some important code (which I’ve been working around the clock...
    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
PASS Business Analytics Conference 2014