Watch out for Shellshock
Just in case you haven't heard yet... there's another security concern, called Shellshock, to worry about and it's a big one! This bug affects Bash, and since plenty of people are already talking about it I won't spend time elaborating further here. Learn how to secure your Linux servers against it, it's only a partial patch at this time but it's better than nothing.
Checking for Valid Integers in SQL Server 2008 R2
Today I was moving code from my SQL Server 2014 dev server to a SQL Server 2008 R2 production server and I ran into a problem with a function I created a few weeks back. I tend to work across versions frequently, and up until now I have been pretty good at avoiding issues with backwards compatibility... but this one slipped by me!
The function is used during an import process and is intended to convert a term and year (think "Fall 2014") to a numeric representation of the term. The data source is a relatively dirty Excel file with lots of people entering data. While they are pretty good at being consistent, humans make mistakes with data entry. I know, that might be a surprise, but it's true. The code below is a small chunk of the error checking inside the function to catch invalid values so I can send them data integrity reports and get them to clean it up.
Jenkins CI on Debian: Install and Setup
Warning: This post is outdated. It is here for reference purposes only.
While there are many options to consider when picking your continuous integration server, at some point you'll have to make a choice and start using one. I started using Jenkins CI about two years ago and I have never looked back! It's amazing how much can be streamlined by using the right tool for the job. In today's post I will walk you through installing and configuring Jenkins on a development virtual machine running Debian. All commands given are assumed to be for a regular user that has sudo privileges.
Install Oracle Database on CentOS 7
Warning: This post is outdated. It is here for reference purposes only.
I recently wrote a post that walks you through creating a basic CentOS 7 virtual machine using Virtualbox. My purpose for creating that virtual machine was to setup a basic test system for Oracle Database. In this post I will walk you through installing Oracle Database XE 11g on a CentOS 7 virtual machine.
Note: In my first post I incorrectly stated that CentOS is a supported OS for Oracle DB. According to Oracle, it is not officially supported but since RHEL is supported, it makes sense that the CentOS derivative will work. So far I haven't had any troubles with it but please understand that it is not officially supported by Oracle.
Budget Jira Still Going!
Warning: This post is outdated. It is here for reference purposes only.
Six months ago I wrote a post that describes how I've setup a $5/mo Debian VPS from Digital Ocean to run an basic 10-user Jira instance. I now have a four users in the system and my budget Jira is still going strong! If you're curious about the details go read this post first and then come back here to see how it has held up.
Mastodon