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

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

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

Poster Download: Microsoft Business Intelligence at a Glance

Over recent months, we had a lot of fun creating a Microsoft BI poster for SQL Pass and SharePoint Conference. As the title suggests, the poster shows the most important technologies in the Microsoft BI stack at a glance, arranged in various layers from the data sources all the way up to the client applications… Read more

Tabular Database PowerShell CmdLets available on CodePlex

JuanPablo just released an interesting cmdlet library to manage Tabular Models using PowerShell. It builds on the Tabular Model with AMO project, which JuanPablo introduced a few months ago in his blog article Creating a Tabular Model with AMO – New Version SQL 2012. So there you have it! Go to http://tabularcmdlets.codeplex.com, download the compiled… Read more

SQL Server Analysis Services and Big Data

Over the past few weeks, I had an opportunity to work with colleague Denny Lee and David P Mariani (VP of Engineering, Klout) on a very interesting Big Data story about how Klout.com takes advantage of Analysis Services. Klout analyzes massive amounts of social network user data to measure the impact of opinions, links, and… Read more

Understanding Analysis Services Deployment Modes

SQL Server 2012 Analysis Services (SSAS) supports three different deployment modes: Multidimensional, Tabular, and SharePoint. You can choose the deployment mode during Setup, as the following figure illustrates. The SharePoint deployment mode is implicitly chosen on the Setup Role page when you install PowerPivot for SharePoint. Multidimensional and Tabular modes, on the other hand, can… Read more

Whitepaper and Samples Released: Data Analysis Expressions (DAX) In the Tabular BI Semantic Model

Happy New Year 2012, everybody! With the release of SQL Server 2012 ante portas, this is going to be a very exciting year. So, let’s start this year with a release announcement: An updated version of the whitepaper “Data Analysis Expressions (DAX) In the Tabular BI Semantic Model” is available for download at http://go.microsoft.com/fwlink/?LinkID=237472&clcid=0x409. Authors… Read more

About the Relativity of Large Data Volumes

Some conversations in our team are really priceless. The other day, while working on an article about Analyzing Performance Data in PowerPivot, I was bragging to Ashvini about the fact that I was able to import a 55 GB database with more than 200 million rows of data into a 1 GB PowerPivot workbook, as… Read more

Released: Denali CTP3 Samples and TechNet Wiki

This was a big announcement week for us. Let’s finish it with a note about our new Denali CTP3 samples. JuanPablo already introduced the AMO sample in his Creating a Tabular Model with AMO blog post, but wait there’s more: SQL Server Samples Readme on the TechNet Wiki   Ties all samples together and provides step-by-step installation… Read more