How Microsoft's new, open-source Data API builder fits into Solution Architecture

2025

TL; DR

Learn how a Data API can positively impact your database performance, your security profile, and your source code.

Session Details

Software Architects choose tools and patterns with an eye toward cost, time, shelf-life, and standard features. Data API builder is not source generation — it's Microsoft's free Data API engine that exposes secure REST & GraphQL endpoints over SQL Server, Postgres, MySQL, and Azure Cosmos DB, whether in Azure, on-premises, or even in AWS or GCP. In this session, we'll discuss security & architecture options, and when to use GraphQL versus REST endpoints.

3 things you'll get out of this session

Teach developers about Data API builder. It is a very important part of the SQL developer strategy. It is open-source, free, and runs on-prem or in any cloud.

Jerry Nixon's other proposed sessions for 2026

Introducing the SQL MCP Server - 2026

Modern Architecture 101 for New Engineers & Forgetful Architects - 2026

The AI Hiding in your Data - 2026

Jerry Nixon's previous sessions

Workflows of Highly Functional App & Data Engineering Teams

Explore best practices in enterprise data engineering, focusing on Schema Management, Standards Enforcement, Database Testing, & Automated Deployment. Navigate Microsoft's complex options to achieve change management, observability, & quality at scale. Goals: Master schema control, ensure engineering quality, & streamline delivery through automation.

A Deep Dive into DevOps Practices with Azure SQL

Explore the intricacies of DevOps practices tailored for Azure SQL in this demo-heavy session, highlighting both the inner and outer development loops. Embark on a journey through the essential principles of Database version control, Immutable Database Infrastructure, Schema Management, Testing, and Seamless CI/CD. Bid farewell to the notorious "But it worked on my computer!" dilemma by embracing robust DevOps practices, fostering trust and efficiency across your development cycles—from local environments to the expansive cloud. Navigate the array of Azure SQL tools for DevOps practices with potent command-line tools, and uncover seamless integration with industry-leading third-party tools such as GitHub Actions, Codespaces, Terraform, and extensions for popular IDEs like VS Code and Azure Data Studio.

A Deep Dive into Microsoft Fabric Data Warehouse

Deep Dive into Data Warehousing in Microsoft Fabric. Explore the intricacies of Microsoft Fabric Data Warehouse, unraveling its capabilities and demonstrating effective strategies for its utilization.