Last week VMware has released a new whitepaper with the very promising title “Architecting Microsoft SQL Server on VMware vSphere”. If you have a virtualized SQL Server running on top of VMware, this whitepaper is a MUST READ for you!!! I’ve read through the whitepaper over the last few days, ...

During one of my last Online Trainings about Extended Events, someone asked me about the Service Broker Target that Extended Events offers. To be honest, I had really no idea about this. So I had to check that target out, because in combination with Service Broker this would be an ...

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 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 ...

In today’s blog posting I want to talk about a quite simple question in SQL Server: is a SELECT statement always executed? The question itself seems to be quite easy, but the answer to it isn’t that simple. Let’s look at the following example: [crayon-5ba69a429b6c2812563028/] As you can see this ...