22-25 April 2026 
Data API Builder – Create an API for Your Database in Seconds
Proposed session for SQLBits 2026TL; DR
Want a fast, lightweight way to interact with your SQL Server or PostgreSQL data—especially from automation scripts like PowerShell?
With Data API Builder (DAB), you can stand up a fully functional REST or GraphQL API over your database in minutes, without writing a single line of backend code.
Session Details
Want a fast, lightweight way to interact with your SQL Server or PostgreSQL data—especially from automation scripts like PowerShell?
With Data API Builder (DAB), you can stand up a fully functional REST or GraphQL API over your database in minutes, without writing a single line of backend code.
Once configured, DAB lets you securely read and write data through simple HTTP endpoints, making it perfect for scripting, automation, prototyping, and modern data integration patterns.
In this session, you’ll learn:
- How to expose tables, views, and stored procedures through DAB
- How to run DAB locally or in containers for fast, repeatable environments
- How to call DAB endpoints from PowerShell using Invoke-RestMethod
- Practical scenarios where DAB simplifies data access for DBAs, analysts, and automation engineers
Join me to see how DAB can streamline your workflows and unlock new ways of working with your data.
With Data API Builder (DAB), you can stand up a fully functional REST or GraphQL API over your database in minutes, without writing a single line of backend code.
Once configured, DAB lets you securely read and write data through simple HTTP endpoints, making it perfect for scripting, automation, prototyping, and modern data integration patterns.
In this session, you’ll learn:
- How to expose tables, views, and stored procedures through DAB
- How to run DAB locally or in containers for fast, repeatable environments
- How to call DAB endpoints from PowerShell using Invoke-RestMethod
- Practical scenarios where DAB simplifies data access for DBAs, analysts, and automation engineers
Join me to see how DAB can streamline your workflows and unlock new ways of working with your data.
3 things you'll get out of this session
- Learn what Data API Builder is
- Easily integrate PowerShell scripts with databases
- streamline workflows for data manipulation
Speakers
Jess Pomfret's other proposed sessions for 2026
Automating SQL Server Management with GitHub Actions and PowerShell - 2026
dbatools - Wheel of Fortune - 2026
Jess Pomfret's previous sessions
Managing replication with dbatools
One of the most highly requested dbatools features was for commands to manage replication and now they're here.
In this session, we'll run through the available commands and how they can be used to build up and tear down replication.
Anyone can be an alphabet soup ally
Folks that belong to the queer community are often referred to as LGBTQ+, Jess and Linda represent a small portion of the letters within this alphabet soup and they will guide you through some common situations where you can be a good ally.
There is no one right answer, but there are ways for you to prepare for certain situations so you know what your best move might be to provide support and allyship.
This session will provide tips for people who are new to being an ally and for existing allies who want to add skills to their toolbelt.