We Organized a Community Event and All We Got Are These Lousy Stickers

What began as a small conversation over coffee turned into a rollercoaster: visiting venues, finding sponsors, drafting event plans over stuttering Wi-Fi, rethinking session schedules, and designing an endless stream of mascot memes (shoutout to SeaQL Sammie).

We thought we were ready for anything. But struggling to buy off drinks during the day? But eventually we found the perfect venue to bring it all together.

In this session, we’ll walk you through our behind-the-scenes journey of organizing a data event from scratch. You’ll hear about first inspiration, the chaos we created and controlled, the spreadsheets with way too many tabs (each with its own format), and the everlasting moments that made it all worth it.

Thankfully, we weren’t flying blind. The SQL Saturday Checklist was a lifesaver, giving structure to our chaos and helping us stay (mostly) sane. No marketing fluff. No corporate slide decks. Just two passionate community members sharing what it’s really like to bring an event to life; with all the lessons, facepalms, and laughs that come with it.

If you’ve ever dreamed of hosting your own event or just want a peek behind the curtain; come join the story.
And yes, there will be stickers. You get a sticker! You get a sticker! Everyone gets a sticker!

Two Developers, One Mission: Make a Test Database That Doesn’t Suck

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.

The Database DevOps (CI/CD) Showdown: Team Migration vs Team State

Use version control and automate your deployments, is what you hear. But for database
development it isn't that simple; the struggle over using a shared or personal database, how to
handle object conflicts or the fight over choosing state- or migration- based deployments?
This is why two seasoned Database DevOps warriors will enter the ring to settle this “fight” in
which they'll share their hard-earned knowledge, equipping you with the tools and tactics to
decide what to use, when to use it, and why.
“Ladies and gentlemen, in the left corner, Team Migration, with the lineup of Flyway, Grate, and
EF Core, guided by Coach Tonie. And in the right corner, representing Team State, we have SSDT,
Database Projects, and schema comparing tools, all under the expert of Coach Olivier.”Step
into our 4-round battle where we start by gearing you up with the essential concepts and tools.
Round 1 sets the stage, showing you how to get your systems up and running, ready for hands on combat. As Round 2 rings, we will intensify the action, demonstrating you the skills needed
for collaborative database development. Round 3 reveals the contrasting deployment tactics of
our contenders, while the final round focuses on mastering CI/CD automation with Azure
DevOps, essential moves for any DevOps warrior.
Does this sound like a fight for you? Sign up for our pre-con to be a contender, because “Every
champion was once a contender who refused to give up.” – Rocky Balboa
P

How to Build Workflow-Driven Database Provisioning in Azure DevOps

You’ve convinced your team to use version control. You’re provisioning dedicated databases. But the process still feels clunky, manual, ‘scripty’, and too dependent on local setups. PowerShell helps, but it lacks consistency. And when it fails, not everyone has the time or skill to fix it.

I’ll walk you through a robust alternative: self-service database provisioning powered by automation and integrated into your team's workflow. You’ll learn how to treat your database environments as part of your platform capability, even for on-prem SQL databases.

We’ll build a setup where starting new work in Azure DevOps automatically provisions fresh databases. Need to switch focus? We’ll cover how to stash and resume your database environments without losing your place. From demo data to cleaning up stale environments, we’ll look at how to manage developer databases as part of a true Internal Developer Platform (IDP).

Expect slides, but mostly real-world code in PowerShell and YAML. You’ll leave with patterns, scripts, and a practical plan to make database delivery faster, easier, and truly self-served; laying the foundation for a lightweight IDP focused on database development.

Get a better developer experience for your team and make database delivery to them self-served!

Ideal for developers, DevOps engineers, and database professionals who want to go beyond local automation and bring platform capabilities to their team.

DIY Disposable Database Clones

Summary:
---------------
Database DevOps techniques require an easy way to provision many copies of a database, even a large database, for development work and especially for testing work. Ideally, these databases should be disposable and easy to create; developers should be able to spin up a copy of a specific version of a database, complete with data, whenever they need it.

