Based on people commenting on my previous post, it looks like RedGate kind of "owns" the database-refactoring tools market. I downloaded the 14-day trial of SQL Dependency Tracker. It gives an excellent first impression: not a wizard interface, but very obvious how to start.

After you point it at your …

Curtis Poe (via Patrick Logan):  [I]f you find something is hard to test, that's a code smell.

(I just spent minutes confirming that it's "bears repeating" and not "bares repeating." Both bring up funny mental images.)

I am facing the task of refactoring a database whose structure has accreted through the years. Table names like "Foo" and "FooX." Something like 20 tables that have no records (those are easy to scratch), others that have virtually the same columns and yet which each have thousands of records …

I have Acronis TrueImage, which got good reviews from PC Mag, as my backup software, running against a Maxtor OneTouch over USB 2.0. It's insanely slow: an incremental backup of my data partition takes more than a day. The partition is big (200G) but the delta is some small …

The Netflix optimization challenge exemplifies a situation for which there should be a solution, but which I've not seen a good answer. Namely: for-profit but initially ad-hoc cooperation. For instance, let's just say that I made the case that a Pandora-like "Movie Genome Project" was the key to winning …

Scott Swigart points to this article that gives a non-technical overview of the use of genetic algorithms to determine the optimal tuning characteristics of one's Linux Kernel. This ought to work: many years ago I wrote a genetic algorithm that tuned the optimization parameters of one's C++ compiler and it …

My "Mechanical Turk" reference in the previous post was, as Michael Chermside says, a facetious strategy of using Amazon's cheap-human-labor service to improve movie recommendations. I've been trying to come up with a joke about this that involves the word "Bollywood" and yet which isn't potentially offensive...

In the real …

Well, looks like my Christmas shopping is done for the year... [via Jeff Atwood]

Netflix is offering \$1M to the first person who can achieve 10% better movie recommendations than their current system. Sweet.

I have all sorts of ideas on this. Thank heavens I have copious spare time.

Jon Udell's latest Screening Room is about Windows Live Writer, Microsoft's quite-nice blogging client. However, the discussion of microformats glosses over a significant limitation in the current version of Live Writer, which is that addin content is atomic. For instance, I secured the domain name distributedreviews.com (it's just parked …