Testing your Database in a DevOPs Pipeline

Views 2778

This month while at MVP Summit in Redmond WA (USA not Australia :)) our Database DevOPs Evangelist Hamish Watson recorded this session on “Testing your Database in a DevOPs Pipeline” on The DevOps Lab with Damian Brady (B|T).

In this session Hamish walks you through how and why you should be testing your database changes and implementations prior to deploying into production. To achieve this really important process that can save time, save money, be more productive and confident that the implementation is not going to have issues in production but will have issues in earlier environments Hamish introduces you to some tooling and processes to use this tooling.

Have you heard of the Shift Left Strategy? In summary this strategy is to shift the process of failing and finding failures to much earlier in the process Ie. to the left allowing your production deployments to be undertaken having already identified and resolved any issues.

Some of the tools that Hamish covers in this session that allows you to undertake this vital process are:

  • tSQLt – Used in SSMS, VSTS, TFS
  • SSDT – Unit tests built into the product (unittest.cs)

Without giving to much more away have a look and listen to Hamish and Damian talking “Testing your Database in a DevOPs Pipeline

Are you wanting to learn more about Database DevOPs, Why not look at and sign up for our Database DevOPs training courses.

Leave a Reply

Your email address will not be published. Required fields are marked *


I am a Microsoft Data Platform MVP as well as a Microsoft Certified Master working as the Principal Consultant here at SQL Masters Consulting. When I am not working with the SQL Server Stack I like to get away to the Snow and spend time Snowboarding.