Automation

Using PowerShell to Create Windows Users

Posted on

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 information […]

Automation

The Relative Cost of Octopus Deploy

Posted on

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). But […]

Programming

Enabling SQL Service Broker Hangs Indefinitely

Posted on

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 is […]

Automation

Send a Notification When Deployments Fail

Posted on

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 of […]