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

2 Tips to a Working Schedule

By

When I watched the following video from Justin Sung, I realized that I am...

Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter

By

I’m excited to share a new open-source project I’ve been working on that combines...

Teaching at the SC Statewide Audit Conference

By

Instead of teaching the CISA exam prep course, I'm teaching in the IT track....

Read the latest Blogs

Forums

How to push PowerQuery results into SQL Server

By pietlinden

Sorry, me again. In my PowerQuery, I read a table out of a PDF...

cant that export task be scripted without ssis

By stan

hi, i'm archiving some dw stuff to tsv's.   i got the manual sequence working...

Dependency Chain

By Phil Parkin

I have not yet been able to come up with a tidy solution for...

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers