Recent content

I was very surprised that a function BAHTTEXT() exists in Excel. It converts a number to written words.

Use CDN to lower Time To First Byte (TTFB).

Join cells into a comma-separated list in LibreOffice Calc with TEXTJOIN. Get working formulas, avoid common mistakes, and know when to export CSV instead.

Changing Drupal 8 content language is a data repair, not a settings change. Prevent translation collisions, test in staging, and keep a rollback path.

A practical guide to showing nested taxonomy terms in Drupal Views, with current module choices, custom code options, and upgrade caveats for Drupal 10 and 11.

Term hierarchies:

For content: [node:field_tags:0:entity:parents:join-path]/[node:field_tags:0:entity]/[node:title]

Compress:
tar -czvf name-of-archive.tar.gz /path/to/directory-or-file

Configuring SquirrelSQL and MS SQL

WordPress invalid JSON errors usually point beyond the editor. Follow a safe diagnostic path through REST requests, redirects, firewalls, plugins, and PHP.

Try this from the terminal: grep " install " /var/log/dpkg.log

Find out when critical CSS is worth implementing, how to prove CSS is delaying your pages, and how to automate and maintain it safely, including in Drupal.

The screen started flickering and the quick fix is to push down just above the keyboard in the middle and then the flickering stops.

In a lot of cases it is useful to convert bitmaps like jpg, png to vector graphics like SVG or AI.

Go to Structure -> Webform -> Build -> Add element -> Capthca

Remove ssl cert: sudo certbot-auto delete 

Standard packages: aptitude nano git zip software-properties-common

sudo aptitude update; sudo aptitude dist-upgrade

Remap missing symbols and a broken Shift key in Kubuntu 20.04, with practical X11 commands, login persistence, recovery steps, and guidance for Wayland.

If you have the black screen of death when trying to get back from suspend mode, you might want to check out this bug description and pos

    linux    /boot/vmlinuz-5.4.0-31-generic root=UUID=24f1138b-2ab3-4617-a4aa-db3f37107cbc ro  

Here is what I needed to do to get my audio devices found by my Kubuntu 20.04 focal installation.