Azure SQL Devs’ Corner

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

Azure SQL - Azure SQL Devs’ Corner

OpenAPI for your Azure SQL database

October 24, 2023 Oct 24, 2023 10/24/23
Davide Mauri
A recent and exciting feature of Data API builder (you may have learned about Data API builder from my previous article, as I used it to quickly make a stored procedure and a table available as REST endpoint to easily integrate with OpenAI) is the compatibility with OpenAPI specifications and Swagger. This was a highly demanded feature, and it...

Creating a Kubernetes Application for Azure SQL Database

October 4, 2023 Oct 4, 2023 10/4/23
Buck Woody
(image) Creating a Kubernetes Application for Azure SQL Database Buck Woody, Principal Applied Data Scientist, Microsoft Modern application development has several challenges. From selecting a "stack" of front-end through data storage and processing from several competing standards, through ensuring the highest levels of security and ...

New Azure SQL Database free offer

September 27, 2023 Sep 27, 2023 09/27/23
Nils Pohlmann
We are excited to announce the public preview of the new Azure SQL Database free offer that gives you a fully featured Azure SQL serverless database with a free amount of 100,000 vCore seconds of compute and 32 GB of storage plus 32 GB of backup storage every month, for the lifetime of your subscription. This offer is available for one ...

Data API builder Now Supports ENV Files

September 20, 2023 Sep 20, 2023 09/20/23
Jerry Nixon
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.

Using OpenAI REST Endpoints with Azure SQL Database

September 5, 2023 Sep 5, 2023 09/5/23
Brian Spendolini
Everyone loves OpenAI these days as it can do some amazing things. Here, I asked it to create a picture of a cat in a data center: (image) (Go ahead and click the image to see a bigger version of this nightmare fuel) Incredible!!!! But how can we use OpenAI in real world applications and scenarios with Azure SQL Database? Using ...

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

Building your own DB Copilot for Azure SQL with Azure OpenAI GPT-4

August 25, 2023 Aug 25, 2023 08/25/23
Valentina Alto
(image) Large Language Models (LLMs) have proven exceptional capabilities in chatting with unstructured, text data. But what if we want to interact with structured data? To do so, we will need to build an LLM-powered Agent which is able to reason over structured data, in our specific case an Azure SQL DB. Luckily for us, we don’t have to ...

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