Friday, June 23, 2006

Deploy multiple db scripts to multiple servers

After doing some code cleanup on some stored procedures, I needed a efficient way to deploy the scripts to multiple servers/databases. I had 20 different scripts and though that is not a huge amount I still wasn't looking forward to opening each file in Query Analyzer and executing for each server. Google saves the day again and led me to a DOS command that fit the bill perfectly. (Note that if you run the command from within a .bat file you should specify %%variable instead of %variable)

Monday, June 05, 2006

Great (free) backup service

PC Magazine just featured this new backup service. They give you 2GB of backup for free. The interface is clean and simple and there are no ads or popups. If you're looking for a backup solution you should definately check out Mozy backup.

Sunday, June 04, 2006

Free data models! Get yer free data models here!

This resource was mentioned the other day on the CFCDev list. It may come in handy some day so I'm posting here for future reference. Check out the Free Library of Data Models.