• 5:30 PM Networking with Food & Refreshments
• 6:00 PM Short Session
• 6:30 PM Long Session
• 7:30 PM Meeting End
The Short Session
Curt Mathews, a Sr. Escalation Engineer from Microsoft Commercial Technical Support, will give us a deep dive on the SQL Server 2012 AlwaysOn causes of Failover Conditions and health checking routines internals.
The Long Session
Ben DeBow will present:
Index Tuning for the DBA
Indexes are like a turbocharger for your queries: they help the engine process queries faster. Without having the right index strategy, you will be stuck managing a SQL Server environment that end users may constantly complain is “too slow.” How do you avoid that situation by knowing which indexes to add or which ones to remove if they are not working—especially if you are not intimate with a particular application’s database? Knowing fundamentals such as baselining performance and proactively monitoring performance are crucial for long-term index maintenance. This session will give you those fundamentals and more to enable you to implement a solid index tuning strategy for your company’s applications.
Ben DeBow is a consultant who works with customers of all sizes on their mission critical applications and SQL Server deployments. His versatility allows him to assist with everything from virtualization and consolidation to schema design, performance tuning, disk architectures, and everything in between. He has tuned and deployed some of the largest and most complex SQL Server solutions in the world. An active member of the SQL Server community, Ben is also an MCDBA, MCSE, and MCITP. He is also the co-founder of SQLHA with Allan Hirt, and can be reached at http://www.sqlha.com