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.
An introduction to LINQ covering what it is, why people choose to use it, and how you can help your developers when troubleshooting and performance tuning as you previously did through stored procedures.
With SQL Server you can integrate traditional tools such as SQL profiler and performance monitor to pinpoint problems. With SQL Server 2008, you can control environments using Policy based management and with the Resource Governor. Chris will explore