Barclay Hill

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

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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. Steven created...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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 then I have...
  • Blog Post: 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 schema changes. In Part...
  • Blog Post: 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...
  • Blog Post: 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 data...
  • Blog Post: 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...
  • Blog Post: GDR doesn't validate what!?

    Up to the release of Visual Studio Team System 2008 Database Edition GDR a design database was used to store and validate the database project's schema model. The design database was dynamically created when you opened a database project (.dbroj). The project system stored the schema model in this design...
  • Blog Post: Offline Schema Development

    Continuing with the Best Practices post series, let's take a look at Offline Schema Development to set the stage for future topics. This posting is for DBAs and Database Application Developers that are not using the VSTSDB or have just started using VSTSDB. For those that are already using VSTSDB to...
  • Blog Post: Deserialization has failed for project...

    The Visual Studio Team System 2008 Database Edition GDR introduced a new model based architecture that removes the product's dependency on a design db. In previous versions of the product a local instance of the SQL Server was required. This local SQL Server instance would provide the design db for the...
  • Blog Post: Deploying your Database Project without VSTSDB installed

    The release of Visual Studio Team System Database Edition GDR version includes a very powerful tool to import and deploy database schemas from boxes where Visual Studio is not installed. The tool is a command line utility capable of: Importing a database schema from a live database into a dbschema...
  • Blog Post: Why VSTS:DB Best Practices?

    Hi everyone! My name is Barclay Hill and I am a Program Manager on the Visual Studio Team System Database Edition Product Development Team. Yep, it's a mouthful! I will refer to the product as just "VSTSDB" in my posts. I have been working on a whitepaper regarding best practices for using VSTSDB...
Page 1 of 1 (15 items)