One of the biggest headaches in most development groups that do any sort of SQL Server work is that of source control. There are some commercial products that attempt to solve this headache, and from what I understand, some of them do a pretty decent job. The only one that I have personal experience with is Microsoft’s Team Foundation doohickey, and I walked away from that unimpressed.
Being a “do-it-yourself” kind of guy, and looking for new and interesting ways to use Powershell, I’ve built a (pretty slick, if I say so myself) method of AUTOMATICALLY version-controlling my database objects. No muss, no fuss, it just works, and nobody needs to remember to do anything.