SQLServer

Data Pages – the Foundation of SQL Server

Last week we laid out the foundation for how SQL Server executes queries. I have also already talked here a little bit about pages that are buffers of 8kb. Today we concentrate further on these pages and drill into more detail and what it means from a performance tuning perspective. Pages are the foundation of …

Data Pages – the Foundation of SQL Server + read more

My new Online Training: SQL Server Query Tuning Fundamentals – German Edition

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

My upcoming Online Trainings and Speaking Engagements

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