Implementing CI for databases V: Creating Octopus Deploy Projects

In this series, every component needed to do database push-button deployments is set up. From setting up the source control repository, preparing the build environment to configuring the deployment environment. All that’s left to do is to create an Octopus Project to enable real database push-button deployments. In this part I’m going to explain how.  Continue reading Implementing CI for databases V: Creating Octopus Deploy Projects

SQL Toolbelt: the one stop shop for all your SQL Server tool needs

Are you looking for SQL tools to make your life simpler while improving your productivity? Redgate’s got them bundled in their product, the SQL Toolbelt. Interested? Then read this product review.  Continue reading SQL Toolbelt: the one stop shop for all your SQL Server tool needs

Implementing CI for databases IV: Configuring Octopus Deploy Environments

Now the Build Environment is configured to automatically create a new database build every time a change is checked in into source control, it’s time to configure the Deploy Environment so these builds can be deployed with the push of a button. Continue reading Implementing CI for databases IV: Configuring Octopus Deploy Environments

Upgrading to SQL Server 2014: Step 2 – Planning For Reporting

When planning for upgrading our servers to SQL 2014, I not only had to plan for our production instances, but also for our reporting instance. Before planning our capacity needs, I needed to decide on how to get our production data into our reporting environment. How I did that will be the subject of this post.  Continue reading Upgrading to SQL Server 2014: Step 2 – Planning For Reporting

Implementing CI for databases III: Creating TeamCity Build Configurations for Database Builds

You want to deploy your SQL Server database changes with the push of a button and you prepared your Build & Deploy environments for that. The next step is to create a build configuration on your Continuous Integration server in a way that it automatically creates database builds when changes are committed to your source control system. In this post I’ll explain how I did that with our TeamCity CI Server.  Continue reading Implementing CI for databases III: Creating TeamCity Build Configurations for Database Builds

Upgrading to SQL Server 2014: Step 1 – Planning our HA/DR Strategy

Choosing a SQL Server High Availability/Disaster Recover (HA/DR) strategy strongly depends on what the management of your company wants. Therefore you have to sit down with them and determine the Recovery Point Objective and the Recovery Time Objective (RPO/RTO). Once that’s done, you can start planning your HA/DR strategy. Here’s how I decided on our HA/DR strategy.  Continue reading Upgrading to SQL Server 2014: Step 1 – Planning our HA/DR Strategy

Continuous Integration for Databases: Getting Buy-in

You want to implement Continuous Integration for Databases and you know why, but you need to get buy-in from your managers and colleagues. How do you convince them to implement Continuous Integration for Databases in your company? Here’s some advice which can help you.  Continue reading Continuous Integration for Databases: Getting Buy-in

Implementing CI for databases II: Preparing the Build & Deploy Environments

You’ve got all the environments in place for building a database deployment pipeline, and now you want to prepare them to enable yourself to actually build one. What preparations do you have to do? You can start with preparing your Build & Deploy environments.  Continue reading Implementing CI for databases II: Preparing the Build & Deploy Environments

Implementing Continuous Integration for databases I: The Stage

You’ve convinced Management and your colleagues your company should implement Continuous Integration for databases, and now you are ready to actually set this up for your production databases. Where to start? How do you tackle this? In this series I’ll explain how I did it.  Continue reading Implementing Continuous Integration for databases I: The Stage