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

Evaluating Shared Expressions in Tabular 1400 Models

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

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

Introducing a Modern Get Data Experience for SQL Server vNext on Windows CTP 1.1 for Analysis Services

Starting with SQL Server vNext on Windows CTP 1.1, Analysis Services features a modern connectivity stack similar to the one that users already appreciate in Microsoft Excel and Power BI Desktop. You are going to be able to connect to an enormous list of data sources, ranging from various file types and on-premises databases through… 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

Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 4 (CTP4)

Last Thursday, we released SQL Server 2012 Service Pack 1 (SP1) CTP4. Both the Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. While CTP3 was primarily targeted at introducing the BI functionality for Office 2013 Preview and SharePoint 2013 Preview, CTP4 covers SQL Server functionality across the board…. Read more

Verifying the SharePoint 2013 Configuration for Accessing Workbooks as a Data Source from Within the Farm

My previous blog post, “Verifying the Excel Services Configuration for PowerPivot in SharePoint 2013,” discussed steps to verify that Excel Services can load workbook data models on an out-of-farm PowerPivot server running SQL Server 2012 SP1 CTP3 Analysis Services (SSAS) in SharePoint deployment mode so that users can enjoy full workbook interactivity in the browser…. Read more

Introducing the BI Light-Up Story for SharePoint 2013

Ideally, you can find the Microsoft BI stack in every SharePoint farm across the enterprise so that users can seamlessly share their BI solutions with each other. In the real world, however, BI is only one of many SharePoint scenarios, albeit a mission-critical one. It is not uncommon for IT organizations to deploy multiple farms… Read more

Announcing Microsoft SQL Server 2012 Service Pack 1 (SP1) Community Technology Preview 3 (CTP3)

Last week, we released the public CTP of Microsoft SQL Server 2012 Service Pack 1. For most SQL Server components, SP1 is just a collection of patches and bug fixes, but for Business Intelligence scenarios, SP1 is much more than just a service pack. SQL Server 2012 SP1 CTP3 is specifically released to accompany the… Read more

Exploring the PowerPivot for SharePoint Configuration Tool

The PowerPivot Configuration Tool included in SQL Server Code Name “Denali” CTP3 is undoubtedly a great new utility for SharePoint administrators. This tool doesn’t just enable you to configure or upgrade PowerPivot in a SharePoint farm. It takes PowerPivot configuration to a whole new level. Here are some key improvements in comparison to what’s available… Read more