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 …

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 …

Raspberry Pi – Controlling PWR and ACT LEDs (Red and Green LEDs)

Raspberry Pi models have a few built-in LEDs; the modern models have a PWD and a ACT LEDs, that can be turned off quite easily directly by software, to save a bit of mW (energy) and letting it to run without disturbing lights. Read More …