Skip to content

John Dalesandro

  • Home
  • Blog
    • Technology
      • Automation
      • Cloud
      • Data and Analytics
      • Productivity
      • Programming
      • Security
    • Fun & Games
  • Laboratory
    • Analytical Spam Filter Plugin for WordPress
    • Micro Contact Form Plugin for WordPress
    • Head Trimmer Plugin for WordPress
    • Custom Field Embedder Plugin for WordPress
  • Site Information
    • About John Dalesandro
    • Contact
    • Privacy Statement

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.

Categories Data and Analytics Tags MySQL, WordPress Leave a comment

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.

Categories Cloud Tags Apache, Cloud, Debian, Linux, PHP, Security Leave a comment

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.

Categories Cloud Tags Apache, AWS, Cloud, Debian, Lightsail, Linux, MySQL, PHP, Security Leave a comment

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.

Categories Automation Tags Automation, AWS, Bash Script, Cloud, Google Drive, Lightsail, Linux, Security Leave a comment

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.

Categories Programming Tags Composer, PHP, PHP_CodeSniffer, WordPress, XAMPP Leave a comment

Using Cards To Filter In Power BI

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

Categories Data and Analytics Tags Excel, Power BI, Power Query Leave a comment

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.

Categories Security Tags Base64, Power BI, Power Query, REST API, Security Leave a comment

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.

Categories Data and Analytics Tags MySQL, phpMyAdmin, WordPress 1 Comment

Handling Paginated REST API Results with Power Query

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

Categories Data and Analytics Tags JSON, Power BI, Power Query, REST API 17 Comments
Older posts
Page1 Page2 … Page9 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI
  • Create Self-Signed S/MIME Certificates
  • Automate E-mail Information Extraction from Outlook into Excel Using VBA

Latest Posts

  • Manually Create a WordPress Database from the MySQL Client
  • 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
  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer

Laboratory

  • Analytical Spam Filter Plugin for WordPress
  • Head Trimmer Plugin for WordPress
  • Micro Contact Form Plugin for WordPress
  • Custom Field Embedder Plugin for WordPress

Site Information

  • About John Dalesandro
  • Contact
  • Privacy Statement

Social

  • LinkedIn

Topics

  • Fun & Games
  • Technology
    • Automation
    • Cloud
    • Data and Analytics
    • Productivity
    • Programming
    • Security
Copyright © 2023 John Dalesandro. All Rights Reserved.