Presentation: Best Practices for multi-environment database development

A few months ago our team presented at the SQLBits XIV conference. The topic was Best Practices for multi-environment database development. The full video can be found on the SQLBits site and is a very informative presentation. The topics covered include:

• Using the new deployment options to exclude or not drop users, 
• Using Composite Projects to support defining different indexes, permissions or logins for different target environments, 
• Establishing coding standards across your development group using Static Code Analysis rules.

The slides accompanying this presentation are at the bottom of this post. Feel free to share the slides or use them in your own presentations.

Best Practices for multi-environment database development.pptx

Comments

• Anonymous
  May 05, 2015
  It would be nice to see a Best practices also for SSIS/SSAS/SSRS projects in multi-environment scenarios.

• Anonymous
  November 24, 2015
  The SQLBits webcast's audio/video is completely out of sync! I would like to see the video without it getting completely out of audio/video sync...! It's ok until the middle of the video but then all you can do is stop watching, unfortunately.