Azure SQL Devs’ Corner

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

Building Course Registration Project with Azure SQL Database

June 11, 2024 Jun 11, 2024 06/11/24
authorsAnagha Todalbagi, Kendall Hoffman
This semester long project was completed by Master's students at Cornell University with mentorship from the Azure SQL database product team at Microsoft.   Project Mission The purpose of this project is to design a high-fidelity university course registration system utilizing Microsoft Azure cloud services. Our target audience ...

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

Data API builder Version 0.11 Brings In-Memory Caching

April 18, 2024 Apr 18, 2024 04/18/24
Jerry Nixon
Literally, I just said that! I have three daughters, and it's amazing how they ask me the same questions over and over. I don't mind answering them, but I sure wish they would either remember my answer or, at least, write it down. There's a measurable cognitive load with the context switching and staying consistent in my answers. And that's 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: ...