Monday, September 25, 2017
 
Updates from SSAS Team (SQL Server Analysis Services) @ Microsoft

Get Aggregated RSS

Using Legacy Data Sources in Tabular 1400

Tuesday, September 12, 2017

The modern Get Data experience in Tabular 1400 brings interesting new data discovery and transformation capabilities to Analysis Services. However, not every BI professional is equally excited. Especially those who prefer to build their models exclusively on top of SQL Server databases or data warehouses and appreciate the steadiness of tried and proven T-SQL queries... Read more

Using Azure Analysis Services on Top of Azure Data Lake Store

Tuesday, September 05, 2017

The latest release of SSDT Tabular adds support for Azure Data Lake Store (ADLS) to the modern Get Data experience (see the following screenshot). Now you can augment your big data analytics workloads in Azure Data Lake with Azure Analysis Services and provide rich interactive analysis for selected data subsets at the speed of thought!... Read more

Supporting Advanced Data Access Scenarios in Tabular 1400 Models

Monday, August 28, 2017

In the context of this blog article, advanced data access scenarios refers to situations where data access functions inside M expressions cannot easily be represented through data source definitions in Tabular metadata. These scenarios are predominantly encountered when copying and pasting complex M expressions from an Excel workbook or a Power BI Desktop file into... Read more

Deploying Analysis Services and Reporting Services Project Types in Visual Studio 2017

Wednesday, August 23, 2017

(Co-authored by Mike Mallit) SQL Server Data Tools (SSDT) adds four different project types to Visual Studio 2017 to create SQL Server Database, Analysis Services, Reporting Service, and Integration Services solutions. The Database Project type is directly included with Visual Studio. The Analysis Services and Reporting Service project types are available as separate Visual Studio... Read more

Online Analysis Services Course: Developing a Multidimensional Model

Thursday, July 20, 2017

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

Wednesday, July 19, 2017

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

Monday, July 17, 2017

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

Thursday, June 22, 2017

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

Tuesday, May 30, 2017

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

Tuesday, May 30, 2017

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

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM