TFS 2013 – Agile Portfolio Management

Brian Harry announced the launch of TFS 2013 to be scheduled at Build conference this year and some of the features are included for Preview in Team Foundation Service. I have been using Team Foundation Service for my talks at SQL Saturdays on “Agile BI” and noticed the new changes well ahead of my presentation for SQL Saturday #226 in South Florida.

This post is to introduce some of the new features that have been built into TFS 2013 in relation to the Agile Portfolio Management or Epics as Adam Cogan states in his blog.

The first thing you would notice in the Backlog page are the different levels of backlog. This is clearly to distinguish the granularity of a feature / task for diferrent people in an organisation. A business stakeholder would be more interested in a feature that is being developed while a business analyst would be keen to track the progress of user stories. Also notice the colour coding that has been used for different levels of backlog which makes it even more easier to track the work items.

TFS 2013 - Feature-Stories

On the top right corner, drilldown view options (from features to stories to tasks) are available for selection. This allows you to add user stories under features (or) tasks under user stories from the same page (Notice the green plus sign next to the feature / user story)

TFS drilldown

TFS plus

Board supports all levels of backlog and allows you to track the items under features and user stories separately (The same colours are used for items on the board).

TFS Board

On the TFS Dashboard page, there is a new addition of the Team Rooms tile by default. I will post more about Team Rooms after I try it out with the official release of TFS 2013.

TFS dashboard

Happy Stories!


SSAS Tabular Model – Validate partition query bug

I encountered this unexpected bug while creating multiple partitions for a table in my SSAS Tabular model. While authoring the model in SSDT (Visual Studio 2010), I created two partitions for a given table to split the processing for a large dataset. After entering the query for the second partition, the validation check failed with the error “Object reference not set to an instance”.

There is a Microsoft Connect bug opened for this issue here.

You can also read more about this on the Technet thread here.


SQL Saturday #226 in South Florida, USA

I am excited yet again as I will be speaking at SQL Saturday #226 in sunny South Florida, USA. I will be speaking in the BI and Reporting Track in the afternoon. If you are from the South Florida region, please don’t miss out on this exclusive training day on everything SQL Server.

The event schedule is listed here.



Update: I had a great time speaking at Fort Lauderdale, Florida. Below is a farewell photo with other speakers (happy faces)

SQL Saturday South Florida Speakers