…brew your own Business Intelligence


Latest Posts

  • 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
PASS Summit 2015