When testing new developments we need to ensure that the required functionality is delivered, but it is equally important to prove that the original functionality is still intact.

Since in a data platform both Code and Data influence the outcome of the test they both need to be tested.
To do so we used a combination of tSQLt as testframework, Analysis services for regression together with test generation to cover almost the whole platform with our regression test.
I will guide you along the way how to set up, create and run the test time after time.