Powershell – Search and Replace multiple text strings in file/variable

A common, but not so often, requirement in some scenarios is to search and replace one or multiple text strings in variables or files. This can be quite easily achievied by using a bit of Powershell code. Read More …

SQL Server – SQL Attach DB: Could not open new database [New Question]

A quick question, answered on Heelpbook, about “SQL Server – SQL Attach DB: Could not open new database”, an error quite common while moving or migrating SQL Server databases between servers. Read More …

Getting Let’s Encrypt Certificate using DNS-01 challenge with acme-dns-certbot-joohoi or acme.sh

Getting Let’s Encrypt Certificate using DNS-01 challenge with acme-dns-certbot-joohoi or acme.sh, in manual or automated way, using a cron job and/or DNS APIs, if available Read More …

The Locate command (Linux)

If there is something that is quite vital, on Linux systems in CLI mode (no GUIs, no KDE or Gnome), is to have a simple way to search for specific files/folders on the filesystem. To do this we can install and use the locate utility, on Linux systems. Read More …

Rename an existing PostgreSQL Database

Renaming a PostgreSQL is one of the activities that could be necessary during a normal database lifecycle, sometimes due to testing or development related activities linked to a pre-existing database. Let’s see which PL/pgSQL statement we can use to rename a database. Read More …