Online Analysis Services Course: Developing a Multidimensional Model

Check out the excellent, new online course by Peter Myers and Chris Randall for Microsoft Learning Experiences (LeX). Lean how to develop multidimensional data models with SQL Server 2016 Analysis Services. The complete course is available on edX at no cost to audit, or you can highlight your new knowledge and skills with a Verified Certificate for a small… Read more

Model Comparison and Merging for Analysis Services

Relational-database schema comparison and merging is a well-established market. Leading products include SSDT Schema Compare and Redgate SQL Compare, which is partially integrated into Visual Studio. These tools are used by organizations seeking to adopt a DevOps culture to automate build-and-deployment processes and increase the reliability and repeatability of mission critical systems. Comparison and merging… Read more

What’s new in SQL Server 2017 RC1 for Analysis Services

The RC1 public preview of SQL Server 2017 is available here! It includes Dynamic Management View improvements for tabular models with compatibility level 1200 and 1400. DMVs are useful in numerous scenarios including the following. Exposing information about server operations and health. Documentation of tabular models. Numerous client tools use DMVs for a variety of… Read more

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 3

Part 2 finished with the deployment of a scalable Tabular 1400 model in Azure Analysis Services on top of Azure Blob storage. Part 3 continues the story by attempting to load up to 1 TB of TPC-DS source data into the model–hosted on the largest server that Azure Analysis Services offered at the time of… Read more

Update to Auto-Partitioning Code Sample & Whitepaper

A new version of the whitepaper and code sample of automated partition management (see here for more info) is released! Enhancements include the following. Support for 1400 models with M partitions and M expressions. Query partitions (with queries of the data source dialect) are still supported. Auto retry n times on error for near-real time… Read more

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 2

The first part in this series covering Azure Analysis Services models on top of Azure Blob Storage discussed techniques to implement a small Tabular 1400 model based on synthetic TPC-DS source data. This second part continues the journey to take Tabular 1400 in Azure Analysis Services to larger scale factors—up to the maximum capacity that… Read more

What’s new in SQL Server 2017 CTP 2.1 for Analysis Services

The public CTP 2.1 of SQL Server 2017 is available here! This public preview includes the following enhancements for Analysis Services tabular models. Shared M expressions are shown in the SSDT Tabular Model Explorer, and can be maintained using the Query Editor. Data Management View (DMV) improvements. Opening an file with the .MSDAX extension in… Read more

Building an Azure Analysis Services Model on Top of Azure Blob Storage—Part 1

In a comment to a recent blog article, Bill Anton raised a question about the target scenarios for the modern Get Data experience in Tabular 1400 models, especially concerning file-based data sources. So, let’s look at a concrete example from my personal to-do list: Building a Tabular model on top of industry standard synthetic data… Read more

1400 Compatibility Level in Azure Analysis Services

We are excited to announce the public preview of the 1400 compatibility level for tabular models in Azure Analysis Services! This brings a host of new connectivity and modeling features for comprehensive, enterprise-scale analytic solutions delivering actionable insights. The 1400 compatibility level will also be available in SQL Server 2017 Analysis Services, ensuring a symmetric… Read more

Join Alberto Cairo at the Microsoft Data Insights Summit to Explore the Different Dimensions of Data Visualization

Known for his award-winning global achievements in infographics and multimedia as a professor, author, journalist and designer, we are excited to welcome data visualization expert Alberto Cairo back to the Microsoft Data Insights Summit, taking place June 12-13, 2017 in Seattle. This year Alberto will provide a special guest keynote focused on the different dimensions… Read more