January 2020

Migrations, Migrations, Migrations

For the last 12 months at least I have been industriously working on migrating Server 2008R2 systems to Server 2019. These are times that I am thankful for virtualization. It is relatively easy to spin up a new Windows Server VM, install all the needed software, and then spend the time to configure things so that everything works just right. Often times though, it’s the final configuration task that is always a challenge; mostly due to missing documentation from a vendor or software provider.

This month was no exception: we had to migrate a clients CRM systems to new servers. This was a SQL Server database, an IIS Web Application/Application Server with SQL Server Reporting Services, and an IIS Web Server/ Customer facing portal. The vendor at least provided some documentation though it was incomplete. Another application that I will need to reconfigure is an Asterisk IVR solution, so to test, I spun up a clone of the IVR Server and set it up so I could test it using softphones.

IVR Challenge

One challenge with the IVR server was some incomplete coding by the consultant who originally set this up. The IVR checks for the house number and then proceeds with its lookup from there. Well, what if there is no house number? Apparently the programmer didn’t think to check this; a query of the database would have shown him that there are indeed some properties that don’t have a house number. So I had to modify the Perl programming to account for that. Testing showed it worked, so I was happy with that and was now set up to do a cut-over migration.

July 2011

Veeam Backup and Replication

Backing up servers and desktop can be a challenge, especially with limited storage resources. So I finally got one of my clients to purchase Veeam and offsite Storage. Networking had to be set up and configured to ensure that the backup images would be routed without clogging up the existing production network. Daily and weekly updates will be created by Veeam and then replicated to these off-site servers to ensure that the local systems are backed up and that the remote systems remain current. As part of the Disaster Recovery, all system back-ups will be reviewed and tested and fixed accordingly.

Operations Reporting:

Back in December 2010, I wrote some VBA code to automate Operations Reporting. The existing Operations Reporting system has been modified to now make use of the new SCADA system that has been deployed. Report data will be collected from the SCADA system (where this data is available).

A Day in the Life of IT

To help organize my thoughts I have decided to blog about my experiences in my life as the IT Guy. What – another ridiculous IT blog. How boring. I am sure millions of other IT Guys (and Gals) go through these experiences. From the very mundane to the exciting. And IT Blogs abound. From the very technical to the absurd. And all shades in between. As a small business consultant, I get to see how the struggles for the business Principle in IT are real.

Sometimes one finds a gem solution. That knowledge should be shared and passed on.

Well, that’s why I am here. And my story follows.

Contact Us