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

Converting a SQL Table to JavaScript Objects Using the ASP.NET MVC Web API

ASP.NET MVC Web API logo

Happy Independence Day! Here I will describe an alternative to an earlier post that described using a SQL stored procedure to convert a SQL table into a JavaScript object. One of the comments left on that post made me wonder why someone would not want to use the stored procedure method. After querying a large … Read more

Converting a SQL Server Table into a JavaScript Object Using a Stored Procedure

JSON logo

A couple of weeks ago, I attended Houston’s first Open Innovation Hackathon and joined the team that had the goal of redeveloping the City of Houston City-Wide Fee Schedule. The current fee schedule is an ASP.NET Web application with a SQL Server back end. At the end of the hackathon, my team had put together … Read more