Jerry Nixon (SQL)

Senior Program Manager, Azure SQL

Post by this author

Relationship Advice from Data API builder

Data API builder exposes REST endpoints for MySQL, PostgreSQL, Cosmos DB, SQL Server and Azure SQL. REST (Representational State Transfer) endpoints allow developers to easily query a single table, view or stored procedure. However, Data API builder also exposes GraphQL endpoints. Like REST, GraphQL returns data, but unlike REST, GraphQL can ...

Build your API with DAB. Build your client with Kiota!

Project Kiota is a code generation engine from Microsoft that reads the OpenAPI specification emitted from any REST endpoint and then creates reusable client code in CSharp, Go, Java, PHP, Python, Ruby, Swift, and TypeScript. Kiota is a byproduct of Microsoft Graph, a sophisticated REST endpoint that required developers to write boilerplate ...

Data API builder Now Supports ENV Files

In September, Data API builder (DAB) revved with some great new features. In this article we’ll talk about controlling environment variables with ENV files. What is Data API builder? DAB is an open source, cross-platform engine that creates instant REST & GraphQL APIs for your database - MySQL, Postgres, Cosmos DB or Microsoft SQL. Without any code, DAB uses only a JSON configuration file that explains how to access your data and what objects to expose.

Model your Supply Chain in a Graph Database | Part 1

In this article, we'll explore the fascinating intersection of supply chains and graph databases. We'll explore the intricacies of supply chains, understand their complexities, and explore the practical benefits of utilizing graph databases for modeling and optimizing these networks.

Model your Supply Chain in a Graph Database | Part 2

In Part 2 of our series, we explore the practical aspects of enabling SQL Graph for modeling supply chains, including creating tables for nodes and edges and inserting data into them. We also introduce the MATCH keyword for querying graph data, simplifying the retrieval of information based on relationships between entities.

Model your Supply Chain in a Graph Database | Part 3

In Part 3 of our series, we delve into the rewards that graph databases bring to supply chain modeling. We explore the clarity achieved through the MATCH keyword, enabling precise communication between technical and business teams. Validation becomes seamless as stakeholders intuitively analyze the graph, uncovering missing relationships and enriching data.

Model your Supply Chain in a Graph Database | Part 4

In Part 4 of our series, we explore the power of graph visualization in understanding and analyzing supply chain data. Using tools like PowerBI and the force-directed graph visual, we transform our SQL Graph data into an interactive and shareable format. The visualization allows us to easily comprehend the relationships within the supply chain, make discoveries, and make informed decisions. With SQL Graph, we combine the familiarity of Azure SQL with the advantages of graph modeling, providing clarity and precision when communicating with stakeholders.