Back in 2011 I sat in a session at TechEd Australia where Carolyn Chau showed off a number of the reporting enhancements coming in SQL Server 2012. SQL Server 2012 is a massive release, providing a stack of new features across all aspects of the server . Some of my favourites include things like Availability groups, support for Server core, a new Visual Studio based management to name but a few. I remember coming out of that session excited at the thought of plugging in the Project Server reporting database and seeing what it could do.
Fast forward to March this year and Microsoft officially confirmed that SQL Server 2012 was supported for SharePoint and Project Server SP1 upwards, so what better time to spin up a farm and give it a whirl?
So coming up in the next two posts I am going to look at two of the new Reporting Services features and how they can be leveraged in your Project Server farms. In the first post we are going to look at SQL Server Reporting Services Data Alerts and in the second, PowerView (formerly known as Project Crescent).