- Dev Blogs
- Azure SQL Devs’ Corner
Azure SQL Devs’ Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts

Azure SQL Database Elastic Jobs preview refresh

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 significantly enhanced to provide new experience and support these new capabilities. For more details see my Azure SQL Blog

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

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 code over and over - but not with Kiota. In the same way that the Data API builder (DAB) says, "Don't waste your time writing API code for your data," Kiota says, "Don't waste time writing client code for your API." A perfect friendship of technologies. Build your API wit...

OpenAPI for your Azure SQL database

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 is impressive to see it in action. You can quickly transform your database tables, views or stored procedures into standard, modern, scalable, REST endpoints that are accessible to everyone. For this example, in just a few minutes, I converted the AdventureWorksLT sample...

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

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 find the most relevant sessions for my interests. I used the session abstracts of a conference as input and converted them into embeddings using OpenAI's natural language processing capabilities. Then, I used vector search to compare the embeddings with a query topic and rank ...

Creating a Kubernetes Application for Azure SQL Database

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 performance, developers are required to ensure the application scales and performs well and is supportable on multiple platforms. For that last requirement, bundling up the application into Container technologies such as Docker and deploying multiple Containers onto the Kubernetes plat...

New Azure SQL Database free offer

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 database per Azure subscription and is ideal for new Azure customers looking to develop for free, learn SQL, or create a proof of concept, as well as existing Azure customers that are considering adding another database. Get started today To learn more about the offer, see Az...

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

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. So how did I create such an amazing image? Let's take a look at how you can generate images with Azure OpenAI and Azure SQL Database. Image Generation with Azure OpenAI The endpoint syntax for image generation is: And you can add some options via the request body: ...

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: (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 the Azure SQL Database Taking inspiration from Buck Woody's blog "Secure your AI using SQL Server Machine Learning with Microsoft Azure OpenAI Services", what can we do in Azure SQL Database if we don't have access to SQL Server Machine Learning Services? We can use External...