Azure SQL Dev Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
NL2SQL with LangChain and Azure SQL Database
LangChain is an open-source framework for creating applications that use and are powered by language models (LLM/MLM/SML). In this post, basic LangChain components (toolkits, chains, agents) will be used to create a natural language to SQL prompt that will allow interactions with an Azure SQL Database; just ask the database what you want as if speaking to another person. Getting Started Looking at the python notebook used for this sample, you may notice in the repository there are 2. One is using OpenAI and the other is using Azure OpenAI. This post will be using the OpenAI notebook. The differences are...
Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale
Build highly scalable, AI-ready applications on Azure SQL Database Hyperscale AI and cloud-native applications built for the future need a highly scalable, cloud native database with excellent price-performance. For applications operating on mission-critical relational data, Azure SQL Database Hyperscale provides the performance, reliability and security you expect from Azure SQL – but at the same price as commercial open source databases. SQL Database Hyperscale delivers consistently high performance at any scale, standing above the competition. Combined with a new lower price, choosing the right relational ...
Build your APIs with DAB using Containers – Part 2
Are you tired of spending countless hours building APIs from scratch? With Data API builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL, or MySQL database. Using containers with DAB (Data API Builder for short) provides a consistent, isolated, portable, and lightweight local development experience that makes team collaboration easier. Once the local development is completed, one possible next step is to de...
Using AI for Content Moderation with Azure SQL Database
In my previous posts, I have covered using Azure OpenAI services with Azure SQL Database via REST endpoints. This post with further explore that pathway by creating stored procedures you can use to encapsulate the REST calls and combine them with custom business logic for AI content moderation with Azure SQL Database. A Quick Introduction The services to being used in this post are the new Azure AI Content Safety service and the Azure AI Language service. Azure AI Content Safety is a solution designed to detect harmful user-generated and AI-generated content in applications and services. It can detect such cont...
Chat with your data in Azure SQL Database
Welcome to the exploration of how to chat with your data in Azure SQL Database. Being able to interact with your data more intuitively and conversationally can significantly enhance your data analysis and decision-making processes. This blog post will guide you through the process of setting up a chat interface for your Azure SQL Database, using an eCommerce database as an example. Whether you’re a data scientist, a developer, or just a curious learner, this guide will provide you with a new perspective on interacting with your data. Create Azure AI Search The first step is to create an Azure AI search resource...
Relationship Advice from Data API builder
Data API builder exposes REST endpoints for MySQL, PostgreSQL, Cosmos DB, SQL Server and Azure SQL. REST (Representational State Transfer) endpoints allow developers to easily query a single table, view or stored procedure. However, Data API builder also exposes GraphQL endpoints. Like REST, GraphQL returns data, but unlike REST, GraphQL can return data from multiple related tables in nested results. This includes one-to-many, many-to-many, and many-to-one relationships. This diagram illustrates a simple database that uses all three relationships. Data API builder supports each, but to do so it is required...
Build your APIs with DAB using Containers – Part 1
Are you tired of spending countless hours building APIs from scratch? With Data API Builder (DAB), you can create your API in just minutes! All you need to do is create a JSON configuration file to describe your database entities (tables, views, stored procedures, or collections) from your Azure SQL Database, SQL Server, Cosmos DB, PostgreSQL, or MySQL database. In this blog series, I will share a few examples of how to build your APIs with DAB using containers! Using containers to build your APIs with DAB provides a consistent, isolated, portable, and lightweight local development experience that makes team col...
Winter 2023 Service Update for External REST Endpoint Invocation
As December approaches, it's time for the winter 2023 update for External REST Endpoint Invocation. We have added four new Azure Service Endpoints: Bing Search, Azure Key Vault, Azure Communication Services, and Azure AI Search. Let's look at a few examples of using these new endpoints. Bing Search Endpoints Bing Seach has many useful API endpoints other than just search; the endpoints include autosuggest, image search, news search, and spell check to name a few. Search Let's start with a regular search example. In this code example and external REST endpoint Invocation, we are going to call the search endpoi...
Data API builder 0.9.7 Released
There has been a lot of news and exciting announcements in the past days and Data API builder now join the long list of releases that you don't want to miss. Version 0.9.7 introduces some interesting features, especially around observability and logging, to make it easier to figure out what's going on behind the scenes. Enable Application Insights when self-hosting DAB Logs can now be streamed to Application Insights for a better monitoring and debugging experience, especially when Data API builder is deployed in Azure. A new  section can be added to the configuration file to enable and configure integration wi...