When And How to Automate?

Database automation is hard. Here are some things to consider.

Managing Changesets Over Time: Stairway to Reliable Database Deployments Level 6

As database changesets accumulate over time, they gradually become more than deployment artifacts. This level explores how a well-organized changeset library evolves into a replayable representation of the database’s structural history, supporting not only reliable deployments but also reconstruction, auditing, and long-term maintainability. Through practical examples and a real-world case study, it shows why maintaining coherent Create and Rollback scripts continues to provide value long after a successful production deployment.

Requiring Technical Debt Payments

Steve found someone using an interesting approach to get developers to address some technical debt.

Manage Elastic jobs in Azure using Azure Elastic Jobs Manager

Microsoft Azure offers Azure Elastic Job agent as a managed service, enabling efficient scheduling of T-SQL workloads on Azure SQL Databases. Learn how to configure the service in this article.

Azure Data Studio - A First Look

See a first look at Azure Data Studio from Kenneth Igiri and read about his impressions.

Copy SSIS Environment variables to another server

Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.

Redgate opens the doors to cross-database DevOps Test Data Management

Redgate’s new DevOps test data management tool, Redgate Clone, provisions production-like data in seconds for SQL Server, PostgreSQL, MySQL and Oracle databases.

How to Automate Cross-Platform Database Development

In order to focus on their primary task of developing databases, the development team need to automate as many as possible of the routine tasks that are essential for database delivery, such as testing, scripting, version control, documentation, code review, reporting and so on. This article gives some advice on how to do it, faced with the added challenge of needing to use several different relational databases.

The ten habits for highly successful compliant database DevOps

Database DevOps has come of age. Now seen as a key technical practice which can contribute to the successful implementation of DevOps, it stops the database being a bottleneck and makes releases faster and easier.

To implement it successfully, there are ten areas which teams should focus on.

How to Implement CI/CD in Azure Data Factory (ADF)

Learn how you can use CI/CD with your ADF Pipelines and Azure DevOps using ARM templates.