I’ve spent quite a bit of time writing about Red Gate products over the last year, particularly SQL Source Control which is simply the best damn way to finally get those pesky databases into VCS. The fact that it now plays nice with first cousins SQL Compare and SQL Data Compare means the dream of VCS sourced automated deployments of data and schema for the masses is finally a reality.
What I like about the Red Gate products in general is that they take traditionally laborious, low-value tasks and totally transform the way we approach them. Migrating a database? Just SQL Compare it in a few clicks rather than manually writing time consuming, error prone scripts. Load testing an app? Just SQL Data Generate millions of realistic records in an instant rather than manually constructing dummy data which is rarely a good reflection of typical transactions (or worse, just take a copy of production data – nasty!) How about tracking down that elusive .NET performance bottleneck? ANTS Performance Profiler needs to be seen to be believed.