SQLServer

Does a Query always wait in the SUSPENDED State?

In today’s blog posting I want to talk about a very interesting topic: in which execution state is a query waiting on “something”? By definition we can all agree that a query always waits in the SUSPENDED state. But this behavior is not really true. So let’s talk about it… Query Life Cycle Every time …

Does a Query always wait in the SUSPENDED State? + read more

SQLpassion Online Trainings in June 2018

Today I want to announce my SQLpassion Online Training for June 2018. On June 21, 2018 I’m running a one-day long webinar about SQL Server Troubleshooting with Extended Events. And because of the huge success of my brand new training Design, Deploy, and Optimize SQL Server on VMware, I will rerun that training again from …

SQLpassion Online Trainings in June 2018 + read more

How I designed my VMware vSAN based Home Lab

As you might know, I have already a quite powerful mobile Home Data Center that I have built in November 2016. I’m primarily using that Lab environment to showcase SQL Server environments through my various SQL Server workshops that I offer. But over the last year I was also more and more involved with virtualization …

How I designed my VMware vSAN based Home Lab + read more