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

Bucketing Values in DAX

Let’s say I wanted to analyze query performance on my SQL database. I have a log that has all the queries, the time it took them to run and the total records that were returned. I want to look at how the size of the results impacts the performance of the queries. I pull my… Read more

Released: Management Pack for SQL Server Analysis Services 2008 and 2012

This week, we released Management Packs for SQL Server 2008 and 2012 Analysis Services. The corresponding downloads are available at:   System  Center Management Pack for SQL Server 2012 Analysis Services   System  Center Management Pack for SQL Server 2008 Analysis Services These Management Packs deliver proactive and reactive monitoring capabilities for SQL Server Analysis… Read more

SQL Server Data Tools – Business Intelligence (SSDT BI) for SQL Server 2014 CTP1

In this pre-release version of SQL Server 2014, SSDT BI is no longer included in setup. For SQL Server 2014 CTP1 no new version of SSDT BI been released, however you can use the existing version of SSDT BI to create and deploy projects for SQL Server 2014 CTP1. The Visual Studio 2012 version of SSDT… Read more

Released: Kerberos Configuration Manager for SQL Server

Kerberos Configuration Manager for SQL Server (KerberosConfigMgr) was released on May 15th 2013, and is available for download at the Microsoft Download Center at http://www.microsoft.com/en-us/download/details.aspx?id=39046. This diagnostic tool can help to troubleshoot Kerberos-related configuration issues with SQL Server, which is very exciting for us because Kerberos authentication plays a critical role in many BI-related authentication… Read more

Refreshing PowerPivot Data in SharePoint 2013

In SharePoint 2013, Excel Services comes with numerous improvements. One of the most significant for PowerPivot is the ability to refresh data models interactively all the way from the original data sources. Unlike Excel Services in SharePoint 2010, which only queries data models but doesn’t refresh them interactively, Excel Services in SharePoint 2013 first sends… Read more