What’s new for SQL Server vNext on Windows CTP 1.1 for Analysis Services

The public CTP 1.1 of SQL Server vNext on Windows is available here! This public preview includes the following enhancements for Analysis Services tabular. New infrastructure for data connectivity and ingestion into tabular models with support for TOM APIs and TMSL scripting. This enables: Support for additional data sources, such as MySQL. Additional data sources… Read more

How SQL Server 2016 and Power BI empower Mediterranean Shipping Company (MSC)

Here’s a great case study about Mediterranean Shipping Company optimizing their business processes by taking advantage of the SQL Server 2016 Database Engine, Analysis Services, and Power BI. If you are particularly interested in Analysis Services, you might enjoy reading the section about complying with new Safety of Life at Sea Convention (SOLAS) requirements, which… Read more

Improving Analysis Services Performance and Scalability with SQL Server 2016 Service Pack 1

SQL Server 2016 Analysis Services delivered numerous performance improvements over previous releases, such as better modeling performance thanks to the new 1200 compatibility level for tabular databases, better processing performance for tables with multiple partitions thanks to parallel partition processing, and better query performance thanks to additional DAX functions that help to optimize the client/server… Read more

Improving the Measure Grid in SSDT Tabular

As the name implies, the measure grid is an SSDT Tabular feature to define and manage measures, as illustrated in the following screenshot. It is available for each table when you work in Data View in Tabular Model Designer. You can toggle it on and off by using the Show Measure Grid option on the… Read more

Introducing Azure Analysis Services

We are pleased to announce the availability of Microsoft Azure Analysis Services preview. With Azure Analysis Services, BI professionals can create BI semantic models based on data that resides in the cloud or on-premises, whether that’s SQL Server, Azure SQL Database, Azure SQL Data Warehouse or other data sources to provide business users with a… Read more

Introducing Integrated Workspace Mode for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

When you work with the model designer in SSDT Tabular, you are working with a temporary Analysis Services database that SSDT Tabular automatically loads on a workspace server. During the initial project creation, you must point SSDT Tabular to the desired workspace server, which must be a tabular Analysis Services instance that you can control… Read more

Introducing Tabular Model Explorer for SQL Server Data Tools for Analysis Services Tabular Projects (SSDT Tabular)

If you download and install the August 2016 release of SQL Server Data Tools (SSDT) for Visual Studio 2015, you can find a new feature in SSAS Tabular projects, called Tabular Model Explorer, which lets you conveniently navigate through the various metadata objects in a model, such as data sources, tables, measures, and relationships. It… Read more

Second White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in a Multi-Tier SharePoint 2016 Farm

Last month, we published a white paper about Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016  in a demo environment based on a single-server farm. Given this paper’s high popularity, Jason then suggested that it would also be useful to provide deployment instructions for a multi-server farm with separate front-end and application… Read more

White Paper Published: Deploying SQL Server 2016 PowerPivot and Power View in SharePoint 2016

The PowerPivot add-in for SharePoint Server 2016 was published for the first time as part of the  Microsoft SQL Server 2016 Community Technology Preview (CTP) 3.1 Feature Pack. Now customers can take advantage of SharePoint 2016 in their I-enabled farms and benefit from infrastructure advancements, compliance and security enhancements, and numerous performance and reliability improvements…. Read more

Using Extended Events with SQL Server Analysis Services 2016 CTP 2.3

Extended Events were introduced into Analysis Services in SQL Server 2012. This made use of a common XE module that was shared with SQL Server Database Engine. The challenge with Extended Events is that it can be complicated to configure going on scripting alone. You need to know what events are available, and how you… Read more