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 … Continue reading Automating SSAS Dump Collections using SQLDumper.exe
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 … Continue reading How Can My Business Leverage Twitter/Facebook Data?
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 … Continue reading Investigating xEvents in SSAS 2016 CTP2