Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

T-SQL - Azure SQL Devs’ Corner

Azure SQL Trigger Binding for Azure Functions goes GA

March 14, 2024 Mar 14, 2024 03/14/24
Brian Spendolini
Azure SQL Database Engineering and Product Management would like to announce that Azure SQL Trigger Binding for Azure Functions is now generally available (GA). Catching Up As a quick refresher, the Azure SQL trigger uses SQL change tracking functionality to monitor a SQL table for changes and trigger a function when a row is created, ...

Using AI for Content Moderation with Azure SQL Database

February 12, 2024 Feb 12, 2024 02/12/24
Brian Spendolini
In my previous posts, I have covered using Azure OpenAI services with Azure SQL Database via REST endpoints. This post with further explore that pathway by creating stored procedures you can use to encapsulate the REST calls and combine them with custom business logic for AI content moderation with Azure SQL Database. A Quick Introduction ...

REST Endpoint Invocation is now Generally Available

August 28, 2023 Aug 28, 2023 08/28/23
Brian Spendolini
(image) On behalf of the Engineering and Product Management teams, we are happy to announce that External REST Endpoint Invocation is now GA!   What is External REST Endpoint Invocation? External REST Endpoint Invocation makes it possible for developers to call REST/GraphQL endpoints from other Azure Services from right in the ...

Summer 2023 Update for Azure SQL Database External REST Endpoint Invocation

August 7, 2023 Aug 7, 2023 08/7/23
Brian Spendolini
(image) Summer 2023 REST Endpoint Invocation Update Welcome to the Summer 2023 REST Endpoint Invocation update post! This summer, we updated the External REST Endpoints Invocation feature with a few key fixes and additions to help you use more Azure Services with your Azure SQL Database. The feature was released to public preview last year ...

Model your Supply Chain in a Graph Database | Part 2

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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 4

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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.

Model your Supply Chain in a Graph Database | Part 3

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon, Arvind Shyamsundar
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.