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
Archive | SQL Server RSS feed for this section
Project contains an invalid database reference
October 30, 2016 
0 Comments
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 readingTFS15 RC2 Upgrade with SQL Server 2016 AlwaysOn
October 29, 2016 1 Comment
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
October 24, 2016 0 Comments
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 SonarQube – root out the Technical Debt in your C# project
December 13, 2015 2 Comments
If you are looking for an installation guide for SonarQube the ALM Rangers have put one together here which you can use to assist you with your configuration and setup. Microsoft and SonarSource have been collaborating on a set of integration components that allow you to configure a TFS/VSTS Build to connect to a SonarQube […]
Continue readingUpgrade SQL Server 2012 for TFS 2013 to SQL Server 2014
June 30, 2014 0 Comments
Starting July 1st, Microsoft will be adding SQL Server 2014 to the list of license grants for Team Foundation Server 2013. SQL Server 2014 is supported by TFS 2013 with the caveat that it has increased hardware requirements compared with previous versions. Microsoft also has a KB Article titled “Performance decreases in TFS 2013 Update […]
Continue reading Versioning your SQL Server Database using Team Build and Release Management
June 17, 2014 5 Comments
You’ve versioned your assemblies using Team Build before… I’m sure you are all aware of the nice little PowerShell script “ApplyVersionToAssemblies.ps1” that updates your C# AssemblyInfo.cs files, you can find it on codeplex here. It is part of a great project named Community TFS Build Extensions which provides a place for build engineers to share […]
Continue readingUsing friendly DNS Names in your TFS environment with Kerberos Authentication Part 1
May 9, 2012 2 Comments
UPDATED: June 11th, 2012 Added reference to MSA (Managed Service Accounts) UPDATED: January 14th, 2014 Added link to hotfix for Windows Server 2008 R2 to use MSAs You’re probably here because you’ve read this excellent post by Ed Blankenship. If you also want to enable Kerberos Authentication support to this configuration there are a few […]
Continue readingWindows Server 2012 Beta “Core” and SQL Server 2012
April 20, 2012 0 Comments
The quickest way to a failed installation of SQL Server 2012 is not to add the .NET 3.5 Framework feature and make sure you have your media or internet access for the server. In the example below I have the ISO mounted in “D:” dism.exe /online /enable-feature /featurename:NetFX3 /All /Source:d:\sources\sxs /LimitAccess or using PowerShell Add-WindowsFeature […]
Continue readingFailed to Process Analysis Database ‘Tfs_Analysis’
March 11, 2012 3 Comments
The following steps are applicable if the following is true: New install of TFS 2010 SQL Server 2008 R2 configured to use individual domain accounts to run the services After this particular install I noticed that in the Application Event Log I was getting the following error message every two (2) hours: Detailed Message: […]
Continue reading- Team Foundation Server 2010 Build Agent not part of the domain
-
Continuous Delivery of your NuGet Packages with VSTS – SemVer
-
DevOps with Dynamics 365 using VSTS
-
Continuous Delivery of your NuGet Packages with VSTS
-
The new web based Release Management “V.Next”
- Azure DevOps Server 2022 RC1 Upgrade Notes
-
Copy files on the target server back to the Azure DevOps Agent
-
Visual Studio Installer – Update Channels
-
Integrate Azure DevOps work items into your work search results (Microsoft Bing)
- Using the Power Platform Build Tools w/Azure DevOps CLI – Create a pull request
-
Lance I: Thank yyou...
-
Wes MacDonald: You can use the Set Version task in this extension...
-
chandra: If possible could you please share the Powershell ...
- Top Stories from the Microsoft DevOps Community – 2021.01.08 - Microsoft Today: […] Integrate Azure DevOps work items into y...
-
Azure DevOps and Visual Studio Awesomeness 