Database Administration & Monitoring

Commercial PostgreSQL distributions with TDE (2) EDB Postgres Extended Server (1) Setup

We’ve already briefly looked at Fujitsu Enterprise Postgres (here and here) when it comes to TDE (Transparent Data Encryption) in PostgreSQL. In this and the next post we’ll look at(…)

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (2) TDE

In the last post we did the setup of Fujitsu Enterprise Postgres so we’re now ready to look at how TDE is implemented in this distribution of PostgreSQL. The unit of encryption in this version of(…)

SQL Server 2022 CU23: Database Mail is broken, but your alerts shouldn’t be

SQL Server 2022 CU23 bug freezes your emails? Bypass Database Mail using dbatools and PowerShell to resend blocked alerts.

Commercial PostgreSQL distributions with TDE (1) Fujitsu Enterprise Postgres (1) Setup

While TDE (Transparent Data Encryption) is considered a checklist feature in some parts of the PostgreSQL community this topic comes up all over again. The same is true with our customers, it doesn’t matter at all if it technically makes(…)

PostgreSQL: Transaction IDs and Virtual Transaction IDs

In the last post we’ve looked at the basics when it comes to row locking in PostgreSQL and how that looks like in pg_locks. In this post we’ll look at transaction IDs and virtual transaction IDs(…)

SQL Server Always-On: Centralizing Backup History Across Replicas

Replace brittle T-SQL links and manual checks with a central PowerShell orchestrator to reliably manage Always On backup data at scale.

PostgreSQL: An introduction to row locking

Sometimes it is necessary to troubleshoot locks in PostgreSQL to figure out what is going on in the system. While locks are important and necessary in a database system, too many locks can also be an issue, performance wise and(…)

MongoDB DMK 2.3: new features

The latest MongoDB DMK release (2.3.1) introduces a lot of new features and important changes, which I will describe here. dbi services provides the DMK (Database Management Kit) to its customers for multiple technologies: Oracle, Postgres,(…)

What is Forgejo and getting it up and running on FreeBSD 15

In recent customer projects I had less to do with PostgreSQL but more with reviewing infrastructures and give recommendations about what and how to improve. In all of those projects GitLab is used in one way(…)

Shell and Perl in one script

To run a Perl script directly like a binary from within the shell, you have to set the executable flag on the script Add the shebang line (the 1st line (#!...) specifiyng the interpreter to use) #!/usr/bin/env perl #!/usr/bin/perl(…)