SQLServer

Moving a SQL Server Availability Group to a different Subnet

Over the last few days I have reworked my home network design, and introduced a new subnet for all my SQL Server based VMs that are running in my VMware vSAN powered Home Lab. In this blog posting I want to describe the various steps that are necessary to move a SQL Server Availability Group …

Moving a SQL Server Availability Group to a different Subnet + read more

The unwanted Side Effects of enabling Read Committed Snapshot Isolation

A lot of developers are approaching me very often, and tell me that they are using the NOLOCK query hint to get rid of blocking situations in SQL Server. Unfortunately the NOLOCK query hint is not really a good solution when you hit blocking situations, because SQL Server can return you uncommitted data. Therefore I …

The unwanted Side Effects of enabling Read Committed Snapshot Isolation + read more

SQLpassion Online Trainings for Fall 2018

Today I’m quite happy to announce my SQLpassion Online Trainings for the remaining year. Currently I have scheduled the following online trainings: SQL Server Query Tuning Fundamentals Design, Deploy, and Optimize SQL Server on VMware SQL Server in the Cloud SQL Server Performance Troubleshooting Hands-On Labs As you can see from this list, I have …

SQLpassion Online Trainings for Fall 2018 + read more

What is an Event-Less Extended Event Session?

Do you have ever heard about an “Event-Less” Extended Event Session? What is the idea about it? Why do you want to have an Extended Event Session without any events? Let’s talk about it… Event Less When you create an Extended Event Session in SQL Server, the definition of the Event Session specifies which Events, …

What is an Event-Less Extended Event Session? + read more