Database Administration & Monitoring

SQL Server: How to compare Server and Database Collation

Sometimes during an SQL Server audit, I check the collation of the server and the databases but every time separately. The goal of this blog is to give you a script to have both and compare it. First step(…)

SQL Server: Analysis of SCOM Warning on the Health Check

Sometimes, it’s hard to find how to analyze a Warning in the SCOM Interface and correct the problem. By a customer, we install new instances in SQL Server 2019 and change the version of SCOM. All new servers have a(…)

SQL Server Tips: Get back permissions lost for mount points!

Recently by a customer, we are facing the case to lose all mount points on a secondary node in a HA SQL Server AlwaysOn infrastructure due to a big problem on the Datacenter. We need to build from scratch(…)

Patroni on FreeBSD 13?

You can already find several blog posts around PostgreSQL protected by Patroni on our blog. They all have in common, that the setup is on a flavor of Linux. As I got impressed by(…)

Automate restore from Rubrik with PowerShell

One of our customer uses Rubrik as a solution to recover, manage, and secure all their data. In this context, Rubrik is used to backup and restore all the SQL Server instances. We need to run restore tests(…)

Why is the default postgres database slightly larger than template1?

You probably know that a fresh initialized PostgreSQL cluster comes with three databases by default: template0, template1, and postgres. If you want to know why they are there, and what their purpose is, check this post. In(…)

PostgreSQL, pg_ctl and signals

I believe most people use pg_ctl nowadays to start, stop, or restart a PostgreSQL instance. You can do all these tasks without using pg_ctl, but you'll notice in a minute that pg_ctl really is your friend. Even(…)

Getting started with Citus – Setting up a four node cluster

One issue with traditional database systems like PostgreSQL is, that you cannot easily scale vertically. Of course you could add read replicas and offload read operations, but that either requires changes in the application, or putting something in front that(…)

Virtual Symposium SQL Server & Azure SQL – Session: Debugging without debugger

As a consultant at dbi services we can dedicate a significant part of our time to training and I took the opportunity today to attend an online conference. In this blog post, I will present this event and(…)

CentOS 8 binary compatible alternatives

There is a lot of roumors around since it was anounced to switch CentOS 8 from a Downstream Build from RHEL 8 to a Upstream Build for RHEL 8 on December 8th 2020. Many people asked why a second(…)