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 awesome functionality. As you can …
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
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
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: SELECT * FROM Person.Person As you can see this is a …
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 …
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.
