Search

Blog posts

Outage on octopus.com - report and learnings

Public incident report and our learnings about the octopus.com DNS disruption from January 25 – 26, 2023.

Database deployments with Octopus and Redgate SQL Release

SQL Server and PowerShell: Practical Examples

SQL Server database administration using PowerShell

How we use SQL Server as a Document Store

18 months ago we switched from RavenDB to SQL Server, but we kept using SQL as if it were a document store. This post goes into some detail about how our database works.

Database deployment automation using state-based Redgate SQL Change Automation

Setting up automated database deployments with state-based Redgate SQL change automation.

SQL Server deployment options for Octopus Deploy

A brief summary of the most popular SQL Server deployment tools used with Octopus Deploy

Automating SQL Server Developer installation

Learn how to automate SQL Server Developer installation using PowerShell and SQL Server's built-in tooling.

Running SQL Server Developer in a Linux-based Docker Container

How to run SQL Server Developer in a Linux-based Docker container.

Running SQL Server Developer in a Windows-based Docker Container

SQL Server can run in a Windows-based docker container, how can developers leverage that on their development machines?

Using Runbooks to run ad-hoc SQL scripts in your database deployment automation pipeline

This post shows you how to use Operations Runbooks to run ad-hoc SQL scripts in your database deployment automation pipeline.

Self-service database provisioning with Octopus Runbooks and Redgate SQL Clone

A discussion about database provisioning for dev and test, including a walk-through of Redgate SQL Clone and Octopus Runbooks

SQL Server and PowerShell made easier with dbatools: Practical Examples

A comparison between the SqlServer and dbatools PowerShell modules

Automated Database Deployments using State Based Redgate SQL Change Automation

Automated Database Deployments using State Based Redgate SQL Change Automation

Howto: Deploy a SQL Server database using Octopus Deploy

Deploy SQL Server DACPAC with Octopus Deploy

Learn how to deploy SQL Server DACPAC using Octopus Deploy.

How we are using SQL Server in Octopus 3.0

Octopus 3.0 will be built on top of SQL Server. In this post I discuss how we'll be using SQL Server, the editions we support, and high availability plans.

Database deployment with ReadyRoll SQL and Octopus

Database Deployments with Redgate SQL Change Automation, GitHub Actions, and Octopus Deploy

Learn how to use GitHub Actions to build a Redgate SQL Change Automation Package and push it to Octopus Deploy for deployments.

Deploying SQL Server Integration Services (SSIS) packages with Octopus

How to deploy SQL Server Integration Services packages with Octopus Deploy.

Documentation

Deploy to SQL Server using Redgate SQL change automation

Guide to configuring Octopus Deploy to deploy to SQL Server with Redgate SQL change automation

SQL Server Database

Information about using SQL Server Database with Octopus Deploy.

Backup RDS SQL database to S3

This section shows you how to perform a native SQL backup for an RDS SQL database and store in an S3 bucket.

Restore RDS SQL database from S3

An example that demonstrates restoring a database backup file from an S3 bucket.

Backup SQL database

With Octopus Deploy you can backup a MSSQL database with a Runbook.

Restore SQL database

With Octopus Deploy you can restore a MSSQL database with a runbook.

Restore SQL database to another environment

With Octopus Deploy you can restore a MSSQL database to another environment with a runbook.

SQL Server deployments

Automating deployments to SQL Server

SQL Server DACPAC deployment

How to do database deployments with DACPAC.

SQL Server permissions

Permission recommendations for deployments to SQL Server.

Report on deployments using SQL

How to report on deployments using Excel & XML

Can't find what you are looking for? You can also search our support forum.