SQL Server UG gets some Solid Quality Learning from Brian Moran
Nearly 80 people showed up to listen to Brian Moran teach the group about using Profiler and SQL Trace to performance tune their database applications. The presentation was fantastic - so much so that I've sent Brian an e-mail asking him how much he costs to give a more indepth class to some of the folks at my company. We need this kind of training! Anyway, back to the UG review. I'll post an update to this entry when the SQL Server UG posts the slide deck to their website. There was way too much detailed info in the presentation to bother trying to sum anything up here. Except for this - whenever you have a database performance issue - the issue is being caused by your application code, not SQL Server itself. Use tools like Profiler and the built in SQL Server performance counters to uncover the real problems. Brian did a great job covering the material and introducing everyone to the correct way to use Profiler.
Many thanks go out to Quest Software who provided the pizza and 40 shirts to the group. The shirts were handed out to everyone who wanted one until they were all gone. David Rodriguez also brought some excellent "Got Spinny" Reporting Services shirts.
Don't forget about the SQL Server Road Show this August 30th at the Cobb Galleria. It costs $99 to get in but if you register with either the banner on the www.atlantamdf.com site or the banner on the www.devcow.com site you'll be working towards earning the SQL Server UG a donation from the SQL PASS organization.
-- Matt Ranlett