During the current week I have spoken at 2 SQLrally conferences, once in Stockholm/Sweden, and once in Amsterdam/Netherlands. At both conferences I have presented my brand-new session titled “How to measure Index Impact Changes”. The goal of the session is very easy: imagine you want to change your Indexing Strategy in for your production system, …
My SQLrally Session about how to measure Index Impact Changes + read more
Time flies by, and the year 2013 is almost over for me. So it’s time to announce the course schedule of the SQLpassion Academy for the next year. I’m running in March 2014 my SQL Server Performance Tuning & Troubleshooting Workshop across 4 different locations in Europe. Besides the usual locations I’m also running my workshop …
Announcing the SQLpassion Academy 2014 Course Schedule + read more
Cardinality Estimation is one of the hidden gems in SQL Server. In general, Cardinality Estimation means that the Query Optimizer tries to find out during the query compilation, how many rows – on average – are returned from the various operators in the Execution Plan. This estimation is used to drive the plan generation itself …
Fixing Cardinality Estimation Errors with Filtered Statistics + read more
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 …
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 …
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.
