PowerPivot can be a great troubleshooting / performance tuning tool for a dba besides just loading all the data in a database and start querying. I'll show the pro's and cons of PowerPivot while trying work with waitstats, profiler data etc.
Brad McGehee, Red Gate's Director of DBA Education, will share his experience of monitoring SQLServerCentral's DB performance what he found, how he did it using SQL Monitor, and how they were fixed. Following that Brian Harris will demo SQL Monitor.
In this session I’ll show you how to maintain security and development rigour whilst allowing the developers to use ORM tools.
Dan Cardno, Idera's Senior Sales Engineer, will focus on the suite of SQL Performance solutions offered by Idera and how they can help anyone tasked with the responsibility of administering SQL server databases.