I have a business degree from a Jesuit university. Nonetheless, I found my niche as an IT autodidact. I began working with Microsoft SQL Server 6.5 in 1998. Since then, I’ve worked as an application developer, and more recently as either a DBA or DBD. My technical experience virtually resides within the Microsoft stack in which SQL Server is prime.
An Interesting Gig:
I responded to a LinkedIn solicitation in August 2010 for a short-term contract. It was with a first-responder organization called “ResponseForce1” (“RF1”) that was part of the BP Oil Spill cleanup effort. RF1 managed “base-camp” access/egress and provided asset accountability. I went to the Hopedale, Louisiana base camp (in the bayou of southeastern Louisiana) where I worked 12-hour days in a (freezing cold) military-grade tent. It was not your average IT gig.
Upon returning to the Delaware Valley, I continued to work for RF1 on a part-time basis. Given their usual business conditions–transient quarters with unreliable connectivity–that is, tents out in the middle of nowhere, RF1 commissioned me to design a cost-effective, data-synchronization solution between their base-camp laptops and a SQL Server in their Chalmette, LA office.
At a high level, my solution comprised two components:
- SQL Server 2008 R2 Express installed on the laptops
- Either T-SQL scripts (via a linked server) or Red Gate Software’s “SQL Comparison SDK” scripts
I chose SQL Server 2008 R2 Express because it’s free. I chose the Red-Gate software because I’ve been very satisfied with their tools over the last decade I’ve used them.