Database management

PostgreSQL: Managing multiple “users” with roles

Having multiple users but don’t want them to use the same account?In such a case you can use a role to group your users together.And even better you can set default privileges for that role before creating anything(…)

PostgreSQL 17: Support for AT LOCAL

When it comes to conversions between time zones in PostgreSQL, there is already much you can do today. What PostgreSQL up to version 16 does not support, is the conversion to the local session’s time zone with ‘AT LOCAL’. Starting(…)

How the name of the initial superuser is chosen in PostgreSQL

When working with a PostgreSQL instance, most of the time the initial superuser is called “postgres”. One might think this is always the case, and this user is there by default. But the name for that user is chosen by(…)

SQL Server: How to shrink the T-log file for a lot of old user-databases

Recently I have the case that a customer has a lot of databases not more used but need to be accessible at any time. In this case, we had a lot of T-log with the size when there are used(…)

New Features 23c, Overview (in extracts):

In this blog I want to introduce some of the new features of the Oracle 23c developer edition. It will be only a selection of some of the main features. It is not the intention to give you a thorough(…)

Oracle Lock Free Reservations

The Oracle 23c new feature Lock Free Reservations allows to break with the traditional locking mechanism. Now multiple concurrent sessions can update the same row without be blocked !!! Let’s see how it works. In the traditional locking mechanism,(…)

Automatic PL/SQL to SQL Transpiler

SQL is a wonderful language and very easy to use. For example you can call a PL/SQL function into a SELECT or WHERE clause and the result of the PL/SQL function is returned into the SQL expression. But when we(…)

SQL FIREWALL

This blog comes to complete the excellent blog written by my colleague Gregory Steulet on the same topic. SQL FIREWALL is a new security layer integrated into Oracle Database 23c. First, we create a admin user for which we(…)

Things you can, but probably shouldn’t do in PostgreSQL: Tables in tables, types in types, and arrays on top

PostgreSQL comes with a lot of flexibility for defining new data types, defining tables and defining arrays over data types. You can make that as complex as you want, which does not mean that you should do it. Somehow you(…)

No more snapshot too old in PostgreSQL 17

Currently PostgreSQL has a feature which is called snapshot too old. While each release of PostgreSQL comes with a bunch of new features, sometimes features also get removed. Starting with PostgreSQL 17 there will be most likely no more “snapshot(…)