-
How-To: Find Empty Columns in an Oracle Database
In this How-to I will show you how to find Empty Columns in an Oracle Database. I came across a situation where I found a whole bunch of records some of which were inconsistent. I needed to find a way to print the records with the blank columns. This way I could then give the…
-
How-to: Simple Bash Scripting
This how-to is about simple bash scripting. Scripts come in handy when you when you need to do certain tasks in a unix environment. They come in handy when you need to to a task in seconds that would be otherwise so repetitive that it would take you all day. “While loops” save the day…
-
How-to: Fix SSH Session Timeouts on Mac OSX Mountain Lion.
Recently, we got an upgrade with Comcast that included phone service (does anyone still use land lines at home besides my grandmother?), and increased bandwidth. Increased bandwidth seemed great to me and I could just not use the phone, plus my monthly bill is somehow cheaper this way. Not sure who comcast has working in…
-
How-to: Connect and Query Oracle Database using Perl.
Connecting to an Oracle Database is more of an advanced usage of perl and is not usually needed for every script. However when you start to develop interactive web applications with perl having a backend database is fundamental. This guide will teach you how to Connect and Query Oracle Database using Perl. In this example…
-
How-to: Create a simple Perl HTTP server
I came across a situation where I needed to test access through a complex network of firewalls, nat’s and ACL’s to a server that was to be setup. Problem was the server was not ready yet, it was up but the application was yet to be installed. The application when installed listened on port 4321…
-
How-to: Create a PFX Certificate Bundle.
A lot of platforms use what are called PFX bundles when dealing with SSL certificates. The cool thing about PFX bundles is that it keeps everything the SSL connection needs certificate wise in one tidy file. I recently had the pleasurable experience of having to create about 30 of these bundles, so I will share…