Category: Technology

Upgrade PHP and PHP-FPM from the Command Line on a Debian LAMP Stack

How to install or upgrade PHP and PHP-FPM from the command line on a Debian LAMP stack.

How to manually install a LAMP (Linux, Apache, MySQL/MariaDB, PHP) stack on a Debian OS only Amazon Lightsail (AWS) instance.

Bash script to automatically back up and encrypt Linux server configuration files, websites, and MySQL/MariaDB databases to Google Drive.

How to set up Composer, PHP_CodeSniffer, WordPress Coding Standards, and PHPCompatibilityWP to lint WordPress PHP code for coding standards.

How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.

How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.

Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.

How to query a REST API using Power Query and process the paginated results when the number of pages is either known or unknown.

How to render map visualizations with complex and duplicated city names in Power BI using geographical hierarchies.