Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
Power Query examples to access Excel data in the current workbook, local file, or SharePoint path. Data structured as a worksheet, table, or named range.
Technology
Manually Create a WordPress Database from the MySQL Client
How to manually create a WordPress database, establish a WordPress user access account, and import data from the MySQL / MariaDB command line.
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.
Install a LAMP Stack Manually on a Debian OS Only Amazon Lightsail Instance
How to manually install a LAMP (Linux, Apache, MySQL/MariaDB, PHP) stack on a Debian OS only Amazon Lightsail (AWS) instance.
Automatically Back Up a Linux Server to Google Drive
Bash script to automatically back up and encrypt Linux server configuration files, websites, and MySQL/MariaDB databases to Google Drive.
Linting WordPress Code Using Composer and PHP_CodeSniffer
How to set up Composer, PHP_CodeSniffer, WordPress Coding Standards, and PHPCompatibilityWP to lint WordPress PHP code for coding standards.
Using Cards To Filter In Power BI
How to use a combination of Cards and Bookmarks to filter other visualizations in Power BI.
Accessing REST APIs with Basic Auth and API Key in Power Query
How to handle REST API queries in Power Query and Power BI where both Basic Authentication and API Tokens are required.
WordPress Database Cleanup Without Plugins (SQL Only)
Simple SQL statements to clean unnecessary overhead, bloat, and orphaned data from WordPress databases without using a plugin.