Episode
Unit Testing your Database Changes
Damian meets with Hamish Watson at the MVP Summit to talk about testing your database changes. Unit testing is vital in a good process but tests don't often extend to the database. Can it be done at all? And do DBAs have to learn a new language? Hamish shows us two tools that can help you write database tests, in TSQL, and run them as part of your CI/CD pipeline.
Resources:
tSQLt: http://tsqlt.org/
Unit Tests for SSDT Projects: https://aka.ms/SSDTTests
Hamish's Blog: https://hybriddbablog.com/
Follow Hamish on Twitter: @TheHybridDBA
Follow Damian on Twitter: @damovisa
Damian meets with Hamish Watson at the MVP Summit to talk about testing your database changes. Unit testing is vital in a good process but tests don't often extend to the database. Can it be done at all? And do DBAs have to learn a new language? Hamish shows us two tools that can help you write database tests, in TSQL, and run them as part of your CI/CD pipeline.
Resources:
tSQLt: http://tsqlt.org/
Unit Tests for SSDT Projects: https://aka.ms/SSDTTests
Hamish's Blog: https://hybriddbablog.com/
Follow Hamish on Twitter: @TheHybridDBA
Follow Damian on Twitter: @damovisa
Have feedback? Submit an issue here.