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 …

WordPress – Disabling XML-RPC and Rest API to improve security

In WordPress we have always had inbuilt features that let us remotely interact with our site. We have two different approaches available: XML-RPC, a legacy method, or the newer Wordpress REST API that simplifies the remote interactivity and development of external apps. We can disable both of them if we do not need any remote access to the site and/or we do not use any app for the Wordpress resource. Read More …

Powershell – Get Permissions on folders and/or files

Sometimes it is useful to get permissions (NTFS and/or Share) on Windows systems (Server and/or Client). The following Powershell code will generate, in the same folder in which is saved the ps1 file (once the below code is copied and saved on the system as ps1 file), a CSV file which will include all the permissions (subfolders included) set in that moment. Read More …

Excel – Allow Certain Users to Edit Cells Range

Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …