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… Read more

Composite Projects and Schema Compare

Several questions have been raised on the forum regarding use of composite projects.  This post discusses composite projects in general and then describes a technique you can use with Schema Compare for synchronizing composite projects with changes that have been made to the database. Composite Projects 101 SSDT can combine a database project with one… Read more