• I'm going to take a guess and assume that you're not talking about my session called "Best Practices for Database Deployment" because I get into a lot of what you're talking about there. I make a huge point of saying that DBAs are not the special snowflakes that they think they are and that process, whatever it might be, absolutely has to apply to them equally. And yeah, I do believe that it all comes back to source control because I think you have two known states for your systems, what's in production and what's in source control. The more those are synchronous, the more you can control your deployment processes and automate them to make them faster and more reliable.

    In short, I don't think DBAs are good at the development/deployment aspects of our job. We're great at the "protect production" part, but let that override the other. We need to do both.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning