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

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 Leave a 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 8 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

Using Self-Signed S/MIME Certificates in Outlook

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

Categories Security Tags Asymmetric Cryptography, Encryption, OpenSSL, Outlook, PKCS12, Public-key Cryptography, S/MIME, S/MIME Certificates, Security, x509 2 Comments

Faster Excel Calculations By Minimizing Range Boundaries

Excel calculation speed can be improved by reducing the size of an evaluated range. This custom VBA function removes empty boundary cells from a range.

Categories Productivity Tags Excel, VBA Leave a comment

Counting Based on Background Color in Excel

How to count all Excel cells in a range based on background color using a custom user-defined function in VBA.

Categories Productivity Tags Excel, VBA Leave a comment

Concatenate Ranges, Arrays, and Values Using Excel VBA

How to concatenate ranges, arrays, and values in Excel using a custom function with options for a delimiter and setting row or column priority.

Categories Productivity Tags Excel, VBA Leave a comment
Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page9 Next →

Popular Posts

  • Combination Clustered and Stacked Column Chart in Excel
  • Create Self-Signed S/MIME Certificates
  • Display Total Inside Power BI Donut Chart
  • How to Use Unicode Characters in Power BI
  • Mapping Continents and Countries in Power BI

Latest Posts

  • Creating a Power BI What-If Scenario Analysis
  • Power Query to Access Excel Data from Current Workbook, Local File, or SharePoint
  • 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

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.