Sometimes you have a bunch of files, for example a bunch of images, which name consists of just a number and an extension. When you want to process them further sorting them will sometimes fail when they are not prefixed with a zero. That’s easily solved in a one-liner
Continue reading “Rename numbered files”Category: Code tidbits
Start plain old IE in Windows 11
Sometimes you encounter a device which is old enough that it needs an ActiveX control for set-up. Some old IP Camera’s for example need this. Technology however moved forward and a “new” browser, such as Microsoft Edge, does not support ActiveX.Do we now have a piece of “e-waste”?
Continue reading “Start plain old IE in Windows 11”Monitor certificate expiration (hosts)
In another Blog Post (Monitor certificate expiration) I showed a small script which checks local certificates for their expiration date and warns when it is near. This due to the fact that lets-encrypt does not send out warning mails anymore.
Checking a remote host is also something that a small bash script can do.
Continue reading “Monitor certificate expiration (hosts)”Monitor certificate expiration
Lately I got a message from lets-encrypt stating they are ending the notification mails they send out to remind you of certificates expiring. As I do have lets-encrypt certificates which are not auto renewed because of the challenge mechanism I liked those messages.
But nothing that a small bash script can’t fix.
Continue reading “Monitor certificate expiration”Have only one session execute code (Critical section)
Sometimes when you’re writing code you can encounter the situation only one session / thread may execute it (the code) at a time. This is commonly referred as a “Critial Section“. How do you solve such a problem within the Oracle Database?
Continue reading “Have only one session execute code (Critical section)”Debugging via Dbms_Pipe
When running code you sometimes have the need to debug the progress of the statements. One way is to use a table and write your debug output into it by means of an autonomous transaction. But sometimes it can be easier to just hand the debug info to a different session. Say hi to Dbms_Pipe…
Continue reading “Debugging via Dbms_Pipe”Controlling a POE switch from Home Assistant
In my quest to save on electricity I detected my TV set was using quite some energy while “Sleeping”. It turned out it wasn’t sleeping the whole time, waking every x minutes trying to get to the internet (it’s not allowed to) for a few minutes and then going back to sleep.
Continue reading “Controlling a POE switch from Home Assistant”