Database Administration & Monitoring

SQL Server Security: Check if the guest is active on all user-databases through the CMS

Today, a customer asks me to have look on each SQL Server instance to control if the user-database Guest is active or not. The easiest way is to go through the CMS (Central Management Servers) with a query but witch(…)

A few words about the good to know MAX_IDLE_BLOCKER_TIME

The increasing popularity of tools like SQL Developer and Toad, sometimes comes hand in hand with an increase of stuck sessions.This is especially seen in cases where: User A does a change (neither committed nor rolled back). Then, switches to(…)

Power BI – Active Directory data integration

Introduction This documentation explains how to integrate Active Directory data in a Power BI report. It explains also how to link this data with another data source. To illustrate the method, we will integrate Active Directory Computer data and link(…)

In which schema do temporary tables go in PostgreSQL?

As you might know, you can create temporary tables, views and sequences in PostgreSQL. Temporary means, that the temporary table, view or sequence will be dropped when you either end your session or you transaction. When the drop will happen(…)

Contained Availability Groups error

During my testing about the new SQL Server 2022 feature Contained Availability group I faced an issue during the creation of the system databases on the secondary instance. I used the wizard to create a new Contained Availability Group and(…)

Get SQL Server database size with PowerShell

Introduction For various reasons, following the evolution of the data size of databases is interesting for a dba or for the application team. Most of the time, this is something built-in for monitoring tools – convenient to follow the evolution(…)

Reminder about SSMS

As you know, since SQL Server 2016, SQL Server Management Studio is not anymore part of the SQL Server ISO files and needs to be downloaded independently. If you want to have a complete list of all SSMS versions please(…)

A 7 year journey, my longest employment ever

It has been an amazing ride: 1st of May 2022 I have been with dbi services for exactly seven years. This is by far the longest employment in my career. When I started way back in 2015 most of my(…)

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(…)