While there is a lot of deserved and great interest with Power View, almost forgotten is the IT workhorse SQL Server 2012 Reporting Services for your corporate / managed reporting infrastructure. For great references on SQL Server 2012 Reporting Services, my suggestions include:
- What’s New In SQL Server 2012 Reporting Services
- SQL Server Reporting Services Team Blog
- Robert Bruckner’s Reporting Services and Power View Blog – Principal Architect within SQL Server Reporting with excellent insight into both Reporting Services and Power View.
In my former life, I had worked on some pretty complex Reporting Services customer projects. While these references are for SQL Server 2008 | 2008 R2 Reporting Services – the concepts remain the same.
To dive deeper into some of the above concepts, please check out the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series that I had written on sqlcat.com.
- Reporting Services Scale-Out Architecture
- Report Server Catalog Best Practices
- Reporting Services Scale-Out Deployment Best Practices
- Reporting Services Performance Optimizations
As well, an important case study concerning Reporting Services disaster recovery is SQL Server Reporting Services Disaster Recovery Case Study that I had co-written with Ayad Shammout (@aashammout).
Enjoy!