…brew your own Business Intelligence

Blog

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

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