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
In migrating data from a legacy budget application to its replacement, my requirement was to take the first and last years in a budget from the old application and update the corresponding table in the “new” app table with those dates as the beginning and ending of the project. One possible solution is to use … Read more
One of my colleagues sent me a very handy bit of code this morning that I thought would be helpful to post. Below are two options which, when run against the database, should return the names of all stored procedures that reference the named table. I am told that the functionality of the first option … Read more