Unit Testing

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

898 reads

SQLServerCentral Article

Redgate Takes over the SQLCop Project

  • Article

I am happy to announce the Redgate Software and I are supporting and taking over stewardship of the SQL Cop project at this point. With permission from its founder, George Mastros, we will host the main repository for the project at https://www.github.com/red-gate/sqlcop. This should be considered the official repository for the code from this point […]

5 (1)

You rated this post out of 5. Change rating

2019-08-13

3,892 reads

Technical Article

Set your team up for valued software delivery with Unit Testing

  • DatabaseWeekly

There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.

You rated this post out of 5. Change rating

2019-05-21

External Article

Why don’t you unit test SQL Server code?

  • Article

This post will show the benefits of test-driven development and including automated SQL Server unit testing within your release pipeline. Even if you have a large code base and no existing unit tests, you can start introducing tests now to make your database code more robust to change.

2017-09-07

5,842 reads

Blogs

Speaking at the 2025 PASS Data Community Summit

By

I will be back in Seattle this year attending the 2025 PASS Data Community...

The Book of Redgate: Motivation

By

Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight...

A Six Week Break

By

Today is my last day of work for six weeks. I start my sabbatical...

Read the latest Blogs

Forums

Three Times a Day

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Three Times a Day

SUM([value]) and highest record type

By Pete Bishop

Given a record mapping table: Id Initial Updated 1 1 2 2 3 4...

should i expect data types in task->export data from ssms?

By stan

Hi i recently exported a number of "to be purged resultsets " to .tsv's. ...

Visit the forum

Question of the Day

Multiple Defaults

In my SQL Server 2022 database, I run this code:

ALTER TABLE dbo.OrderHeader 
ADD ModifiedStamp DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
I decide I need to add auditing to another table and run this:
ALTER TABLE dbo.Tracker
ADD Created DATETIME CONSTRAINT df_Created_Getdate DEFAULT GETDATE()
GO
What happens with these statements?

See possible answers