Today I want to talk about a specific kind of index in SQL Server: Filtered Indexes, which were introduced back with SQL Server 2008 – so already very long time ago. A Filtered Index is a traditional Non-Clustered Index, which includes a Filter Predicate that restricts the rows that are ...

As you might know from my Home Lab setup, I’m a big believer and fan of VMware vSAN, which is a Software-Defined Storage solution. Therefore I want to show you in today’s blog posting a step-by-step guide how you can create a vSAN based vSphere Cluster. For a basic understanding ...

Todays blog posting is a little bit more personal than technical. It seems that I don’t have that much luck this year, because since Sunday evening I have a broken right foot 🙁 I don’t want to go into the details about how it happened, but in the first step ...

In today’s blog posting I want to talk about Query Memory in SQL Server, and want to show you how fast it can degrade the performance of your queries. Before we dive into the details about how SQL Server is managing Query Memory, I want to talk briefly about what ...

In today’s blog posting I want to give you a brief overview about my upcoming Speaking Schedule, and where you can meet me physically and virtually. From October 8 to 11 I’m speaking at the SQLdays Conference in Erding/Germany (near Munich). I’m giving here 2 full-day workshops and 2 regular ...