smithbits

I work in IT. The company I work for makes things and sells them to people, so my job isn't about writing complex software, my job is about making it easier to make things and sell them. For the record I work with a great group of people and really like this job. And because I'm not new to this I've seen the same problems over and over. A simple example is that customer lists always have junk data in them. I've never seen a list of more than 10K names that I couldn't find problems in with some basic SQL queries. Given that this happens everywhere who's blogging about the solutions? Things like I want a database that has a type called "FirstName" and when I do a query like:

select FirstName from Customers where FirstName like 'Alex';

I want to see "Alex", "Alexander" and "Alejandro" in the results list. Now for this specific problem I realize there are many interesting answers outside the database. I goofed off with python difflib one Friday afternoon and read up on Levenshtein distance and made a crude audit tool. But who out there is actually solving these problems or at least writing about them in new and interesting ways? Thanks.