What is Fabric-toolbox & why care? Data API Builder: Create DB APIs in Seconds
Details
Location: iO Associates, St Bartholomew's House, Bristol BS1 2NH.
Sponsored and Hosted by iO Associates (Tech & Digital recruitment specialists), we bring you an evening of Data and Networking.
AGENDA
18.00 – 18:25 Meet & Greet
--------------
18:25 - 18:30 Introduction & Welcome
Welcome, and thanks to our sponsors
--------------
18:30 - 19:15 Talk: Data API Builder – Create an API for Your Database in Seconds by Jess Pomfret
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.
--------------
19:00 - 19:30 Pizza and Networking
--------------
19:30 - 20:15 Talk: What is fabric-toolbox and why should I care? by Rob Sewell
The fabric-toolbox is Microsoft's growing open-source repository of accelerators, tools, and scripts built to solve real Fabric challenges. In this session we'll tour the toolbox — from FUAM, the Fabric Unified Admin Monitoring solution that gives you deep tenant visibility beyond the 14-day Capacity Metrics limit, to FCA for FinOps cost analysis, DAX performance testing, Semantic Model auditing, Data Factory migration assistance, and the MicrosoftFabricMgmt PowerShell module with 295+ cmdlets covering 48 resource types. Whether you're an admin, developer, or architect, there's something here for you. Leave knowing exactly which tools to reach for and how to get started.
--------------
20:15 - Social/Pub
---
Speaker Bios
Database engineer with a passion for automation.
Jess Pomfret is a Data Platform Engineer and a dual Microsoft MVP. She started working with SQL Server in 2011, and enjoys problem-solving and automating processes with PowerShell.
She also enjoys contributing to dbatools and dbachecks, two open source PowerShell modules that aid DBAs with automating the management of SQL Server instances. She has also contributed to the SqlServerDsc module, adding several new resources to use when configuring your SQL Servers.
She grew up in the South West of England and outside of her DBA life enjoys Crossfit, cycling and watching proper football.
Chief Data Officer - Beard Twizzler
Exeter, United Kingdom
Rob was a SQL Server DBA with a passion for PowerShell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people make things. He is a Data Platform MVP and an Azure MVP, a PowerShell Conference Europe organiser, and maintainer of many open-source projects. He has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Social Medias and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, he is often out riding his bike as his eyes are not good enough to play cricket any more.
----
Photos
We ask that you do NOT take photos at this meetup.
We will invite people to be included in a group photo/s during the event. Speakers will let you know if it's okay to photograph their presentation (excluding other attendees).
You may see organisers taking photos during the talks. These will be of speakers, if they have agreed to this, and will not include faces of attendees.
