Two Developers, One Mission: Make a Test Database That Doesn’t Suck
Proposed session for SQLBits 2026TL; DR
Tired of messy, unsafe test DBs or restored prod backups? Two high energetic data enthusiasts use role play and live demos to show safer, realistic test data practices. Because let’s face it: your test database shouldn’t suck.
Session Details
If you've ever been frustrated by a test database filled with nonsense, duplicates, sensitive information, or YOLO-style restored production backups, this session is for you.
Join Peter Kruis and Tonie Huizer, two energetic data enthusiasts, on an epic (and slightly chaotic) quest to build test databases that are safe, realistic, and actually useful for development and testing. With decades of combined experience, they’ll take you on a journey through the wild world of test data, showing just how bad it can get, and how good it can be.
Through engaging role play, real-world examples, and live demos, they’ll expose the dangers of shady test environments and share smarter, safer ways to manage test data. Audience participation is encouraged; because (bad) test databases are a team sport!
You’ll leave entertained, but more importantly, you’ll leave with tools and strategies to stop your test database from being the weakest link in your development chain.
Because let’s face it: your test database shouldn’t suck.
Join Peter Kruis and Tonie Huizer, two energetic data enthusiasts, on an epic (and slightly chaotic) quest to build test databases that are safe, realistic, and actually useful for development and testing. With decades of combined experience, they’ll take you on a journey through the wild world of test data, showing just how bad it can get, and how good it can be.
Through engaging role play, real-world examples, and live demos, they’ll expose the dangers of shady test environments and share smarter, safer ways to manage test data. Audience participation is encouraged; because (bad) test databases are a team sport!
You’ll leave entertained, but more importantly, you’ll leave with tools and strategies to stop your test database from being the weakest link in your development chain.
Because let’s face it: your test database shouldn’t suck.
3 things you'll get out of this session
A clear checklist for what makes a test database “good” (realistic, reliable, repeatable and actually useful for development and testing)
Safer and privacy-conscious test data practices you can apply immediately
Practical strategies, a list of free and paid app (including demos) to upgrade your current test DB setup
Speakers
Tonie Huizer's other proposed sessions for 2026
Amplify Your Experience: How to Start Writing and Speaking - 2026
Code First, Review Later: Making EF Core Work for DBAs - 2026
How to Build Workflow-Driven Database Provisioning in Azure DevOps - 2026
How to Build Workflow-Driven Database Provisioning in Azure DevOps - 2026
Unexpected SQL + documentation workflows with AI agents (Codex, Copilot and beyond) - 2026
Peter Kruis
Peter Kruis's other proposed sessions for 2026
An introduction to Extended Events - 2026
From GUI to Scripting: PowerShell for the DBA - 2026
Query Store Basics: A DBA’s Best Friend - 2026
Waitstats for the accidental DBA - 2026