Azure SQL Devs’ Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Featured posts
Announcing General Availability of Native Vector Type & Functions in Azure SQL
We are happy to announce that Native vector support in Azure SQL Database and Azure SQL Managed Instance is moving to General Availability this summer. Deploym...
Latest posts
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 t...
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...
Announcing New Lower Price Tier for Cloud Native Applications on Azure SQL
Today we are announcing a new pricing tier for Azure SQL Database targeted at developers building cloud native applications. It is based on Azure SQL Database Hyperscale tier, which offers awesome cloud scalability with one of the lowest TCO in the industry. Azure SQL Database Hyperscale delivers outstanding performance and scalability through adaptive, cloud native resource management, optimized for the workload patterns of each database application. Hyperscale storage scales automatically, providing consistent performance at all scales. Azure SQL Database Hyperscale provides the best database capabilities t...