Last week while spending some time on the forums, I stumbled upon a thread where the user had presented 2 queries with seemingly identical logic but produced very different results. After a bit of troubleshooting … Continue reading SSAS Bug: EXCEPT with nested FILTER functions on MEMBERVALUE
Analyzing SQL Server Object Dependencies with NodeXL
One time I was tasked with developing a handful of custom reports for a legacy application. The data model was an absolute nightmare – overflowing with technical debt and being held together with duct tape … Continue reading Analyzing SQL Server Object Dependencies with NodeXL
Analysis Services 2012: Tabular or Multidimensional?
If you regularly follow this blog, then chances are likely that you are already well aware of the new Tabular mode in SQL Server Analysis Services 2012. If not, don’t sweat it – we won’t … Continue reading Analysis Services 2012: Tabular or Multidimensional?
Top FREE tools for SSAS 2012 Developers
Over the years, I’ve come across a number of tools aimed at helping SSAS developers work more efficiently. In this post, I’ll share with you the ones I’ve found the most useful and give you … Continue reading Top FREE tools for SSAS 2012 Developers
How to Calculate the Median in T-SQL, MDX, and not DAX
Building from my last post, Performance Metrics: Average, Mean, Median, and Outliers, where I covered the topic of when to use Median instead of Average, in this post I’m going (to try) to show you how … Continue reading How to Calculate the Median in T-SQL, MDX, and not DAX
Performance Metrics: Average, Mean, Median, and Outliers
This weekend, I stumbled across a post that really hit close to home. The post was written by Brad Feld, a VC whose blog I’ve subscribed to since college. Brad normally writes about startups, startup-communities, … Continue reading Performance Metrics: Average, Mean, Median, and Outliers