Take the first step towards building your winning team

Click now to get your FREE copy of our Agile Transformation starter guide.
Email address
First Name
Last Name
Secure and Spam free...

Unit Testing SQL Server Using Slacker: Tutorial One

Unit Testing SQL Server using SLacker

Unit tests are used to check if small chunks of code are functioning as they should. It allows developers and stakeholders to verify that the code being implemented meets specification. Databases have not always benefited from unit testing. However, in recent times, multiple tools have emerged that allow us to tackle this problem.


In this short video series, we will be demonstrating how to use a tool called Slacker built in the Ruby programming language to unit test a SQL Server database instance. Slacker is a transactional RSpec-based framework for developing automated tests for SQL Server (2005-2017) programmable objects such as stored procedures, scalar/table functions, triggers, etc. The framework has the added benefit of being able to be integrated into the Visual Studio built-in Unit Test Runner.  This allows it to add value and advance confidence in the development of your database. 

Here’s the first video in the series.

Tutorial One: Slacker SQL Server Setup



Jamel is QA engineer at QualityWorks who specializes in Automation using Node.js and Unit Testing SQL Server Databases. Outside of the workspace, he's an adventure junkie with a love for nature and basketball.

This entry has 0 replies

Comments open

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>