Demonstration of Drupal deploy module
Creating an effective deployment process has historically been a nightmare with Drupal. A deployment process should include pushing content and configuration settings (and code) from dev server to stage server to live server. In many cases, pushing content from live server back to stage server will also be required (to test on the stage server with real life content).
The deploy module looks like it will do a great job with such a deployment process.
This video is a great demonstration of the deploy module.