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

-Klaus