Visual Studio 2010 Database Guide published on CodePlex

I have been collaborating with Jens Suessmeyer, the VS ALM Rangers, MVPs, and numerous internal customers on guidance for Visual Studio Database Projects for the 2010 release.  The guidance we created covers numerous best practices and contains links to many hands-on labs. This guidance was recently published on codeplex here: Visual Studio Database Guide. In…


Deploying Visual Studio Database Projects from TFS TeamBuild 2010

I had planned to update my previous database continuous integration post with what is new in 2010, but have not had any time to do so yet.  Many customers ask me for the same. I shared my 2010 walkthroughs and samples with Steven, Sr. Technical Writer in User Education, and he beat me to it….


2010 Database Projects at Xerox Services

During the 2010 product cycle I collaborated with Xerox Services frequently as a part of Microsoft’s TAP Program.  The TAP program allows organizations to participate in the product cycle by getting access to software throughout product lifecycle at prerelease milestones, 1 on 1 time with product team members to help implement product features, and a channel to…


New 2010 VSDBCMD Features – Target Model and Override SQLCMD Variables

Targeting a dbschema model file for deployment  Since releasing GDR we have had customer’s ask for the ability to target a dbschema file through vsdbcmd. We were able to add this for the 2010 release. The primary use of this is to diff 2 dbschema files and generate an update script for review. This simplifies the process…


Deploying Composite Projects through a Database Unit Test Run

A customer asked me the other day how they could deploy Composite Projects as a part of a Database Unit Test run. They are using the Composite Project to segment their Database Projects into 2 projects for maintainability and deployment reasons.  1 schema is for a database they ship to customers as part of a…


Come visit/revisit The Beer House! (Continuous Integration)

Isn’t it funny how a simple word like Beer can grab your attention?  In this post we will look at migrating The Beer House (TBH) sample application database to be managed by VSTS:DB.  For those in the NW you may have seen this previously as I have presented this to the PNWSQL User Group. Since…


Managing data motion during your deployments (Part 2)

This post finishes off a 2 part post. Sorry about the delay getting this second part out. I went on a vacation back in May and I am just now getting caught up. In Part 1 we reviewed how to use the pre and post deployment scripts to manage data motion required to deploy some…


Maintaining and synchronizing your reference data through the database project

For database application developers working on data driven applications their reference data is as important and meaningful as the database schema itself.  In fact, the database schema is incomplete when the reference data is absent.  When I say reference data, I am speaking of the non transactional data within the database.  This data goes by…


Managing data motion during your deployments (Part 1)

Continuing with the VSTS: DB Best Practices post series, let’s take a look at managing data motion in your deployments. This will be Part 1 of a 2 part post.  In the first post we will take a look at managing data motion necessary to make table schema modifications while hanging on to your existing…


Right sizing the master.dbschema file for better design time performance

In the March edition of MSDN we provided an overview of Server Projects and how to reference the master.dbschema file to resolve references to system objects.  If you have a project that references the master.dbschema file, you may have noticed it takes a while to establish this reference. You may have also noticed the project…