We are four weeks away from the next 24 Hours of PASS event, and the registrations continue to mount. I have participated in all four 24 HoP to date and each one holds a special memory for me. But when all is said and done this coming event has the potential to be my favorite of the bunch.
Past 24 HoP events have been focused on giving viewers a preview of PASS Summit content. The event last Spring was focused on SQL 2008 R2. This event is not a preview. Instead it is simply full of SQL-goodness and I can't wait for it to get started. I'll register, and likely watch, all 24 sessions so it would be hard for me to pick a few favorites that I want to see next month. But here goes anyway:
Tools for troubleshooting performance issues. Best practices around troubleshooting methodology, SQLDiag/PSSDiag, SQL Nexus, Profiler/Trace, and PerfMon. Narrow down a performance problem & focus on where to spend your time.
"Code sins" are those things we do to our code that make stored procedures wish they’d never been created. Learn common code sins that make it difficult to read, support, run and extend.
There are some truly awesome ways to make your data do just what you need it to do, while improving performance and/or readability. Come learn new-school ways to expand your T-SQL repertoire.
This in-depth session covers the internals of indexes including index filtering and partitioning. Walk away with a better understanding of indexes, which is helpful when designing and tuning databases.
If you haven't taken a moment to visit the 24 HoP website and register, what are you waiting for?