(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email all the essential knowledge you need to know about performance tuning on SQL Server.)
The summer goes by and in a few weeks the conference season starts over again. The last weeks were a little bit stressful, but now I had finally some time to prepare my sessions for upcoming SQL Server conferences, where I’m speaking over the next months.
24 Hours of PASS, September 12
At this online event (http://www.sqlpass.org/24hours/fall2012) I’m doing one session titled “Fast your Seatbelt – Troubleshooting the hardest SQL Server Problems“. I’m talking here about things like Thread Pool Starvation, Spinlock Contention, and VMware Memory Balloon Driver issues – expect to be this a Level 400 session.
SQLdays, September 20 – 21, Rosenheim/Germany
At this German speaking conference (http://www.sqldays.net) I’m doing 3 sessions about various SQL Server topics:
- Troubleshooting SQL Server with Extended Events
- Fast your Seatbelt – Troubleshooting the hardest SQL Server Problems
- Migrating to SQL Server 2012 AlwaysOn
PASS SQLRally Nordic, October 1 – 3, Copenhagen/Denmark
It’s my first time that I’m speaking at a SQLRally event (http://www.sqlpass.org/sqlrally/2012/nordic), and I’m really looking forward going to Denmark – I’ve never been there! In Copenhagen I’m presenting one session about Troubleshooting SQL Server with Extended Events.
SQLPASS Summit, November 6 – 9, Seattle/USA
It’s now my 6th SQLPASS Summit where I’m presenting (2006, 2007, 2008, 2010, 2011, 2012) and I’m really proud to be able to do a day long precon about Practical SQL Server Performance Troubleshooting. In this precon I’m using a TPC-E workload to generate an initial baseline for performance improvements, and over the day I’m showing various techniques to improve SQL Server performance. But read yourself through the precon abstract:
Learn how to configure the Windows OS, SQL Server, and your database for optimal performance. In this pre-conference workshop, we’ll start by taking a default installation of SQL Server and running an OLTP workload with several hundred users to generate our initial baseline for performance tuning and troubleshooting. Throughout the day, we’ll work with various areas of SQL Server to implement different performance optimizations and then see how those changes impact the throughput of our initial test workload. At the end of the day, we’ll have a well-performing SQL Server that can handle a much larger workload than the initial (default) installation.
Topics for the day include:
• Windows OS settings
• Storage configuration
• SQL Server instance settings
• Database settings
• Index and statistics maintenance
• Locking, blocking, and deadlocking
• Memory management
Besides the precon I’m presenting the following 2 regular conference sessions:
- Advanced SQL Server Troubleshooting
- ColumnStore Indexes – the Turbobooster in SQL Server 2012
Besides all this conference engagements, I’m also running my “SQL Server Performance Tuning & Troubleshooting Workshop” in Austria, Germany, Switzerland, and Ireland! See http://www.SQLpassion.at/events.html for further details. You can also expect some new SQL Server Quickies over the next weeks at my YouTube channel: http://www.youtube.com/user/sqlpassion. Autumn 2012 will be a very busy for me (the same as last year), and I’m looking forward to see you at one of these great SQL Server events!
Thanks for reading