All articles

Mastering complex data security challenges leads to praise and honor

During the analysis of the requirements for the challenging yet incredibly exciting project for our customer Galenica, I remember one thing very well: my colleagues from the OMrun-Team, Product Owner and consultant Frank Zeindler and consultant Oliver Schwark were(…)

Cleanup Oracle After Patching

cleanup Oracle-Home(s) after applying the quarterly Release Updates Do you suffer from the fact that release updates take longer each time?Are you afraid that your hard disk will fill up because the Oracle-Home is getting bigger and bigger?Here is the(…)

PostgreSQL 18: Virtual generated columns

This is about another feature which was committed for PostgreSQL 18: Virtual generated columns. Generated columns are available already, but they need to be “STORED”. This means the result of an expression is stored to disk and the result is(…)

pgvector, a guide for DBA – Part1: LAB DEMO

Introduction The first release of pgvector occurred in April 2021. Since then a lot has changed and is still changing. Even though we could say that the level of maturity of AI stacks and usage is currently really amazing, things(…)

Customer case study – SQL Server table partitioning

A client submitted the following issues : Their database hosts multiple tables, including one table of approximately 1 TB, consisting of several billion rows. This table is continuously fed by various data sources. Additionally, it is also used to generate(…)

PostgreSQL 18: Introduce autovacuum_vacuum_max_threshold

Vacuum/Autovacuum is one of the critical parts of every PostgreSQL installation. When autovacuum is not configured properly for your workload you’ll suffer from bloat and performance issues sooner or later. Most of the installations we’ve seen run with(…)

SQL Server AlwaysOn – Failover does not work but everything is green on the cluster

Recently I was called by a customer because the failover on a SQL server AlwaysOn 2 nodes cluster does not work. I connect to the first node of AlwaysOn cluster who is the primary and check the cluster with the(…)

PostgreSQL: Indexes and casting

This is a small reminder to be careful with casting one data type to another in your queries when you want to have an index access rather than a sequential scan. Here is a small example of what can happen:(…)

PostgreSQL 18: Per-relation cumulative statistics for [auto]vacuum and [auto]analyze

This is about another feature which will most likely show up in PostgreSQL 18 later this year. The statistic system is something which gets more and more details with almost every release of PostgreSQL, and PostgreSQL 18 will be no(…)

Managing multilingual documents including version control

Business requirements Manage version controlled documents The documents must be available in different languages Each document has his own initial language version The translated documents must be in relationship with the initial document Should a document version be subject to(…)