Octopus Deploy Package Upload Order Matters

If you have a deployment in Octopus Deploy that contains multiple packages, and the deployment occurs automatically when one of those packages is updated; then the order you upload the packages matters. For example, if you have packages A, B, and C – and you upload them in that order: If you trigger based onContinue reading “Octopus Deploy Package Upload Order Matters”

Check and Warm Up a Website with Octopus Deploy and PowerShell

There are two reasons you might want to add this step to your Octopus Deploy project. The first is to perform a basic check that your newly deployed website or API is working and the second is to warm it up (although there are built-in IIS utilities for this too). I have defined a variableContinue reading “Check and Warm Up a Website with Octopus Deploy and PowerShell”

Using PowerShell to Create Windows Users

Due to replication needing a few Windows users scattered about the place, I needed to write a PowerShell script to create the users as part of the Octopus Deploy automated deployment. For completeness, I have added some users to this script, but you can use “Sensitive” variables in Octopus Deploy to hide away important informationContinue reading “Using PowerShell to Create Windows Users”

The Relative Cost of Octopus Deploy

One of the best things about Octopus Deploy is the simplicity of the pricing. These numbers were correct at the time of writing, but the exact numbers aren’t the interesting bit – it is the relative cost. Obviously, the community edition is free and covers you up to five of everything (projects, machines, users). ButContinue reading “The Relative Cost of Octopus Deploy”

Sync Your Visual Studio Online and Octopus Deploy Version Numbers

I am using a batch file to update the version number in an AssemblyInfo file based on the Visual Studio Online build number. It overwrites a file named GloabalAssemblyInfo.cs that is linked to all of the projects in the set. This means the version automatically updates each time the software is built, and it meansContinue reading “Sync Your Visual Studio Online and Octopus Deploy Version Numbers”

Enabling SQL Service Broker Hangs Indefinitely

We are using Octopus Deploy to perform model-driven deployments to our SQL Server databases based on the DacPac created in a Visual Studio Database project. One of the post-deployment scripts was hanging indefinitely: IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = ‘MyDatabase’ AND is_broker_enabled = 1) ALTER DATABASE [MyDatabase] SET ENABLE_BROKER This isContinue reading “Enabling SQL Service Broker Hangs Indefinitely”

Run Custom Database Scripts With PowerShell and Octopus Deploy

We are using model-based deployments using Visual Studio database projects and Octopus Deploy. One of the things you can’t do when performing DacPac deployments is include a pre-deployment scrip to disable replication prior to running the deployment (although you can re-enable it in a post-deployment script). The solution is to change the “disable replication” scriptContinue reading “Run Custom Database Scripts With PowerShell and Octopus Deploy”

Send a Notification When Deployments Fail

If you are using Octopus Deploy as part of a continuous delivery pipeline, you’ll probably find that deployments don’t fail very often. This means that when they do, people probably need to be told about it. Here is a simple email notification step that tells you when a deployment fails, including a reasonable amount ofContinue reading “Send a Notification When Deployments Fail”

Packaging and Deploying Visual Studio Database Project With OctoPack and Octopus Deploy

The prevalent method of packaging databases for Octopus Deploy is to use update scripts, along with a tool such as DbUp or ReadyRoll to perform the upgrade and manage which scripts have been run on each environment. If you are using Visual Studio Database projects, though, you’ll be interested in how to perform a model-basedContinue reading “Packaging and Deploying Visual Studio Database Project With OctoPack and Octopus Deploy”