Azure SQL Devs’ Corner

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

Azure SQL - Azure SQL Devs’ Corner

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 (SQL)
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: (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 OpenAI with ...

REST Endpoint Invocation is now Generally Available

August 28, 2023 Aug 28, 2023 08/28/23
Brian Spendolini
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 Azure SQL ...

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

August 25, 2023 Aug 25, 2023 08/25/23
Valentina Alto
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 build ...

Summer 2023 Update for Azure SQL Database External REST Endpoint Invocation

August 7, 2023 Aug 7, 2023 08/7/23
Brian Spendolini
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 and this...

How to export Azure SQL Managed Instance data into Fabric Lakehouse

July 11, 2023 Jul 11, 2023 07/11/23
Jovan Popovic
If you want to perform advanced analytics on your data and create stunning reports in Power BI, you should consider using Microsoft Fabric. Microsoft Fabric is a solution that combines the best Lakehouse and Warehouse technologies to provide a scalable, secure, and cost-effective platform for data analytics. With Microsoft Fabric, you can ...

How to copy data from Azure SQL Managed Instance to Microsoft Fabric DW

July 5, 2023 Jul 5, 2023 07/5/23
Jovan Popovic
If you want to perform advanced analytics on your data and create stunning reports in Power BI, you should consider using Microsoft Fabric. Microsoft Fabric is a solution that combines the best data warehousing and data lake technologies to provide a scalable, secure, and cost-effective platform for data analytics. With Microsoft Fabric, you ...

Vector Similarity Search with Azure SQL database and OpenAI

June 4, 2023 Jun 4, 2023 06/4/23
Davide Mauri
Vector databases are gaining quite a lot of interest lately. Using text embeddings and vector operations makes extremely easy to find similar “things”. Things can be articles, photos, products...everything. As one can easily imagine, this ability is great to easily implement suggestions in applications. From providing suggestions on ...