Managing change is part of a DBA’s job. If you aren’t managing database changes effectively, though, disaster can strike. Jeremiah Peschka has worked with good and bad change management practices and even brought some awful ones under control. In this session, he introduces you to tools, tips, and techniques that will help you effectively handle changes in the database. If you need to deploy changes to the database, this session is for you.

This is a three pronged attack covering a set of techniques for gauging the scope of change, tracking code and configuration changes, and coping with the inevitable 3:00AM production hot fix. This is aimed at development teams and DBAs who are deploying both configuration and code changes to production servers.

https://www.youtube.com/watch?v=OthGRqibDqc

Change Control Scripts & Resources

Coping With Change Control T-SQL Scripts

• Sample Change Document
• The Microsoft Patterns & Practices TFS Guide
• Creating Custom TFS Reports