Tallan Blog

Tallan’s Experts Share Their Knowledge on Technology, Trends and Solutions to Business Challenges

Posts Tagged "DAX"

thomas-jensen-qTEj-KMMq_Q-unsplash

Moving On From SQL Server Analysis Services Multidimensional – Part 1

Background
SQL Server Analysis Services Multidimensional (SSASm) was first offered in 2000, and soon became the dominant cube server product on the market.  It got a ground-up rewrite in 2005 and further enhancement in 2008 that greatly increased its capabilities, performance and proliferation.  SSASm uses the expression and query language MDX (multi-dimensional expressions), known for its power and steep learning curve.  SSASm grew into an amazingly powerful and widely-used product, the more impressive given it is bundled for free with a SQL Server license (sometimes you get more than you paid for).  Because of this bundling it is difficult to know how many production instances of SSASm are running, but even a small fraction of the number of SQL Server licenses would be significant.
In 2010, Microsoft introduced a new in-memory, columnar database technology named variously xVelocity and Vertipaq.  This new technology…

\\\