Learn how to “think like a Freak” with Freakonomics authors at Microsoft Data Insights Summit

With more than 5 million copies sold in 40 countries, Freakonomics is a worldwide phenomenon — and we’re thrilled to announce that authors Steven Levitt and Stephen Dubner will join us for a special guest keynote at Microsoft Data Insights Summit, taking place June 12–13, 2017 in Seattle. The Microsoft Data Insights Summit is our… Read more

DirectQuery in SQL Server 2016 Analysis Services whitepaper

I am excited to announce the availability of a new whitepaper called “DirectQuery in SQL Server 2016 Analysis Services”. This whitepaper written by Marco Russo and Alberto Ferrari will take your understanding and knowledge of DirectQuery to the next level so you can make the right decisions in your next project. Although the whitepaper is… Read more

Learn about Azure Analysis Services at the Microsoft Data Insights Summit 2017

We’re excited to participate in the Microsoft Data Insights Summit June 12 – 13, 2017 in Seattle, WA. This two-day event is designed to help you identify deeper insights, make better sense of your data, and take action to transform your business. This year’s Microsoft Data Insights Summit will be filled with strong technical content,… Read more

Online Analysis Services Course: Developing a Tabular Model

Check out the excellent, new online course by Peter Myers and Chris Randall for Microsoft Learning Experiences (LeX). Lean how to develop tabular 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… Read more

What makes a Data Source a Data Source?

It should be obvious, and it is — at least at the Tabular 1200 compatibility level: A data source definition in a Tabular model holds the connection information for Analysis Services to connect to a source of data such as a database, an OData feed, or a file. That’s straightforward. However, at the Tabular 1400… Read more

SSMS DAX Query Editor

We are excited to announce the SQL Server Management Studio DAX Query Editor! Have you ever authored a DAX query in SSMS using the MDX editor? With the new DAX Query Editor, you no longer need to do. Download RC3 for vNext from the SSMS release candidate download page. To try it out, click on… Read more

Introducing SQL Server Data Tools for Analysis and Reporting Services for Visual Studio 2017

Visual Studio 2017 brings improvements to performance, navigation, IntelliSense, Azure development, mobile development, and boosts productivity through live unit testing and real-time architectural dependency validation. There are many good reasons for developers to use Visual Studio 2017. And thanks to the timely availability of SSDT AS and RS for Visual Studio 2017, BI Pros do… Read more

Encoding Hints and SQL Server Analysis Services vNext CTP 1.3

The public CTP 1.3 of SQL Server vNext on Windows is available here! The corresponding versions of SQL Server Data Tools (SSDT) and SQL Server Management Studio (SSMS) will be released in the coming weeks. They include much-anticipated new features, so watch out for the upcoming announcements! Encoding hints CTP 1.3 introduces encoding hints, which… Read more

Released: SQL Server Data Tools 17.0 RC 2

SQL Server Data Tools 17.0 Release Candidate 2 (RC 2) has just been published. You can download and install from here: https://go.microsoft.com/fwlink/?linkid=837939. If you’re evaluating new enhancements in Analysis Services Tabular 1400 models, be sure to download this latest version because it includes several important fixes; particularly with the modern Get Data experience. Most noteworthy… Read more

Whitepaper and Code Sample for Automated Partition Management

Analysis Services tabular models can store data in a highly-compressed, in-memory cache for optimized query performance. This provides fast user interactivity over large data sets. Large data sets normally require table partitioning to accelerate and optimize the data-load process. Partitioning enables incremental loads, increases parallelization, and reduces memory consumption. The Tabular Object Model (TOM) serves… Read more