Simple Database Development with SQL Change Automation

SQL Change Automation makes automation simple enough that it can adapt to suit many different approaches to SQL Server database development. Phil Factor describes a project to update the Pubs database, using it in combination with a PowerShell function and to maintain in source control the build scripts, migration scripts and object-level scripts, for every version of the database. Read more

Automating Oracle Database Deployments using the Hybrid Approach

Stephanie Herr explains how to use the 'hybrid' approach in the Deployment Suite for Oracle to automate Oracle database deployments. This is where the team maintains the current state of the database in version control during development. then, at key stages, they generate and test the migrations script that will be used to deploy the new database changes safely. Read more

SQL Server Licensing and SQL Monitor

How well do the SQL Server licenses you own match up with what you need for your current use? William Durkin explains how to use SQL Monitor to find out. Read more

When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation

Phil Factor on the fill factor, pages splits and index fragmentation, and how SQL Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues. Read more

Testing SQL Server Stored Procedures and Functions with SQL Data Compare

Phil Factor demonstrates a cunning way to test stored procedures or functions, such as after refactoring, by storing the 'before' and 'after' results in views and then using SQL Data Compare to spot any discrepancies. Read more

Migrating SQL Monitor’s Base Service to .NET Core

Josh Crang explains why SQL Monitor will be switched to run on .NET Core, and how the team tested the potential performance improvements in the monitoring service. Read more

How to cope with Database Drift during Deployment using SQL Compare

Phil Factor on how to cope with any database drift that results from various checks and tests and fixes made during deployment. Read more

The Database Development Stage

Phil Factor distills the basic tasks of the database development stage and explains how SQL Compare can help tackle them. Read more

Getting Started with Automatic Database Branch Switching

Alexander Diab demonstrates how a team of developers can work on and test features in different branches of a SQL Server database development project, while their local development database automatically remains 'synchronized' with the current branch in version control. Read more

Deployment Suite for Oracle: What’s new? Redgate Change Automation

Redgate Change Automation is now part of the Deployment Suite for Oracle. It is a command line tool that makes it easier and safer to automate Oracle database deployments. It has four commands to help you build, test, prepare, and perform Oracle database releases with built-in safety checks. Read more

Redgate Test Data Manager

Flyway

Redgate Monitor

Overview

Test Data Management

Automate

Monitor

Product articles