…brew your own Business Intelligence

Home

Latest Posts

  • PSA: Stop Putting Sorts in SSIS Data Flows…
    …or any fully-blocking transforms for that matter.   SSIS 101 The primary function of SSIS is to move data from location A to location B with the option of performing transformations to the data along the way. That’s certainly an over simplification but it gives you the general framework from...
    Read more
  • Dad, Successful Project, Linchpin, PASS Summit 2015
    Apologies for the lack of updates recently. Work and life picked up so I haven’t had as much time for blogging. But not to worry, plenty of content coming down the pipeline. Life I’m a dad! Well, sorta. My wife and I decided to “rescue” a baby golden retriever from...
    Read more
  • 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
PASS Summit 2015