Barclay Hill

Barclay Hill, Sr. Program Manager, SQL Server Developer Tools, Code-Named “Juneau” (SSDT)

New article in MSDN Database Programming Issue (9/2011) on Juneau Database Projects

Access article here. With the new Database Project in the latest version of SQL Server Developer...

Author: Barclay Hill Date: 09/06/2011

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

Author: Barclay Hill Date: 07/12/2011

On to Juneau

I recently joined the SQL Server Developer Tools team at Microsoft. Our team is working on "Juneau"....

Author: Barclay Hill Date: 06/06/2011

Visual Studio 2010 Database Guide published on CodePlex

I have been collaborating with Jens Suessmeyer, the VS ALM Rangers, MVPs, and numerous internal...

Author: Barclay Hill Date: 09/13/2010

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

Author: Barclay Hill Date: 08/13/2010

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

Author: Barclay Hill Date: 08/03/2010

FREEWARE Version of Toad Extension for Visual Studio now available

Shameless cross. FREEWARE Version of Toad Extension for Visual Studio now available

Author: Barclay Hill Date: 06/30/2010

Deployment Contributor Sample: LiteScript

In Visual Studio 2010 we have enabled a number of new extensibility points as detailed in my earlier...

Author: Barclay Hill Date: 06/15/2010

Goodbye dbp...Hello dbproj!

In Visual Studio 2010, Database Edition or DBPro Projects (.dbproj) have replaced the old Database...

Author: Barclay Hill Date: 05/04/2010

Leveraging the Visual Studio 2010 Database Deployment API

I often get questions from developers wanting to modify the deployment engine’s behavior in some...

Author: Barclay Hill Date: 05/03/2010

2010 Database Projects at Xerox Services

During the 2010 product cycle I collaborated with Xerox Services frequently as a part of Microsoft’s...

Author: Barclay Hill Date: 04/20/2010

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

Author: Barclay Hill Date: 03/17/2010

Release Candidate of Database Projects availble and GDR Power Tools update

Cross Post of : Release Candidate of Database Projects availble and GDR Power Tools update...

Author: Barclay Hill Date: 03/01/2010

2010 Beta 2 Database Projects available in downloadable VMs

Been putting off evaluating Visual Studio 2010? New VMs are available to download that includes...

Author: Barclay Hill Date: 12/30/2009

Visual Studio Premium and Database Projects

Visual Studio 2010 Beta 2 is available! For those of you who are MSDN subscribers you can download...

Author: Barclay Hill Date: 10/19/2009

Using local 3-part names in programmability objects

VSTS:DB does not support self-referencing 3 part names. It does support external 3 and 4 part...

Author: Barclay Hill Date: 08/26/2009

Installing GDR R2 with different languages side-by-side

The GDR R2 has a limitation that it uses the same product id for all localized versions of the...

Author: Barclay Hill Date: 08/19/2009

Overview of composite and partial database projects

A colleague published a new white paper on composite and partial database projects. If you want to...

Author: Barclay Hill Date: 08/15/2009

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

Author: Barclay Hill Date: 07/31/2009

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

Author: Barclay Hill Date: 07/31/2009

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

Author: Barclay Hill Date: 07/02/2009

Maintaining and synchronizing your reference data through the database project

For database application developers working on data driven applications their reference data is as...

Author: Barclay Hill Date: 04/01/2009

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

Author: Barclay Hill Date: 03/29/2009

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

Author: Barclay Hill Date: 03/22/2009

GDR doesn't validate what!?

Up to the release of Visual Studio Team System 2008 Database Edition GDR a design database was used...

Author: Barclay Hill Date: 03/17/2009

Deployment Failure: "An item with the same key has already been added"

We are receiving reports from customers that they are encountering a deployment failure of their...

Author: Barclay Hill Date: 03/05/2009

March MSDN - Introducing new features in the VSTSDB GDR

Jamie Laflen and I wrote an article for this month's issue of MSDN magazine. The article briefly...

Author: Barclay Hill Date: 03/02/2009

Offline Schema Development

Continuing with the Best Practices post series, let's take a look at Offline Schema Development to...

Author: Barclay Hill Date: 03/01/2009

Deserialization has failed for project...

The Visual Studio Team System 2008 Database Edition GDR introduced a new model based architecture...

Author: Barclay Hill Date: 02/23/2009

New Visual Studio Team System Database Team Blog

Developers needing the latest VSTSDB product information should subscribe to the new VSTSDB Team...

Author: Barclay Hill Date: 02/23/2009

Deploying your Database Project without VSTSDB installed

The release of Visual Studio Team System Database Edition GDR version includes a very powerful tool...

Author: Barclay Hill Date: 02/20/2009

Custom Data Generator available for SQL Server Sparse Columns

A custom Data Generator for SQL Server Sparse Columns is available for the VSTSDB GDR release....

Author: Barclay Hill Date: 02/09/2009

Developing Custom T-SQL Static Code Analysis Rules

Earlier this week I presented at an internal conference on the topic of Database Project...

Author: Barclay Hill Date: 02/06/2009

Why VSTS:DB Best Practices?

Hi everyone! My name is Barclay Hill and I am a Program Manager on the Visual Studio Team System...

Author: Barclay Hill Date: 02/01/2009