database

Almost a year ago, I had reason to write a SQL script that would search for text anywhere in a database. Since then, I’ve had reason to modify and enhance it. The modification was done primarily to support SQL Server 2000, which I still have to support. The enhancement was done primarily to support user-defined … Read more

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