Converting a SQL DATETIME to a JavaScript Date

JavaScript logo

It should come as no surprise to anyone who has developed for multiple browsers that each one has its own quirks when it comes to enforcing standards, whether they be CSS, HTML5, or even JavaScript. I have been working on some JavaScript that will take a date (in the DATETIME format) from SQL Server and … Read more

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.