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.
Creating a Dev CentOS 7 Virtual Machine
Warning: This post is outdated. It is here for reference purposes only.
It's been a little over a month since CentOS 7 was released, and I have decided to give it a shot. I have been using Debian as my go-to Linux distro for a number of years now, but unfortunately Oracle's database platform is not supported on Debian. But, CentOS is a supported OS, and with a new version out... I might as well. Also, learning is good so why not!?
The goal of this post is to cover creating a basic CentOS 7 virtual machine that can be used for development purposes. The resulting VM is NOT fully configured or secure!
Mastodon