Testing

SQLServerCentral Editorial

Planes, Trains, and Automobiles

  • Editorial

I remember going to the theater over the Thanksgiving holiday in 1987 and seeing Planes, Trains, and Automobiles with Steve Martin and John Candy. My family didn’t often take in the holiday weekend movie releases, but Steve was a family favorite actor already, and friends had given it a good review. Having watched it just […]

You rated this post out of 5. Change rating

2024-07-20

172 reads

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: )

879 reads

Blogs

A Basic Update Trigger: #SQLNewBlogger

By

I had someone ask me about using triggers to detect changes in their tables....

Apply for a 2025 PASS Summit Scholarship

By

Redgate is offering 13 PASS Summit scholarships which not only includes the 3-day ticket...

SQL Server TempDB: The Most Overlooked Bottleneck

By

Configuration, Performance, and Unnecessary Usage TempDB is the SQL Server equivalent of a junk...

Read the latest Blogs

Forums

Best/easiest way to import an SSIS package...

By jellybean

Folks, Looking for advice on the best way to import a package. I hope...

Measure duplicating its value when non-conformed dimension attribute is included

By stiej1977

Hi,   I have two fact tables (say FactA, and FactB), that are joined/shared...

balancing numa nodes

By PearlJammer1

Can anybody advise on how i go about balancing threads to each node. As...

Visit the forum

Question of the Day

How Many Nested Triggers?

I have DDL trigger code that I'm working on in SQL Server 2022, but I am concerned that we might end up with multiple triggers firing and the response to the user is delayed. If I want to check how many triggers have fired, or are nested, how can I do this in my code?

See possible answers