Never had the time to learn DAX? Now is the time! Author Owen Duncan just released a DAX 101 course as part of the DAX Resource Center Wiki to help you learn DAX basics quickly and efficiently. The title says you can do this in 30 Minutes, but don’t...

This article is a follow-up on a previous blog post titled “ How to Build a VSTO-Based PowerPivot Workbook ,” which discussed some of the advantages and disadvantages of building PowerPivot workbooks by using VSTO. A key VSTO advantage is...

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...

Today, we’ve reached the next big milestone on the road to unlocking breakthrough insights across organizations with a cloud-ready information platform—we released Microsoft SQL Server 2012 RC0 ! You can find the installation media at the...

I am very pleased to announce that the DAX Editor for SQL Server has been released to CodePlex for general use. It is available at http://daxeditor.codeplex.com/ . Thank you Nick Medveditskov, Karen Aleksanyan, and Sergey Volegov for your hard work in...

A few weeks back, the SQL Server connectivity team announced on their blog that the SQL Server OLE DB provider is being deprecated and recommended that developers adopt ODBC instead. You can read the blog post in detail here . There has been some concern...

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...

Last week I came across a stunning PowerPivot solution that visualizes research data on top of a world map, as illustrated in the following screenshot. What’s particularly stunning about this solution is that it works even in the browser despite...

Looking for datasheets, white papers, click-through and auto-running demonstrations, hands-on lab previews, technical presentations, and other useful links to evaluate SQL Server Code Name 'Denali' CTP3? Go to the Microsoft Download Center and search...

A few AS team members have started blogging on Denali functionality at their personal blog sites. Cathy Dumas, a Program Manager on our team, is just warming up on her blog . She’s got a couple of interesting posts: Tabular designer architecture...