SQL Server Developer Tools "Juneau" CTP3 bits available now!

Our CTP3 bits are available now through WebPI.  We invite you to evaluate this pre-release version of the SQL Server Developer Tools “Juneau” and send us your feedback.  If you are using Visual Studio Database Projects today you will find some improvements in this release including: Simplified project templates, SQL Azure/Denali support, offline/online table designer…


On to Juneau

I recently joined the SQL Server Developer Tools team at Microsoft.  Our team is working on “Juneau”.  You can learn more about Juneau here on the Team’s blog. I have posted little over the last year, but now expect that to change as I am excited to once again be working handful of exciting new…


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…


Visual Studio 2010 Database Deployment API – Part 2

Since posting the first code sample on how to leverage the Visual Studio Database Deployment API, I have had a number of folks contact me and ask how to do the same, but also comprehend the database references, options set in the project, refactor log, pre and post deployment scripts, etc.  The short answer is…


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….


Deployment Contributor Sample: LiteScript

In Visual Studio 2010 we have enabled a number of new extensibility points as detailed in my earlier post. In this post we will take a look at creating a deployment contributor. This deployment contributor is a deployment executor.   Essentially what the sample contributor does is walks through the deployment plan and creates an…


Goodbye dbp…Hello dbproj!

In Visual Studio 2010, Database Edition or DBPro Projects (.dbproj) have replaced the old Database Projects (.dbp) from previous versions of Visual Studio.  Database Projects (.dbproj) are available in Professional, Premium, and Ultimate versions of Visual Studio.   For those who have used the old .dbp projects and have these in their solutions your .dbp…


Leveraging the Visual Studio 2010 Database Deployment API

I often get questions from developers wanting to modify the deployment engine’s behavior in some way.  These questions are typically motivated by the need to accommodate a specific requirement for a given environment or to support automation in some fashion.  In GDR there has not been much you could do to change the behavior of the…