Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Azure SQL - Azure SQL Devs’ Corner

What’s a Vector Anyway?

May 21, 2024 May 21, 2024 05/21/24
Buck Woody
It's a bit of an understatement to say that Artificial Intelligence (AI), and specifically Generative AI, is at the top of every announcement, news feed, article and discussion lately. Not just in technology, but everywhere. There are a lot of things you to learn to understand not just how to use AI, but how it works. One of those things is ...

Coding at the Speed of Innovation: AI and more with Azure SQL Database

May 17, 2024 May 17, 2024 05/17/24
Asad Khan
As Build 2024 approaches, the Azure SQL Database team is preparing a great line-up of product announcements. Innovation continues to be a big theme as we prepare to showcase exciting experiences powered by SQL data and generative AI. The ideal starting point for the new generation of AI-ready SQL apps is Azure SQL Database, the fully managed ...

Data API builder becomes Generally Available

May 15, 2024 May 15, 2024 05/15/24
Jerry Nixon
Announcing Data API builder General Availability On May 15th, Data API builder becomes Generally Available. Data API builder for Azure SQL Databases – Generally Available (image) It’s been a long road, getting from there to here. Nearly three years ago, Data API builder began as just a dream. How can we reduce the friction for ...

Private Preview for External REST Endpoint Invocation with Azure SQL Managed Instance

April 22, 2024 Apr 22, 2024 04/22/24
Brian Spendolini
We have an exciting opportunity for customers and partners to use External REST Endpoint Invocation with Azure SQL Managed Instance in a private preview. What is Azure SQL Managed Instance? Azure SQL Managed Instance is a PaaS service that has near 100% compatibility with the latest Enterprise Edition SQL Server database engine, providing a ...

Vector Search Optimization via KMeans, Voronoi Cells and Inverted File Index (aka “Cell-Probing”)

April 18, 2024 Apr 18, 2024 04/18/24
Davide Mauri
In a previous article I already mentioned how vectors can be easily stored in Azure SQL already and how to calculate dot product and cosine distance using just T-SQL. In this article I will show how to improve the performance in vector search by using a technique that has many name but is really based on something very well know already: ...

Vanna.ai and Azure SQL Database

April 3, 2024 Apr 3, 2024 04/3/24
Brian Spendolini
Vanna.ai and Microsoft SQL Vanna.ai, in partnership with Azure SQL Database Product Management, bring you a collaboration for using Vanna's natural language to SQL (NL2SQL) agent with the Azure SQL Database. How does Vanna.ai work? First, Vanna is an open-source Python RAG (Retrieval-Augmented Generation) framework for SQL generation/...

Introducing Regular Expression (Regex) Support in Azure SQL DB

March 22, 2024 Mar 22, 2024 03/22/24
Abhiman Tiwari
We are pleased to announce the private preview of regular expressions (regex) support in Azure SQL Database. Regex is a powerful tool that allows you to search, manipulate, and validate text data in flexible ways. With regex support, you can enhance your SQL queries with pattern matching, extraction, replacement, and more. You can also combine...