What methods do you use for promotion to production? Does anyone have any opinions/suggestions? The company I work for has to have separation of duties for SOX Compliance. Developers are not allowed to promote anything to production. We have to supply either MSIs or scripts to SAs who then promote the web-app to production. The problem we are having is with database changes. What is the best way to turn over either an entire database or specific objects to the DBAs to have them promote it without modifying it? We currently either tell them where an object is on a development server and have them copy it from there or we provide them a .sql file and tell them what machine to execute it against. The way they do it now, they may miss permissions or remove permissions because of either not following directions or dropping existing objects instead of altering them. Any recommendations would be greatly appreciated. Thanks, JB

I was checking to see if Vista was available yet and found that Office 2007 was made available today. - Just wanted to let everyone know. JB

It is my company, so I have to pay for it :)

I purchased my last MSDN subscription through Code Project a few years back. I just switched companies and need a new subscription. Does anyone know who has the cheapest prices on an MSDN Premium Subscription? Thanks, JB

Check out the Garmin Edge 305. It is a GPS and personal trainer. It is designed for cycling. Apart from it's GPS capabilities, it maps your rides along with Avg/Max Speed, Cadence, and Heart Rate. I have the 302 model and it is great. The only difference is it lacks the cadence sensor. I've been using it for over a year now and it does great. I have a road bike, but I ride in some heavily covered areas and in some inclimate weather. The signal is very good and should be okay for you off-road as well. Good luck. Jonathan Burris