Beginning with today, I want to give you over the next few months a blog post series about the basics of performance tuning in SQL Server. Before we go into the nasty details of performance tuning in SQL Server, I want to lay out today the foundation about how SQL Server executes a query. This …
As we all know there is already a lot of information available about SQL Server related topics in English. But I’m also dealing more and more with customers who want to have some materials available in their native language – in that case in German. Therefore, I’m very pleased to announce that I have released today …
My new Online Training: SQL Server Query Tuning Fundamentals – German Edition + read more
Over the next few weeks I have again some online training and speaking engagements that I want to share with you today: On September 29, I’m speaking at the Future Data Driven online conference about Myths & Misconceptions around Locking and Blocking in SQL Server On October 7, I have an online training about SQL …
My upcoming Online Trainings and Speaking Engagements + read more
After a very long work, a new version of www.SQLpassion.at was deployed last Thursday. It includes a brand-new corporate design, which is much more modern than the older version. I really like the clean new way. Covid-19 has dramatically changed the training business, because everything is currently done online – and I assume that this …
On April 22, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many rows are returned for a given query. Based on that assumption, the Query Optimizer compiles a physical Execution Plan, which is finally executed by SQL Server. The …
SQLpassion Online Training about Statistics & Plan Caching + 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.
