SQL Script to Find Text in all Database Tables and Views

SQL Server logo

I get new applications to work on fairly regularly, and I have found that almost none of them have databases that are normalized to the third normal form. (Shocking, I know.) One that I recently inherited appears to store email addresses in multiple tables instead of in a single table with the user’s other information. … Read more

Use Mr. CSV Transformer to Generate MongoDB Insert Statements

Mr. CSV Transformer with MongoDB functionality

Building on the Mr. CSV Transformer project that my team developed for the recent Houston Hackathon, I have added the ability to convert the CSV data into MongoDB.

Data Transformation Tool Built for the 2014 Open Houston Hackathon – “Mr. CSV Transformer”

open source data transformation tool

This past weekend, over 200 people attended the second annual Open Houston Hackathon. The project I worked on with my team proved to be very interesting, not only because of its focus – making government more efficient through the sharing of purchasing data using the Price History application developed originally by the GSA, and certainly … Read more