Azure SQL Devs’ Corner

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

Data API builder Now Supports ENV Files

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

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

(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

(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

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

How to export Azure SQL Managed Instance data into Fabric Lakehouse

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

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

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