MSSQL – Runaway Job, Missing Max Run Time for SQL Job (Tame Them…)

Hi, Recently an issue attracted my attention where we needed to tame the runaway SQL jobs, where the step in the job to import a file from the FTP source at times would run up to 2 days (which would normally complete in ~2 minutes). Well at times ftp downloads by scripts are affected by Read More …

SQL – Backup Database Schema and SQL Jobs via Powershell

Hi, being a developer at times we value our code more than the content that is modifies… Hmmm.. Well sounds suspicious from the business standpoint, but from a developer perspective our code is gold !!!! Any ways, this post outlines one of the methods to backup your MSSQL database schema and SQL jobs regularly. This Read More …

SSIS – Script Task to obtain Geo-Cordinates from Address Text via Google API

Hi, This post is about a quick solution to a problem which I have come across quite few times. In few instances, I was required to obtain the “Latitude” and “Longitude” coordinates of the address stored as strings/text in the columns of the database. This was primarily required to leverage the mapping features of the Read More …