Azure SQL Devs’ Corner

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

Azure SQL - Azure SQL Devs’ Corner

Make data more human with Azure OpenAI and Azure SQL

April 14, 2023 Apr 14, 2023 04/14/23
Valentina Alto
In January 2023, Microsoft announced the General Availability of the Azure OpenAI Service (AOAI), which allows Azure customers to access OpenAI models directly within their Azure subscription and with their own capacity. (image) There are four models families available at the moment:   (image) In this ...

Data API builder for Azure SQL Databases – Public Preview

March 15, 2023 Mar 15, 2023 03/15/23
Davide Mauri
I am extremely happy and excited to announce the public preview of Data API builder for Azure SQL Databases. Data API builder is a new product that we are adding to the developer’s toolset to help every developer to be more efficient and effective, by instantly and securely turning Azure SQL Databases into a modern REST and GraphQL API. ...

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...

Development with SQL in containers on macOS

January 13, 2023 Jan 13, 2023 01/13/23
Drew Skwiers-Koballa
There are a bunch of tools available for developing with SQL on macOS, including the mssql extension for VS Code and the standalone yet-comfortably-familiar Azure Data Studio. As a developer, you might have heard about the Azure SQL Database emulator and you've most certainly heard about deploying SQL in containers. Most recently, a new option...

Developing with Azure SQL bindings and Azure SQL trigger for Azure Functions

December 13, 2022 Dec 13, 2022 12/13/22
Drew Skwiers-Koballa
The Azure Functions SQL trigger will invoke an Azure Function when data is changed in a SQL database table, enabling new event-driven scenarios with SQL database. Accessing data in a SQL database with Azure Functions can be accomplished more quickly with the Azure SQL bindings for Azure Functions integration.  Azure SQL bindings for Azure ...

Azure SQL Database External REST Endpoints Integration Public Preview

November 16, 2022 Nov 16, 2022 11/16/22
Davide Mauri
(image) The ability to call a REST endpoint natively from Azure SQL Database, which was made available via an Early Adopter Preview in May, is now moving to Public Preview. I'm extremely happy that as of today the new system stored procedure is available to everyone, automatically and transparently: you can use it right away, from any ...