Archive by Author

Versioning your database packages (.dacpac) with the new Build Agent


If you’re interested in versioning your database packages with the new build agent here is an easy way to get started.  I started off with the following PowerShell example of a build script from the Visual Studio product groups’ build docs for versioning C# and VB projects and made a few tweaks to update the relevant XML […]

Continue reading

Project contains an invalid database reference


If you have multiple developers working in a SQL Server Database Project and not all developers have applied the latest update they may see the following compilation error message for the System Database references: master and msdb. Project ‘[project_name].sqlproj’ contains an invalid database reference: ‘C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\120\SqlSchemas\master.dacpac’.  You must update the reference so that […]

Continue reading

TFS15 RC2 Upgrade with SQL Server 2016 AlwaysOn


Upgrading is very straight forward, improvements were done in .NET 4.6.1 related to the MultisubnetFailover and AlwaysOn.  Here is the section from the .NET team this blog post that is relevant for SQL AlwaysOn.  The connection string in TFS still sets MultisubnetFailover to true but it is no longer required any longer. Improve MultisubnetFailover connection […]

Continue reading

TFS Install with SQL Server 2016 AlwaysOn


If you’re curious about the steps to install TFS with SQL Server AlwaysOn I will be going through them and it’s really very easy.  This blog post assumes the availability group and listener is already up and running. Windows Server 2016 One new features I loved was I could now use a Cloud Witness as […]

Continue reading

Migrate TFVC to Git


Git is now the default version control provider for new Team Projects and it should be your first choice for version control unless you have a requirement for centralized version control system (TFVC). If you want to migrate from TFVC to Git you can use the git-tfs utility.  You can use two methods to install git-tfs, […]

Continue reading
SonarQube Analysis during Build

SonarQube 6.0 integration with TFS15 RC behind ARR 3.0


If you have been thinking of moving to the latest version of SonarQube and you’ve been using the new Active Directory plugin unfortunately it is not compatible with this release, you can see reference to the issue here.   The StyleCop plugin for C# which I referenced in an earlier post has been deprecated. I will […]

Continue reading

vsts-agent Publish artifact for a .NET Core Web Application


To continue from my last post where we published the Test Results, it makes sense I should continue and package the site and create an artifact to use later with Release Management. I am going to edit the same build definition from the last blog post and add a new Command Line task from the catalogue […]

Continue reading

vsts-agent Build Definition for .NET Core (with Test Results)


The other day I cloned a .NET Core sample app MusicStore from GitHub to VSTS and wanted to configure a build definition and run unit and integration tests using hosted build agent. The Visual Studio Build Definition Template which I chose did not work out very well 😦 Clone the MusicStore to your Git Repo in the Code hub and it […]

Continue reading

Release Annotations


This functionality had been available previously under the name “Deployment Markers” back when Application Insights existed under Visual Studio Online.  Release Annotations for Application Insights is an extension for Visual Studio Team Services (VSTS) and Team Foundation Server (TFS) 2015 Update 2 that will create annotations on the Application Insights Metrics Explorer timeline. To get started […]

Continue reading

Working with Web Deploy and Release Management


I’ve spent quite a bit of time working with WebDeploy and Release Management lately for some clients.  You should also be aware of the new tasks that were added to the Visual Studio Marketplace recently: The extension helps manage the following in IIS: Create a new website or update an existing website. Create a new […]

Continue reading