In this session we build a basic proof-of-concept system that could give someone the experience in working with the clone technology which is already available in any Windows System and the benefits it can bring to their Database DevOps processes.

This session could be practical for all sorts of Windows-based database systems with large data sizes. The databases are not limited to like SQL Server only, also MariaDB, PostgreSQL, etc. can benefit from this technology.

Topics:
----------
- Introduction to Microsoft Volume Shadow Copy Service (VSS)
- Introduction to Virtual Hard Drives (VHD) and parent disks
- Creating VHDs and VSS copy of databases
- Mounting and unmounting databases (stored on VHD's)
- Cloning with Sqlcollaborative/dbaclone

Audience:
-------------
- Developers that need fast and disposable database copies
- Team manager that see that developer take to much time in provisioning databases (without cloning)

The targeted audience can be developers that need fast and disposable database copies.
But also, team managers that see that developers take too much time in provisioning databases (without cloning).

Other performances with the same subject:
- PASS Data Community Summit 2021
- Article on SQL Server Central
https://www.sqlservercentral.com/articles/diy-database-clones

Git Your Database Under Control: a 1 day VCS + CI/CD workshop for your database development

A 'chaotic' database development will encounter numerous difficulties. The shared development server suffers frequent downtime due to 'breaking changes'. Developers are often 'blocked' waiting for other work to complete. There is little visibility into which objects are being changed and why. Deployments are prone to failure and often cause problems on the live server that require immediate troubleshooting.

If any of this sounds familiar, then this session will allow you to introduce the control, stability, and automation that will lead to much more manageable automated and low risk database deployments.

First, we will set up a repository, create and manage branches, introduce pull requests to visualize the review process that merges the changes into main.

Next stop is an effective branching strategy that aligns with development workflows and facilitates efficient collaboration among team members.

With the repository in place attendees will learn how to automate deploying changes to different environments, using a CI/CD pipelines. Hands-on exercises will give participants the opportunity to practice creating a pipeline and deploying database changes to different environments.

This session is designed for (database) developers and DBAs that are not yet using a version control system for their database (20% of the SQLCentral audience) or those who are already using a version control system other than Git (another 20% of the SQLCentral audience) and finally those who use Git and want to learn how to automate the deployment of their database code.

Participants will gain a strong understanding of how to use Git as a version control system, and a clear roadmap for implementing a successful branching strategy that supports collaborative and distributed working. They will also learn how to set up pipelines for applying database changes using Git, PowerShell, and YAML, and will be equipped with the knowledge and skills to implement a pipeline in their own development workflows. This session is a must-attend for anyone who wants to take their database development to the next level and ensure a smooth and efficient development workflow.

How to use AI, in your professional and personal life

Artificial intelligence (AI) has transcended its buzzword status to become an integral part of professional life for many of us, especially in areas such as data analytics, code generation and semantic search. However, if you're not yet directly involved in an AI project, perhaps you feel like you're struggling to making the best use of AI tools or are still skeptical of the quality of what they can deliver.
If so, this session is for you! It will demonstrate how you can get real value from generative AI tools in both your professional and personal lives. We'll provides practical examples of how AI can improve tasks as diverse as eliminating repetitive work, performing code reviews, optimizing work emails, generating concise meeting notes and actions, and even negotiating salaries!
We'll explain techniques to 'tune' your AI input, the so-called prompt, which in turn will greatly increase the quality and reliability of what the AI Large Language Model (LLM) tools produce. We'll demonstrate how to create and refine custom models, which instruct the tool to tailor its output to your personal style, or to a set of requirements. We'll even find time to have a bit of fun with AI, showing you how to bore your spouse and colleagues with impressive AI-generated images!
The development of AI goes at rocket speed and our session is designed to help you keep up, assuming the pace of changes isn't so fast that we've been replaced by AI before the session starts!

Explore practical AI usage from two approachable data guys, learn step-by-step how to optimize prompts for better outcomes, customize models, and enjoy having fun with creative AI outputs.
All with real world examples, which you can use in your daily (work) life.

Database DevOps...CJ/CD: Continuous Journey Continuous Disaster?

Transforming a team that was used to a SVN-based-big-single-repo work style and little to no automation was a bumpy ride.
Join me in this session where I share my experience in implementing Azure DevOps with Git, automated build and release pipelines and disposable personal databases.

In this session I will tell you about my days as team lead and the challenges I faced while introducing:

DevOps:
- The formal DevOps term and process
- Working with sprints (our 4th attempt)

Git:
- Git as version control to SVN / TFVC people
- Using branches instead of only the master
- Adapting a Git branching strategy

Pipelines:
- Adapting a Build & Release Workflow
- Implementing naming conventions for: repos, branches, builds and releases
- The Introduction (and success) of pipelines
- Manual vs Pull Request Release

Dedicated Environments:
- Working with a database IDP (internal development platform)
- With versioned personal databases
- Including stashing databases when priorities change

Migrating an existing team that is stuck in its ways, critical by nature and fed up with deadlines is an interesting journey you don't always hear about.

But in the end...it's a lot of patience, work and yes it's exhausting, but completely worth it.

Take-aways
1. Insights in a real world DevOps migration / transformation
2. Knowledge and experience sharing on the often forgotten DevOps part: the database
3. Beside all the talking: demonstration with tips you can directly make use of

This session is constantly updated and has been presented at PASS 2022, Data Saturday Gothenburg 2023 and SQL Saturday SW Washington / Oregon 2023.

Amplify Your Experience: How to Start Writing and Speaking

Our goal in this session is to help you get started with sharing your technical knowledge and experience with others, whether it's by publishing an article, or getting up on stage at a conference, or delivering a training session at work.

Finding the best and most effective way to communicate your ideas is a creative process, and one that not all tech professionals find easy. There is no single, defined path that will get you from a vague idea of what you 'could' write or speak about, to an article or presentation that has 'the magic'. However, in this session we're going to share with you some simple techniques that will help you get started and give you the best chance of success.

We'll show you how to explore your 'vague idea' and turn it into a story with a purpose, and an understanding of its audience, the problems they need to solve most urgently and why. The content will start to take shape and structure and, after that, if you follow a few simple rules of communication, you'll be able to explain even complex technical ideas with purpose and clarity, and in a way that others can easily follow. And this is what mean by "amplify your experience". We will show you how to make sure your audience get the maximum benefit from the ideas, the knowledge and experience that you want to share with them.

Once you start using the techniques, you'll find that not only are you able to write an article or give a presentation that hits its audience, but also to communicate more effectively with team members at work and explain your ideas more clearly more clearly to your managers. You'll learn technical communication skills that are of broader benefit to all IT professionals.

The session aims to inspire and equip attendees to share their technical knowledge through writing, publishing, and speaking. The speakers will provide practical tips on effective writing and speaking, including structuring ideas and refining written work.

Attendees will learn how to leverage their experiences and share their work through online channels and conferences.

Code First, Review Later: Making EF Core Work for DBAs

Developers love EF Core for its speed and automation. DBAs fear it for the exact same reason. Automatic migrations can bypass crucial checks, leading to friction, surprises—and the confidence of the database team begins to slip.
Database professionals want transparency and control. They need to review changes before they hit production. But .NET teams often already work with EF Core code-first, and redoing everything in SQL isn’t realistic.
What if you didn’t have to choose?
In this session, you’ll learn how to convert EF Core migrations into Flyway-compatible scripts—giving developers the flexibility they love, and DBAs the control they need.
We’ll walk through real-world examples and automation using PowerShell and YAML—and the recipe for getting devs and DBAs on the same page.

This Level 300 is for attendees with hands-on experience in EF Core and/or database deployments. Assumes familiarity with code-first approaches and general database release pipelines.