Abstract: Analysis of your SQL Server like a PRO

SQL Server is a mission critical database platform but is sensitive to misconfigurations, bad practices, sub-optimal indexing strategies and poor coding mistakes. Even the fastest hardware can end up performing like a ZX-81 if you get things wrong.

If you are a Database Administrator or Consultant who is responsible for expert performance analysis, problem detection and tuning of the SQL engine then it is important you are able to analyse and tune SQL Server like a BOSS.

In this full training day, I will explain how to identify and resolve serious real world performance problems using concrete examples, demonstrations, possible effects and answers. This workshop will provide over 40 scripts which can be used directly in the workshop on your own machines during the day and we shall simulate performance problems and look to resolve them using a top-down approach.

A selection of things you can look forward to learning and experiencing during the day are:

• Waits and Queues methodology
• Instance and database level configuration
• TempDB importance and optimization
• Index Analysis and tuning
• Humour (yes Germans can be funny too!)

SQL Server Versions:

2008 / 2008R2

2012 / 2014 / 2016

Biography Uwe Ricken

Uwe Ricken is working with IT systems since the 90’s. He found the way to the technology of Microsoft SQL Server with the assignment for the development of membership administration software for the American Chamber of Commerce in Germany. After the development the software has been distributed to five additional European countries. The primary passion for developments with Microsoft SQL Server expanded in 2007 with his engagement as a DBA for the Deutsche Bank AG in Frankfurt am Main. After 6 years of operational experiences as a DBA and over 14 years as a developer of complex database models he earned in May 2013 the “Microsoft Certified Master – SQL Server 2008” certification which “was” the highest technical certification by Microsoft. The successful year 2013 has been finalized with the first MVP award for his outstanding support to the Microsoft SQL Server community in Germany and Europe. Uwe Ricken was the first MCM + MVP in Germany!

To provide his deep knowledge about Microsoft SQL Server to the interested community Uwe Ricken is blogging since 2010 at http://www.sqlmaster.de about his daily experiences with Microsoft SQL Server. His blog posts are in German language only to provide the German speaking SQL community enthusiasts deep inside views into the technology of Microsoft SQL Server.

Uwe Ricken is a speaker on many international conferences and events and preferred topics for “Database Internals”, “Indexing” and “Development”.

Additional information
Lunch, snacks coffee etc are included. Registration for the free SQLSaturday event on September 30th must be done through the SQLSaturday #666 Holland website.