Azure SQL Devs’ Corner

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

How I built a session recommender in 1 hour using Open AI

October 18, 2023 Oct 18, 2023 10/18/23

Davide Mauri

As a developer, I often attend conferences to learn new skills and network with other professionals. However, conferences can be overwhelming, especially when they offer dozens of sessions on different topics. How can I decide which ones are worth my time and attention? That's why I decided to use OpenAI to create a tool that can help me ...

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

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