[:en]Linux – The sed command[:]

April 10, 2018

[:en]This very flexible tool present in Linux distributions is used for a plethora of use cases related to text processing, most taking care of all possible exceptions. I had the need to read the manual again in order to be able to apply the simplest way (imho) for get rid of sections of text. My […]

[:en]MySQL databases[:]

February 20, 2018

[:en]Most of open source solutions make use of MySQL-based engines such as MariaDB. When well configured, they are indeed reliable and trustful. Database administrators or support staff might need specific queries.  I came across situations that made me select some handful queries and patterns. Query to verify size of the databases schemas in MySQL SELECT […]

[:en]SQL query examples for MSSQL[:]

February 20, 2018

[:en]Some companies have dead set against open source due to possible vulnerabilities, others owing to the fact they have a huge [provider] base already installed or long term contracts. In order to handle that, I’ve selected some Microsoft SQL Server “Selects” and other commands one may find useful have in hand in future. Disclaimer: Some […]