Database Administration & Monitoring

SQL Server Tools: First steps with go-sqlcmd tool on Windows Server 2022

As you know, with the new version of SSMS since the version 18, the tools like sqlcmd are no more included in the installation. You need to download separately the tools that you need here Few(…)

PostgreSQL 16: Playing with pg_stat_io (1) – extends

PostgreSQL 16 (currently in beta 2) will come with a new view for tracking I/O related statistics. I’ve written a very basic blog about pg_stat_io in the past. In this post(…)

Generated columns in PostgreSQL

Sometimes it becomes handy when you can auto-generate a column based on an expression. For this there is the concept of generated column. Those columns can be either of type “stored” (the derived value is computed when the column(…)

PostgreSQL: System catalog modifications are currently disallowed

Today at a customer I faced this: “System catalog modifications are currently disallowed” which, honestly, I’ve never seen before. Why would someone try to modify the system catalogs, at least in a productive environment? It turned out to be(…)

Instrument your python application with Prometheus (Part1)

We continue our blog series about Prometheus, today addressing a particularly interesting but often overlooked topic: Prometheus Instrumentation. What does that mean? I’m not telling you anything new when I say that Prometheus allows you to collect(…)

Between PostgreSQL Conference Germany 2023 and the Swiss PGDay 2023

The PostgreSQL Conference Germany 2023 is over and it was a success. We had 250 attendees which made this year’s edition of the conference the largest ever. For us the conference already started Monday evening with the(…)

Oracle Database monitoring with Zabbix

Zabbix comes with an Oracle Database monitoring template out-of-the-box, so it should not be too complicated to integrate one server. Nevertheless, I faced a few issues while trying to setup one and I will detail these steps below. Agent(…)

PostgreSQL 16: More statistics in pg_stat_*_tables

PostgreSQL 16 is already in feature freeze and Beta1 has been released on May 25th. This is the time you should start testing and report any issues back to the community. There are plenty of new features, as usual,(…)

2023.pgconf.de and the Swiss PGDay are just around the corner

Time flies, we are in June already and at the end of this month two PostgreSQL conferences will take place: There is 2023.pgconf.de, this year in Essen, the 27th of June. For the first time(…)

An overview of “Oracle Cloud Infrastructure: everything for an efficient migration” event by dbi services

Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: "Oracle Cloud Infrastructure: everything for an efficient migration".