Category Deployment

Pass parameters from TeamCity to nuspec files

Aim: Pass parameters from TeamCity to nuspec files in order to set the solution configuration from TeamCity. In TeamCity, create a new system parameter in the Parameters page of project. In this case, the parameter DatabaseConfiguration sets which solution configuration will be built (e.g. Full = all projects, Partial = only newly updated projects). In […]

Capture Information From Octopus Deploy

Aim: Increase logging generated as part of database deployment via Octopus to assist when investigating failed deployments & reviewing successful deployments. In a previous post on deploying databases using TeamCity & Octopus, I used a PowerShell script (Deploy.ps1) to deploy the databases. However, I’m not entirely happy with the information available about each deployment after […]

“MSB4025: The project file could not be loaded. Data at the root level is invalid.” error when building SSDT project in TeamCity

I recently encountered this error when attempting to build a solution with a new SSDT project in TeamCity. The error occurred at the 01 – Build configuration “Visual Studio (sln)” step: Data.sln(2,1): error MSB4025: The project file could not be loaded. Data at the root level is invalid. Line 2, position 1. The error message […]

Kevin Kline

Career and Technical Advice for the IT Professional

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

SQL Authority with Pinal Dave

SQL Server Performance Tuning Expert

Powershellshocked

A blog about PowerShell and general Windows sysadmin stuff

Simon Learning SQL Server

I'm trying to become "better" at SQL Server and data - here's how I'm doing it!