Late August 2010 PASS VC Presentations
Writing a better Where Clause
August 24th 8:00 AM EDT (GMT -4)
Presenter: Scott Gleason
This session will cover the basics of writing optimized query’s with focus on the ‘where clause’ and ‘having clause’ of a select statement. If you have never attended a query performance session before, you’ll learn a lot!
Scott has worked in Jacksonville Florida exclusively as DBA for over nine years. He is currently the Vice President of the Jacksonville SQL Server Users Group (JSSUG) and actively speaks about SQL at SQL Saturdays and Code Camps.
How do I view the presentation?
Attendee URL: Live Meeting Link
SQL Storage for Performance: Best Practices
August 25th 12:00 AM EDT (GMT -4)
Presenter: Amy Styers
SQL Storage Planning for Best Performance What are the different storage optimizations available for SQL server? What are some techniques that can be used to determine performance bottlenecks? Amy will discuss tips and tricks from the field on how to answer these questions for planning and designing your SQL infrastructure from disk up!
Amy is a Microsoft Infrastructure Architect in the EMC Commercial Solutions Advisory Group where she has been engaged for the last three years discussing with customers their options for highly available, highly scalable, high performing Microsoft applications. She regularly addresses customers with regards to their virtualization initiatives and helps customers make decisions regarding architecting their Microsoft infrastructures both in physical and virtual environments.