Azure SQL Devs’ Corner

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

Chat with your data in Azure SQL Database

February 6, 2024 Feb 6, 2024 02/6/24
Muazma Zahid
Welcome to the exploration of how to chat with your data in Azure SQL Database. Being able to interact with your data more intuitively and conversationally can significantly enhance your data analysis and decision-making processes. This blog post will guide you through the process of setting up a chat interface for your Azure SQL Database, ...

Relationship Advice from Data API builder

December 18, 2023 Dec 18, 2023 12/18/23
Jerry Nixon (SQL)
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 APIs with DAB using Containers – Part 1

December 12, 2023 Dec 12, 2023 12/12/23
Carlos Robles
Are you tired of spending countless hours building APIs from scratch? With Data API Builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL...

Winter 2023 Service Update for External REST Endpoint Invocation

November 30, 2023 Nov 30, 2023 11/30/23
Brian Spendolini
As December approaches, it's time for the winter 2023 update for External REST Endpoint Invocation. We have added four new Azure Service Endpoints: Bing Search, Azure Key Vault, Azure Communication Services, and Azure AI Search. Let's look at a few examples of using these new endpoints. Bing Search Endpoints Bing Seach has many useful API ...

Data API builder 0.9.7 Released

November 28, 2023 Nov 28, 2023 11/28/23
Davide Mauri
There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don't want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what's going on behind the scenes. Enable Application ...

Vector Search with Azure SQL Database

November 15, 2023 Nov 15, 2023 11/15/23
Muazma Zahid
With public preview of integrated vectorization, a ground-breaking capability of vector search in Azure AI Search (previously Azure Cognitive Search), you can do vector search with data stored in Azure SQL Database easily. This feature is designed to streamline the process of chunking, generating, storing, and querying vectors for vector ...

Azure SQL Database Elastic Jobs preview refresh

November 8, 2023 Nov 8, 2023 11/8/23
Srini Acharya
We are very excited to announce a significant “refresh” to the current Azure SQL Database Elastic Jobs preview! This refresh brings several new capabilities that were highly requested by our customers during the current preview.  Main new capabilities added in this refresh include:  Azure portal has also been ...

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

October 27, 2023 Oct 27, 2023 10/27/23
Jerry Nixon (SQL)
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 ...

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