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

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

External Article

Testing before coding: shifting farther left

  • Article

A term I have only recently learned is "shift left testing." You can read more about this on Wikipedia here. The term was coined in 2001 and generally means testing earlier in the development lifecycle. Hence, shifting your testing left in the timeline. Just how left should you shift your testing, though? In my mind, so early, the rooster hasn't entirely fallen asleep yet.

2023-03-01

Technical Article

Stairway to SQL Server Automated Database Testing

  • Stairway

Automated testing is a way to ensure you can repeatedly examine your code as you make changes by running a series of tests. Since these are automated, you have the ability to execute all tests with one programmatic call rather than hoping a developer runs all tests. This also allows the effort of writing tests […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2023-10-15 (first published: )

621 reads

External Article

Testing Databases: What’s Required?

  • Article

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

2019-07-18

External Article

Testing Databases: What’s Required?

  • Article

Phil Factor reviews the various types of database test that need to run during development work, what sort of test data they require, and the challenges with managing this data, and in keeping the test cell stocked with the correct database, and data, in a way that allows rapid cycles of database testing.

2019-05-20

Blogs

How to give developers access to Query Store

By

Let’s have devs look at their own query performance. Yes, please, sign me up...

Sharpen Your SQL Skills: June’s Challenge Awaits!

By

This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....

Denver Dev Day – Best Practices for Database Deployments Resources

By

I delivered a talk today on database deployment best practices at the Denver Dev...

Read the latest Blogs

Forums

The name of column index 9 is empty ADF

By erics44

Hi I am brand new to Data Factory I am getting the following error...

How to set execution timeout in SSMS for SQL Server Programmatically

By IT researcher

I want to set the execution timeout in SSMS Connection properties on the 'Connect...

The SQL Assessment API

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The SQL Assessment API

Visit the forum

Question of the Day

The SQL Assessment API

What is the SQL Assessment API?

See possible answers