Avoiding Complex Octopus Deploy Variables

Octopus Deploy has a very smart system of variable management that allows you to scope variables to machines, environments, steps, roles – and to store variables in projects and in shared library sets. It is so flexible, you could make your life very miserably if you don’t make things as manageable as possible. Scope OctopusContinue reading “Avoiding Complex Octopus Deploy Variables”

Database Deployments with Octopus Deploy and a SQL Cluster

So you have a SQL Cluster and you want to run a database upgrade using Octopus Deploy… where do you start? There are actually two strategies you can employ to do this, and you can choose the most appropriate one based on how you have things set up. Octopus Deploy is cluster-agnoistic, but you canContinue reading “Database Deployments with Octopus Deploy and a SQL Cluster”

Secure Octopus Deploy with an Auto-Updating Let’s Encrypt Certificate

Octopus Deploy has a web portal that runs a self-hosted website on whatever port you specify. You can even have Octopus generate a self-signed certificate in order to use HTTPS when browsing the web portal… but if you connect other application that are strictly validating certificates, they won’t be too pleased with self-signed certificates. PurchasingContinue reading “Secure Octopus Deploy with an Auto-Updating Let’s Encrypt Certificate”

Script SQL Server Backup with Batch Files and PowerShell

This is not our preferred method of deployment, but we have some batch-file based deployments still in active use (most of our deployments are executed via Octopus Deploy, but some of the concepts below are re-usable there too). One of the tasks we perform during a deployment is a database backup prior to schema changes.Continue reading “Script SQL Server Backup with Batch Files and PowerShell”

Kill a Deployment Stuck in a Cancelled State in Octopus Deploy

This very rarely happens in Octopus Deploy, but if something catastrophic happens you may find it useful. I discovered this when the SQL Database server that has the OctopusDeploy database on was switched off during a deployment. Due to the loss of connectivity, the deployment got stuck, and cancelling it caused the deployment to getContinue reading “Kill a Deployment Stuck in a Cancelled State in Octopus Deploy”