List all enabled products with no images in Magento 2 with this SQL query

Sometimes when you are working on a webstore, your client might ask you totally reasonable questions like how many products have no images uploaded. To answer this question is not so easy when there are 3000+ products in said shop. As the admin interface doesn't provide an easy way to check for thumbnail-less products, I had to turn to some SQL magic to answer the question.

Enabling Numlock and tap to click on the login screen of Zorin OS (and Ubuntu)

I don't have too many pet peeves, but a disabled Numlock is annoying as hell, especially if you type numbers a lot. It is also infuriating if you physically have to click the trackpad instead of just tapping lightly once you got used to this feature in Windows. When I used a Macbook Pro for a few months this has baffled me but I didn't realize you can enable tap to click in system preferences.

Revive an old laptop with Chrome OS

If you have been using computers for a few decades, there is a good chance that you too have a few old desktop and laptop computers collecting dust in your house. They are too old to use and have little value, so selling them is not a worthwile endevour. You can't even give them to family members as even they find them lacking in power. Have you tried to use a 10 year old laptop with Windows 10? Not fun... Wouldn't it be nice if you could magically make the old hardware more powerful?