SQLServer

Automatic Seeding in Always On Availability Groups in SQL Server 2016

Over the last few weeks I have done a lot of work in the area of Always On Availability Groups, and therefore I had also the chance to test drive the Automatic Seeding option that is available beginning with SQL Server 2016. In today’s blog posting I want to give you an overview about what …

Automatic Seeding in Always On Availability Groups in SQL Server 2016 + read more

SQLpassion Workshops for Fall 2017

Time goes by, and today I’m very proud to announce all upcoming SQLpassion workshops for the second half of the year 2017: SQL Server Query Tuning Workshop November 6 – 10 in Antwerpen/Belgium SQL Server Performance Tuning Workshop November 20 – 24 in Zurich/Switzerland December 4 – 8 in Frankfurt/Germany Read here how it feels …

SQLpassion Workshops for Fall 2017 + read more

Tracking Lookup Operations in SQL Server

Last week during my SQL Server Performance Tuning Workshop I got quite an interesting question regarding Bookmark Lookup Operations against Clustered Indexes: “How can I find out on which Clustered Index I have the most Lookup Operations performed?” The great thing about SQL Server is that SQL Server logs a lot of information in the …

Tracking Lookup Operations in SQL Server + read more