Let a new nightmare begin

So I am gearing up to re-write an application that is well over 10 years old. During this process we have chosen to clean up the database as well, and this is where I started looking. During my research I found that the application as over 230 tables available to it, of those 112 are never referenced in code (remember – during that time “in-line SQL” was a big benefit). In continuing the research, I discovered that 83 of the 112 are never referenced in stored procedures either – and most of them had data in them. So I have these tables with data but without any interaction with the application. To make matters worse, 82 tables – both reference and not referenced in code – have no data in them. So this is my new nightmare.

River City GiveCamp

Well, I have signed up to participate - as a developer – in the 2nd River City GiveCamp located down in Richmond, VA. This is going to be a completely different experience for me because it well be the first time I get to do the work for the non-profit. I did participate in the Philly Givecamp but I was more of an advisor and less of a developer so I am hoping to do some work this time.

12 days of Geekmas

12 – Comic Books

11 – Coffee Mugs

10 – TeraBytes

9 – USB Ports

8 – Gig of RAM

7 – Development Tools

6 – Star Wars Movies

5 – Flatscreen monitors

4 – Virtual Machines

3 – Smart Phones

2 – Twitter Accounts

T-1 line for the home office