Entity Framework Is Not the Problem. You Are.

Entity Framework gets blamed for a lot of things: being slow, generating terrible SQL, and not being fit for serious applications.

Peter Kruis and Tonie Huizer are here to be honest: most of the time, Entity Framework is not the real problem.

In this demo-heavy session, they will take the kind of code developers write every day and push it straight into disaster. N+1 queries, lazy loading in the wrong places, oversized includes, missing indexes, zero profiling, and complete trust in whatever SQL happens to come out the other end. In other words: bad bad bad practices, live on stage.

Step by step, Peter and Tonie will show how innocent-looking C# can turn into painfully inefficient database behavior, why performance problems often come from usage rather than the framework itself, and how quickly the truth appears once you stop guessing and start looking under the hood.

And since blaming Entity Framework only works until the evidence shows up, Peter and Tonie will reveal their secret weapon: a merciless look beneath the surface that exposes exactly where things go off the rails. The generated SQL does not lie. It simply shines a very uncomfortable spotlight on the shortcuts, assumptions, and bad habits developers usually hope stay hidden.

Expect sharp examples, live demos, ugly code, hard lessons, and practical takeaways to help you write faster, cleaner, and far less embarrassing data access code.

Because sometimes using EF is just fine.
You’re just using it wrong.

Data Platform Bingo: Deployment Edition

An interactive 60-minute session on the failures, fixes, and hard-earned lessons behind modern data delivery.

The concept is simple: the audience gets a bingo card filled with recognizable data-platform disasters. During the session, two energetic Data Platform MVPs pull scenarios, ask the audience if they have seen them, tell short war stories, and explain what should have happened instead.

As the audience races to complete their bingo cards, the presenters translate every deployment disaster into a practical Database DevOps lesson. We cover version control, release flow, ownership, automation, approvals, testing, migrations, data movement, performance and, of course, communication.

This session is part AMA, part technical post-mortem, and part therapy session for data professionals. You will laugh, probably recognize too much, and leave with practical ways to make your next database deployment, data pipeline or platform migration a lot less bingo-worthy.

Maybe your deployment process felt like a game of chance, but it's now time to stop playing bingo with production and join our session!

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.

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.

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.

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.