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

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 15 Comments

Mapping Cities in Power BI

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

Categories Data and Analytics Tags Power BI Leave a comment

Mapping Continents and Countries in Power BI

How to render both basic map and filled map visualizations in Power BI using continent and country names.

Categories Data and Analytics Tags Power BI Leave a comment

Using Self-Signed S/MIME Certificates in Thunderbird

How to install and use self-signed S/MIME digital certificates in Thunderbird for e-mail digital signatures and encryption.

Categories Security Tags Asymmetric Cryptography, Encryption, OpenSSL, PKCS12, Public-key Cryptography, S/MIME, S/MIME Certificates, Security, Thunderbird, x509 Leave a comment
Older posts
Page1 Page2 … Page8 Next →

Popular Posts

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

Latest Posts

  • Automatically Back Up a Linux Server to Google Drive
  • Linting WordPress Code Using Composer and PHP_CodeSniffer
  • Using Cards To Filter In Power BI
  • Accessing REST APIs with Basic Auth and API Key in Power Query
  • WordPress Database Cleanup Without Plugins (SQL Only)

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.