…brew your own Business Intelligence

Blog

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

Enterprise Edition: Core vs CAL

Enterprise is the Cadillac Tesla Model S of SQL Server editions – unbridled access to all the things YAAAAAAAAHHHHHHHHHhRR! Other SQL Server editions (e.g. Standard, Business Intelligence, Developer, etc) have limitations – on product features (e.g. no Columnstore Indexing) and/or hardware resources (e.g. can’t use more than 16 cores or […]

Read more

Choosing between Enterprise and BI Edition for SSAS Environment

SQL Server licensing often finds itself at the butt of a joke amongst professionals in this industry. In case it’s not obvious in the dialogue above, Kendal Van Dyke (b | t) is being sarcastic. Yes, there is a SQL Server licensing guide…and while technically its much closer to 30 […]

Read more

MDX Script: Calculated Members (vs Named Sets)

In the previous blog post I discussed the benefits of defining MDX calculations in the cube (instead of in the query using the WITH-clause). The primary benefit was having named sets computed ahead of time (when the MDX Script is executed) and available via the global cache which greatly improves […]

Read more

MDX Performance Tip: Move Calculations From the Query to the MDXScript

In the world of business intelligence, most people prefer to embed as much business logic as possible into the ETL and materialize it in the data model (i.e. data mart, cube, tabular model, etc). After all, if we can take the hit during our batch processing window – then that’s […]

Read more

Documenting SSAS Configuration Changes Over Time

I hate documenting just as much as the next developer, which is one of the reasons why I spent some time last week (while on vacation…and by ‘vacation’ I mean ‘nearly breaking my neck snowboarding’ in Telluride) coming up with a method for dynamically capturing SSAS server-level configuration properties.  (definitely […]

Read more