Wednesday, March 29, 2017
Updates from SSAS Team (SQL Server Analysis Services) @ Microsoft

Get Aggregated RSS

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

Wednesday, March 22, 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

Wednesday, March 22, 2017

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?

Wednesday, March 15, 2017

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

Tuesday, March 14, 2017

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

Thursday, March 09, 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

Friday, February 17, 2017

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

Thursday, February 02, 2017

SQL Server Data Tools 17.0 Release Candidate 2 (RC 2) has just been published. You can download and install from here: 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

Monday, January 16, 2017

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

ASTrace on the Analysis Services Git Repo

Monday, January 16, 2017

The ASTrace utility provides the ability to capture an Analysis Services trace and log it into a SQL Server table. The table can be queried later or read using SQL Server Profiler. The ASTrace utility runs as a Windows service that connects to Analysis Services, then creates a trace, and logs trace events into a SQL... Read more

Evaluating Shared Expressions in Tabular 1400 Models

Friday, December 30, 2016

In our December blog post; Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services, we mentioned SSDT Tabular does not yet support shared expressions, but the CTP 1.1 Analysis Services engine already does. So, how can you get started using this exciting new enhancement to Tabular models... Read more

Copyright [2014] by SQLCOMMUNITY.COM