SQL Server

First look at SQL Server 2022 Contained Availability Groups

Introduction SQL Server 2022 introduces the new concept of Contained Availability Groups. This is something that DBAs have been waiting for since Availability Groups were introduced 10 years ago. Contained Availability Groups enhance the Availability groups by providing the(…)

SQL Server 2022 Parameter Sensitive Plan optimization

Introduction The Intelligent Query Processing (IQP) feature family is extended with SQL Server 2022.One of the most anticipated features is the Parameter Sensitive Plan optimization. I started to test this new feature. In this post, you will find some(…)

SQL Server 2022 public preview available

This is a small blog post to share that the SQL Server 2022 public preview is available for download. The Microsoft announcement blog post and a summary of the new feature are available here : Announcing SQL Server 2022(…)

SQL Server: Find who forced a plan in Query Store with this new XEvent

The latest Cumulative Update for SQL Server 2019 has been released this week on Monday. It brings many bug fixes and some small improvements. One of these improvements is the addition of an extended event to identify the(…)

SQL Server: Automatic Soft-NUMA and uneven CPU load

SQL Server has CPU limitations depending on the Edition. If your VM is not configured properly you can reach these limits very easily. In a previous post, I described the effect VM misconfigurations can have on performance because not(…)

Striim, real-time data integration

In my first blog-post about Striim, I showed you how to create an Initial Load from an on-premise database to an Azure SQL DB. In this second blog post I will create an application which will stream Data(…)

Striim, first step

In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud(…)

SSDT offline installation for Visual Studio 2019

Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was(…)

How to solve Stored Procedure parameter sniffing problems

Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest(…)

SQLBits 2022 – Levelling up my Performance Tuning skills

As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022.