…brew your own Business Intelligence

Home

Latest Posts

  • Automating SSAS Dump Collections using SQLDumper.exe
    Last year I was involved with standing up an Analysis Services Scale-Out Query Server architecture to handle a heavy concurrent user load. Unfortunately, we didn’t get around to stress-testing the system until a few months later and we uncovered an issue requiring escalation to Microsoft. In this post, I’ll share a...
    Read more
  • How Can My Business Leverage Twitter/Facebook Data?
    As a BI consultant, I get asked this question (or some version of it) a lot: How Can My Business Leverage Twitter/Facebook Data? The conversation typically goes something like this: CIO/IT Director: I read an article in <insert CIO magazine>-weekly that claimed so-and-so used Twitter/Facebook data to do such-and-such and is now...
    Read more
  • Investigating xEvents in SSAS 2016 CTP2
    Last week I finally found some time to explore SQL Server 2016 CTP2 and considering I’ve spent quite a bit of time over the past 12 months performance tuning SSAS queries, I figured why not start with extended events. Plus, you can usually infer quite a bit from looking at the tracing...
    Read more
  • SSAS Related Enhancements in SQL Server 2016
    As has seemingly been the case for a while, the majority of SSAS-related enhancements slated for release with SQL Server 2016 fall mostly on the side of Tabular. And while I totally understand this from a product management perspective (Tabular is still much less mature than Multidimensional so there’s more...
    Read more
  • SQL Saturday #392 – Atlanta, GA
    In just 5 short days, SQL Saturday #392 will be coming to town and I couldn’t be more excited! SQL Saturday Atlanta has a special place in my heart as it was here …back in 2011, while attending my very first SQLSaturday… that I made up my mind and decided to...
    Read more
PASS Summit 2015