My upcoming Speaking Schedule

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Over the next weeks and months I have a lot of various speaking engagements where I’m talking about various aspects of SQL Server Performance Tuning & Troubleshooting.

SQLSaturday #258, Istanbul/Turkey, October 5

It’s the first time that I’m in Istanbul, and even in Turkey, so I’m really looking forward to this event. I’m presenting here my famous “Advanced SQL Server Troubleshooting” session, where I’m talking about some advanced concepts and problems in SQL Server, and how you can troubleshoot them very easily with the tools and techniques provided by SQL Server.

SQLSaturday #260, Milan/Italy, October 8

Almost directly after Istanbul I’m flying to Milan in Italy where I’m presenting a session about Hekaton/XTP (Extreme Transaction Processing), the new In-Memory technology provided by SQL Server 2014. I will talk here about the challenges that we are facing currently in traditional databases like SQL Server, and how these problems can be solved by an In-Memory technology like XTP/Hekaton. 

SQLRally Nordic Stockholm/Sweden, November 5 – 6

It’s my 2nd time that I’m invited to speak at SQLRally Nordic. Last year I have presented in Copenhagen about Extended Events, and this year in Stockholm I’m talking about how you can measure the impacts when you are changing your Indexing Strategy. Imagine you are adding a new Index, and then you want to know which queries are now faster (mainly your read workload), and which queries are now slower (mainly your write workload). I will show you here a proven technique that I’m already using for several years very successfully when I’m working on Indexing Strategies for my customers.

SQLRally Amsterdam/Netherlands, November 7 – 8

Immediately after SQLRally Nordic I’m flying directly to Amsterdam for the 2nd SQLRally in this week, where I’m speaking about the same subject as in Stockholm: Index Impact Analysis.


I’m very proud that I have been invited to SQLRelay, which is a community oriented conference in the UK, which takes place at several cities across the whole country. I’m presenting here in Norwich (November 27), Bristol (November 28), and finally in London (November 29). The topics itself are not determined exactly by now, but again I will deliver some sessions about performance tuning and troubleshooting. So stay tuned :-)

SQLpassion Academy

Besides all these events, I’m also running my own various SQL Server Workshops around Europe in November. You can find further information about them on the SQLpassion Academy website. If you are a member of the Belgium SQL Server User Group, please indicate this during your registration for my SQL Server Performance Tuning & Troubleshooting Workshop, because you are eligible for a 10% discount!

And, if you can’t attend any of these in-person events, I highly recommend my new SQLpassion Online Academy, where I’m providing High Quality Online Video Trainings with Instant Access to you. Till the end of September 2013 you can also buy 3 online videos for the price of 2 – so don’t wait too long!

If you are attending one of these events, leave a comment, and let’s try to meet each other in person!

Thanks for reading & I’m looking forward to see you at one of these events in-person or even virtually :-)


Do you like this post? Why not share it with the SQL Server community?

Announcing the SQLpassion Online Academy

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Do you have enough from watching online Web Casts about SQL Server with a bad video quality? Do you have enough from looking a whole hour on a massive amount of PowerPoint slides? Do you have enough by just hearing the presenter in the background through a bad audio quality? Do you want to attend my famous SQL Server Workshops, but you are not able to join them physically? With the SQLpassion Online Academy you will get:

  • HD Quality SQL Server Trainings, directly accessible on your PC, Mac, Tablet, and Smartphone!
  • Learn about SQL Server where and when you want!
  • A good mixture of PowerPoint Slides, intensive Flip-Chart Sessions, and Demos within SQL Server Management Studio
  • Immediate download of all the Slides & Samples!
  • 24/7 online access to the bought courses, up to 12 months!
  • The trainings are presented by Klaus Aschenbrenner, a Microsoft Certified Master for SQL Server 2008. Your learning success is guaranteed!
SQLpassion Online Academy

To get a tasting and feeling about our offered Online Courses, and our Training Approach, visit our Youtube Channel, where you can watch our free SQL Server Quickies. If you want to see a short introduction video, that shows you how easy it is to signup and watch a bought SQLpassion Online Academy Course, you can watch our How-To Video.

By today I’m offering 3 training videos, that you can also buy until September 30 in a bundle where you are getting 1 video just for free!

You can find further information about the SQLpassion Online Academy on my website, where you can also watch a Promotion video for every offered video.

Thanks for reading & enjoy learning about SQL Server in a completely new, unique fashion!


Do you like this post? Why not share it with the SQL Server community?

How to become a better, well-rounded SQL Server DBA

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

People are sometimes asking me, how to become a better, well-rounded SQL Server DBA. Of course, the first reason with which I’m responding is “Experience, Experience, Experience”. Nothing helps you more than a daily experience with SQL Server. But on the other hand you also need to know how SQL Server works internally, how you can attack performance related SQL Server problems, and how to troubleshoot worse performing SQL Server installations. For that reason I’m providing with my company SQLpassion high quality SQL Server Workshops across Europe, with the goal to make YOU a better, well-rounded SQL Server DBA!

I want you!

Besides the deep technical information about the internal working mechanism of SQL Server, the workshops are also flooding you with a huge amount of demos and approaches how to troubleshoot, and finally resolve SQL Server related performance problems. Approaches that I’m using on a daily basis in my various consulting engagements to hunt down SQL Server performance problems. People are also describing the information flood during the workshops like drinking continuously from a fire hose :-)

Here are some feedbacks from previous attendees over the last years:

  • “I have learned throughout the workshop more than in my whole SQL Server life!”
  • “The workshop was like listening to a story, not just technical info. Even though it was demo based it had practical and application real-world applications.”
  • “Although I already knew a lot of the principles that was gone over, I also learned a lot that I did not know. It will be good to take the additional knowledge back to work and see if I can improve our production environment.”
  • “Klaus provided plenty of information and techniques for SQL Server performance troubleshooting that are not evident in standard SQL Server training and from available online information.”
  • “My notes have a bunch of TODOs for follow up research and implementation. Mostly it’s a bunch of settings to check and probably tweak to suit our environment, but I also found a couple new tools to check out.”
  • “Baselining is the key to troubleshooting. Solving a problem can lead to more opportunities and sometimes solving problems can create more problems, without a baseline you’ll never know.”

If you also want to try the experience about how it is to drink continuously from a fire hose to become a better, well-rounded SQL Server DBA, visit my SQLpassion Academy website, where the various workshops are listed, that I’m running over the next months in Europe. And if you want to get a tasting about my workshops, I also highly recommend to watch my various free videos available on my Youtube Channel.

I’m looking forward to see you & thanks for reading


Do you like this post? Why not share it with the SQL Server community?