Getting Started with tSQLt: Your First Passing Test
A step-by-step walkthrough of installing tSQLt in a fresh SQL Server database and writing your first unit test from scratch.
Read MoretSQLt Unit Testing & CI/CD Consulting
Ship SQL Code You Can Actually Trust
Remote consulting for teams adopting tSQLt unit testing and SQL Server CI/CD pipelines. From setup to code review — without pulling anyone off their day job.
Used tSQLt professionally for 10+ years · Remote-friendly · Works with your existing team
SalesTests.sql
1
-- Test: uspGetCustomerOrders returns empty set
2
-- when customer has no orders
3
4
CREATE PROCEDURE [Sales].[test uspGetCustomerOrders]
5
returns empty set for new customer]
6
AS BEGIN
7
8
EXEC tSQLt.FakeTable 'Sales', 'Orders';
9
10
EXEC tSQLt.AssertEmptyTable
11
@TableName = 'actual';
12
13
END;
14
10+ years with tSQLt in productionJenkins & Azure DevOps CI/CD pipelinesSQL Server 2012–2022Remote team onboarding
What I Can Help You With
Whether you're starting from zero or untangling an existing pipeline, I work remotely with your team to get it done.
tSQLt Setup & Configuration
Get tSQLt installed, configured, and running in your SQL Server environment. I'll set up your test schemas, mock infrastructure, and make sure your first test passes.
CI/CD Pipeline Integration
Wire tSQLt into your Jenkins, Azure DevOps, or GitHub Actions pipeline. Tests run automatically on every commit. No more 'works on my machine.'
Team Training & Code Review
I'll work directly with your developers — reviewing PRs, answering questions in Slack or Teams, and helping your team build the muscle memory for database TDD.
All engagements are remote. I work async-first with on-call pairing sessions as needed.
Remote. Async-first. No Disruption.
01
Discovery Call (Free)
30 minutes to understand your environment, your pipeline, and what's blocking you.
02
Scoped Engagement
We agree on a clear scope — setup, integration, training, or all three. Fixed-rate or hourly.
03
Hands-On Delivery
I work alongside your team remotely. Code reviews, Slack/Teams access, documentation, and handoff.
About the Consultant
About Greg Duffie
I'm a full-time senior SQL Server developer and have been using tSQLt in production CI/CD environments for over a decade. I built SQLTesting.com to share what I've learned and to help teams who want to adopt unit testing without hiring a full-time DevOps engineer.
My name is in the commit history on SQL Server projects at companies across multiple industries. I know how messy legacy databases get, and I know how to introduce testing without blowing up the release schedule.
G
Greg Duffie
SQL Server Consultant
SpecialtytSQLt & CI/CD
Experience10+ years
LocationRemote
AvailabilityTaking clients
Available for new engagements
From the Blog
Practical guides on tSQLt, SQL Server CI/CD, and database testing patterns.
Mocking Tables with FakeTable: When and Why
FakeTable is one of tSQLt's most powerful features. Learn how to isolate your stored procedures from real data during testing.
Read MoreRunning tSQLt Tests in a Jenkins Pipeline
A practical guide to wiring tSQLt test execution into a Jenkins declarative pipeline with failure reporting and artifacts.
Read MoreFree Consultation
Schedule Your Free Call
Ready to adopt tSQLt unit testing or modernize your SQL Server CI/CD pipeline? Fill out the form and Greg will reach out to discuss next steps.