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

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

713 reads

Blogs

Microsoft Purview GA menu’s

By

The new data governance features in Microsoft Purview are now being made generally available...

Connect to Power BI as a Guest User in another Tenant

By

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...

Parsing EXE Output in PowerShell

By

I saw a post internally that asked this question: Anyone have a handy powershell...

Read the latest Blogs

Forums

GIT Configuration and Automated Release for Azure Data Factory

By Sucharita Das

Comments posted to this topic are about the item GIT Configuration and Automated Release...

SQL2019 Extended Events missing EVENT debug_channel and EVENT sqlsni.trace ?

By Johan Bijnens

I want to detect usage of TLS on our SQL Server 2019 instances. Copilot...

Bad Stored Procedures

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Bad Stored Procedures

Visit the forum

Question of the Day

Disable All the Indexes

How do I disable all the indexes on the dbo.Logger table?

See possible answers