The 1st half of 2013 is almost over, so it’s time to announce my upcoming SQL Server trainings for the rest of 2013. Besides my traditional SQL Server Performance Tuning & Troubleshooting Workshop I have added 2 brand new workshops into the schedule:

DBA Essential Days

Without a Trace – Extended Events in SQL Server

The goal of the DBA Essential Days is to provide in a 2-day long course all the necessary DBA skills that are needed by Accidental or Involuntary SQL Server DBAs. In this course I’m talking about Hardware Selection, Installation, Configuration, Backups & Recovery Strategies, Database Maintenance, Baselining, and Performance Monitoring for SQL Server. This brand-new workshop runs at the following locations and dates:

October 28 – 29 in Zurich/Switzerland

November 11 – 12 in Vienna/Austria

November 25 – 26 in Kontich/Belgium

Further information about the workshop, the detailed agenda, and the registration details can be found here.

Besides the DBA Essential Days I’m also introducing the new 1-day workshop Without a Trace – Extended Events in SQL Server. As you might know, SQL Server Profiler and SQL Trace is a deprecated feature since SQL Server 2012, which means it will go away from the SQL Server product over the next release cycles. The follow-up technology that was introduced with SQL Server 2008 is Extended Events, a new lightweight tracing infrastructure. The goal of that 1-day workshop is to introduce Extended Events to you, describe the architecture, and show you with a lot of different demos and examples how you can migrate from SQL Server Profiler/SQL Trace to Extended Events, and how to do performance troubleshooting with it. I’m running this workshop at the following locations and dates:

October 30 in Zurich/Switzerland

November 13 in Vienna/Austria

Further information about the workshop, the detailed agenda, and the registration details can be found here.

Because of the high demand of high quality SQL Server trainings in Belgium, I’m also running my SQL Server Performance Tuning & Troubleshooting Workshop from November 18 – 22 in Kontich/Belgium (near to Antwerpen). The workshop now runs for 5 days, and includes the 1-day workshop about Extended Events, because troubleshooting SQL Server performance problems without Extended Events is since SQL Server 2012 almost impossible J. You can find further information about the workshop in Belgium here.

I’m looking forward to see some of you at one of the upcoming workshops to share my SQLpassion with you J

SQL First Aid Kit Sign up for free

Here is some feedback

Bob from Zoetermeer, Netherlands

"The SQL Server Query Tuning Workshop helped me as a developer to realize how important a good indexing strategy is for a responsive application. In my opinion every developer, working with SQL Server, should know how the indexes are build up, and how the query optimizer is getting to his query plan."

5.0

2015-01-22T12:38:33+00:00

“The SQL Server Query Tuning Workshop helped me as a developer to realize how important a good indexing strategy is for a responsive application. In my opinion every developer, working with SQL Server, should know how the indexes are build up, and how the query optimizer is getting to his query plan.”

http://www.sqlpassion.at/archive/testimonials/bob-from-zoetermeer/

Roger from Hertogenbosch, Netherlands

"During the workshop I have learned a lot about the query optimizer internals and how I can use that knowledge to write optimal performing queries. Klaus obviously knows a lot about these topics and is able to teach them very well. I can’t wait to attend one of his workshops in the near future."

5.0

2015-01-13T15:28:08+00:00

“During the workshop I have learned a lot about the query optimizer internals and how I can use that knowledge to write optimal performing queries. Klaus obviously knows a lot about these topics and is able to teach them very well. I can’t wait to attend one of his workshops in the near future.”

Thomas from St. Margrethen, Switzerland

"I was lucky enough to attend the 4 day long SQL Server Query Tuning Workshop from Klaus in Zurich. He has presented in a very easy way the performance related internals of SQL Server that will help you to write better performing SQL queries. Based on that knowledge I finally know now why sometimes queries are fast, and sometimes are slow. It was an amazing workshop, which makes the day-to-day work with SQL Server now very easy."

5.0

2015-01-13T15:23:09+00:00

“I was lucky enough to attend the 4 day long SQL Server Query Tuning Workshop from Klaus in Zurich. He has presented in a very easy way the performance related internals of SQL Server that will help you to write better performing SQL queries. Based on that knowledge I finally know now why sometimes queries View Full →

Arun from London, United Kingdom

"My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address performance issues that came up this week in capacity testing."

5.0

2015-01-13T15:19:20+00:00

“My day-to-day writing of SQL has gone up a level – I am able to finely tune individual statements or underlying database objects to get the kind of query plan I want. Moreover I know now what sort of plan I am looking for. I have been already able to use this knowledge to address View Full →

Bernd from Monheim, Germany

"After attending the 4 days long workshop you know very exactly how SQL Server executed SQL queries on the logical and physical level through execution plans. In addition you will know how you can improve queries by applying the right indexing strategy. This in-deep knowledge was very well explained and presented by Klaus."

5.0

2015-01-13T15:22:12+00:00

“After attending the 4 days long workshop you know very exactly how SQL Server executed SQL queries on the logical and physical level through execution plans. In addition you will know how you can improve queries by applying the right indexing strategy. This in-deep knowledge was very well explained and presented by Klaus.”

Ina from Oberhaching, Germany

"Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries and their optimization."

5.0

2015-01-13T15:21:05+00:00

“Anyone faced with the task to implement queries on complex ERP data structures – for reporting, providing views, or for statistical analysis – comes quickly to its limits without knowledge of the operation of SQL Server. The workshop provides an excellent insight into the technical world of SQL Server, explained with many examples of queries View Full →

Filip from Beerse, Belgium

"This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I especially loved the tips he gave on common mistakes and wrong concepts about SQL Server. Such information, coming from an independent expert (“expert” is still very understimated when talking about Klaus’ knowledge), is a lot more valuable than spending hours reading and googling. This training has a high return on investment and anyone who is seriously working with SQL Server should attend this workshop."

5.0

2015-01-13T15:13:34+00:00

“This training on SQL Server performance tuning was extremely interesting. Klaus taught me lot of things I was not aware of. I especially loved the tips he gave on common mistakes and wrong concepts about SQL Server. Such information, coming from an independent expert (“expert” is still very understimated when talking about Klaus’ knowledge), is View Full →

Wim from Heverlee, Belgium

"The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of SQL knowledge we gathered through the years, were properly tied together by Klaus. He provided us with all the necessary knowledge to tackle the performance issues we will surely encounter in our day to day business. Highly recommended!"

5.0

2015-01-13T15:08:29+00:00

“The SQL Server Performance Tuning & Troubleshooting Workshop exceeded the high expectations I already had. All the separate bits and pieces of SQL knowledge we gathered through the years, were properly tied together by Klaus. He provided us with all the necessary knowledge to tackle the performance issues we will surely encounter in our day View Full →

Carla from Heverlee, Belgium

"The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent prepared and documented demos. I definitely will use the knowledge and documentation that Klaus shared with us during the workshop as starting point and guide for my future work."

5.0

2015-01-13T15:10:40+00:00

“The workshop exceeded my expectations! The complete workshop was well structured, all topics were explained very clear with a lot of excellent prepared and documented demos. I definitely will use the knowledge and documentation that Klaus shared with us during the workshop as starting point and guide for my future work.”