Database DevOps with Redgate Data Tools
Description
In this episode Dmitry is joined by Eric Kang, Program Manager for SQL Server Data Tools (SSDT) who is back on the show to talk about Unit Testing for database projects and how it integrates with the DevOps pipeline.
Specifically, Eric will jump into how the open source test framework Slacker works with SSDT, SQL Server 2016 (or SQL Database on Azure) and Visual Studio 2017 to enable database unit testing. We'll also demo how to enable the high code coverage for SQL Server database programming with unit testing then enable gated database Continuous Integration (CI) build with Visual Studio Team Services (VSTS) as part of your DevOps pipeline.
This episode is part three of our series on SSDT and DevOps practices, so if you missed it be sure to check out our previous episodes:
- Episode 1. SQL Server Data Tools for Visual Studio
- Episode 2. SQL Server Data Tools in your DevOps pipeline
Share
Download
More episodes in this series
Modern Dev Practices: Unit Testing
Related episodes
SQL Server Data Tools in your DevOps pipeline
(Part 1) DevOps with Containers: How to Leverage Container virtualization technology for a…
App Compatibility with SQL Server on Linux
Data Analytics at Microsoft (SME roundtable January 2017)
Improve Speed and Reduce Overhead with Containers in Windows Server 2016
Behind the Scenes: Predicting the Early Onset of Brain Disease with BTT IoT Machine…
Exploring top features of SQL Server 2016 that enable BI solutions and improve data…
Time Travelling with Temporal Tables
SQL Server Data Tools for Visual Studio
Latency and Durability with SQL Server 2016
The Discussion
-
freefly Where can I get the sample project?
-
freefly My bad... I saw the link at the end of the video :)
-
kd2718 link at the end of the video should be in the description below
-
Ash I did not find anything about code coverage in this session? I was expecting something like a code coverage report?
-
erickang @Ash:
Code coverage is a great topic to cover in future. Currently SSDT does not have a built in support for the code coverage reporting while it is in the wish-list.
Instead, I have linked a great extension that you would find it interesting. https://the.agilesql.club/blog/Ed-Elliott/2016-01-14/T-SQL-Code-Coverage-In-SSDT
-
LyalinDotCom @kd2718: Thanks for pointing it out. Here are the missing links from the reference slide:
- Slacker Github: https://github.com/vassilvk/slacker/wiki
- SlackerRunner Github: https://github.com/deloitte-solvas/SlackerRunner
- tSQLt: http://tsqlt.org/
AdventureWorks App demo samples:
- Demo db project: https://github.com/erickangMSFT/adventureworksdemo
- Slacker setup for this demo: https://github.com/erickangMSFT/dbunittest-slacker/blob/master/demo/setup.md