Monthly Archives: January 2007

Scripting Around Poor Table Design

We’ve all seen it. Some 3rd party database you’ve inherited from someone else was simply never designed with scalability and portability in mind. There’s no hope to change it, as it will break the original design and thus the original … Continue reading

Posted in Programming | Leave a comment

Quick SQL Date Functions and Queries

It’s easy to grab the date from a field in a database so long as you saved a timestamp field along with your data row. However, there are often times in developing stored procedures and advanced queries where one needs … Continue reading

Posted in Programming | Leave a comment