Database Testing

External Article

Planning a Database Testing Strategy for Flyway

  • Article

With Flyway, you can adopt a test-driven development strategy that will allow you to test and evaluate databases, and database objects, at every phase of the database development lifecycle. The further down the delivery pipeline that bugs appear, the more costly in time and resources they are to fix. This approach will allow you to catch many of them before the database change even gets committed to version control, making a continuous delivery process much easier to adopt and sustain.

2024-02-12

External Article

What is subsetting, what are the advantages, and how does it make test data management easier?

  • Article

As data grows and databases become larger and more complicated, data
subsetting provides a method of working with a smaller, lighter copy of a
database to make development and testing faster and easier.

In this article, James Hemson poses the questions; what exactly is data subsetting, how and why are developers using it – or not using it, and
what’s prompting conversations about it?

2023-12-11

External Article

How We Ate Our ​Own Dog Food​ To Level-Up Internal Testing with Redgate Clone

  • Article

Most applications have large and complex databases at the back end, making it hard for developers to adequately test their work before it goes out. Having a fast, repeatable process to deliver data on demand is an essential part of an effective software development lifecycle, ultimately leading to improved customer satisfaction. In this article, we’ll explore the journey our own engineering team went on to leverage our own tool, Redgate Clone, to spin up short-lived database instances in containers for automated testing.

2023-10-25

Blogs

A New Word: Feresy

By

feresy – n.  the fear that your partner is changing in ways you don’t...

Mastering the ORDER BY Clause in SQL Window Functions

By

This article provides a comprehensive overview of the ORDER BY clause within SQL window...

SQL Data Pipelines: The Ultimate Guide to Streamlining Your Data Flow

By

Want to build a data analytics foundation that transforms raw data into valuable business...

Read the latest Blogs

Forums

The Cloud Security Problem

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Cloud Security Problem, which...

Iterative query to sum a colum relating to dates.

By Tallboy

Hi, I have a simple table with 5 columns as follows with about 80,000...

how to force SS to run certain SP in parallel?

By water490

hi everyone I have a SP that is run in SSIS.  That particular SP...

Visit the forum

Question of the Day

No Renames

Which of these can't be renamed with sp_rename?

See possible answers