Azure SQL Devs’ Corner

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

T-SQL - Azure SQL Devs’ Corner

Generate images with Azure OpenAI Service (DALL-E) and Azure SQL Database

September 25, 2023 Sep 25, 2023 09/25/23
Brian Spendolini
Following on the series of OpenAI posts I have done recently, here is a quick how-to on using DALL-E with External REST endpoint invocation in the Azure SQL Database. Using the OpenAI service in Azure, we can use the image generation REST endpoints to create new and wonderful images such as, if you remember, the cat in the data center. ...

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 3

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon (SQL), 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.

Model your Supply Chain in a Graph Database | Part 4

May 17, 2023 May 17, 2023 05/17/23
authorsJerry Nixon (SQL), 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.

Change Tracking in Azure SQL Database

May 1, 2023 May 1, 2023 05/1/23
Brian Spendolini
The Azure SQL Database has two main ways to track changes with data (rows/DML) as well as table changes. One of those methods is Change Tracking with the other being Change Data Capture. Today’s post will be going into depth on Change Tracking. Change Tracking and Change Data Capture So, what’s the difference between the two? Change Data...

CTEs, Views or Temp Tables?

January 20, 2023 Jan 20, 2023 01/20/23
Davide Mauri
I've just finished watching the video from the @GuyInACube about Common Table Expressions and I noticed that in several comments there was the request to explain what is the difference between Common Table Expressions, Views and Temp Tables. This is quite a common question, and it is time to give it a simple, concise, and clear answer...