You may also like

• 

  Live training session

  Redgate Flyway AutoPilot with PostgreSQL: Get Flying in Under 30 Minutes

  Chris Hawkins and Huxley Kendell, Solution Engineers at Redgate, are back to lead you through a hands-on session with Flyway AutoPilot, this time featuring PostgreSQL. This interactive, ready-made sample project will allow you to experience using Redgate Flyway Enterprise in under 30 minutes.

• 

  Article

  Basic data masking for development work using SQL Clone and SQL Data Generator

  Richard Macaskill describes a lightweight copy-and-generate approach for making a sanitized database build available to development teams, using SQL Clone, SQL Change Automation and SQL Data Generator.

• 

  Article

  Choosing Between Table Variables and Temporary Tables (ST011, ST012)

  Phil Factor demonstrates the use of temporary tables and table variables, and offers a few simple rules to decide if a table variable will give better performance than a temp table (ST011), or vice-versa (ST012).

• 

  Article

  Reducing Database Complexity and Size using Subsetting

  Getting realistic test data from large production databases can be a challenge, especially when you're trying to keep dev environments lightweight and secure. Redgate Test Data Manager includes a subsetting CLI that simplifies this by letting you generate smaller, fully representative subsets automatically. This article will walk you through getting started: from setup and configuration to running and refining simple subset operations.

• 

  Article

  Running Database Assertion Tests with Flyway

  A database assertion test aims to check that data within a relational database conforms to specific business rules. This article demonstrates how to run these assertion tests automatically in Flyway, checking that the queries under test always produce the expected results.

• 

  Article

  The Importance of Access Checks and Controls in Database Development

  This article illustrates the importance in any database development project of a 'multi-layered' approach to database access controls and security checks, based on the Principle of Least Privilege. It describes a security incident that was raised when databases related to a local development project were found to have been erroneously deployed to a remote test server. It explains the nature of the incident, what went wrong that allowed it to happen, and the measures that were put in place to prevent its recurrence.