I have been waiting anxiously for this: Microsoft has announced Team System for Database Professionals. Among the coming features are:
- rename refactoring,
- a new T-SQL editor,
- a schema compare tool that will generate scripts to sync the schemas of two databases,
- a data compare tool that will generate scripts to sync the data in two databases, and
- a database unit testing infrastructure.
Read a great book: Good to Great: Why Some Companies Make the Leap… and Others Don’t by Jim Collins