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 …
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 …
How to become a better, well-rounded SQL Server DBA + read more
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.
