Azure SQL Devs’ Corner

Generate images with Azure OpenAI Service (DALL-E) and Azure SQL Database

September 25, 2023 Sep 25, 2023 09/25/23

Brian Spendolini

Following on the series of OpenAI posts I have done recently, here is a quick how-to on using DALL-E with External REST endpoint invocation in the Azure SQL Database. Using the OpenAI service in Azure, we can use the image generation REST endpoints to create new and wonderful images such as, if you remember, the cat in the data center. ...

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

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

Model your Supply Chain in a Graph Database | Part 4

May 17, 2023 May 17, 2023 05/17/23

Jerry Nixon (SQL), Arvind Shyamsundar

In Part 4 of our series, we explore the power of graph visualization in understanding and analyzing supply chain data. Using tools like PowerBI and the force-directed graph visual, we transform our SQL Graph data into an interactive and shareable format. The visualization allows us to easily comprehend the relationships within the supply chain, make discoveries, and make informed decisions. With SQL Graph, we combine the familiarity of Azure SQL with the advantages of graph modeling, providing clarity and precision when communicating with stakeholders.