All Posts

Back to basic, let's brush up on some `SQL` :) At my company we have employees creating customer accounts every day. Sometimes we make mistakes, for instance, we forget to check if the company already was a customer (maybe 10y ago they may have had a product). Duplicate accounts can cause all sorts of problems, so I wanted way to detect them with `SQL`. The problem was, the company names may have been entered with different punctuation, whitespace, etc. So I needed similar names to surface from the depths of our database, not just exact matches (that would have been too easy :)

> This project now has its own homepage at bash3boilerplate.sh.

I often share screens with co-workers by Campfire, Github, or mail. Visualizing something can save you a lot of typing. Show people what button shade doesn't look quite right, instead of explaining in 1000+ characters. Share a load graph without saving & attaching images, or handing out basic auth credentials. The list goes on & on. Once you make it a joy to share, you'll find use-cases on a daily basis, and it is my believe you'll lose less time on typing and miscommunication.

I recently had an annoying encounter with the error message: `Too many authentication failures for root`. I found out this can be caused because you've hoarded too many SSH keys :) So serves me right, but let's see what happens exactly.

I love my NAS but because I tried to save a little money it does not [run SABnzbd](/blog/2011/02/28/optimize-your-synology-for-downloading/) very well. I've tried different approaches but find myself ending up downloading on OSX as it writes to a network share on my NAS. Too bad, but I'm archiving this one under the section first world problems. The challenge I have now though, is when my Mac goes to sleep, my mounts disappear, and SABnzbd writes to the local filesystem instead. Cause as far as my downloading program could tell, it was already writing to a local filesystem, so it will just keep on doing that until my Mac's disk is at 100%. I wrote a little script to prevent that. You may not be running SABnzbd, but there are obviously many other use cases where you want a network mount to persist. Especially if you are automating something outside of the GUI. With some small adjustments this could work for Linux/NFS/SMB as well.