Azure SQL Devs’ Corner

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

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

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

Creating a Kubernetes Application for Azure SQL Database

(image) 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 ...

Planning new scenarios and use cases for Azure SQL Database local development experience!

At Microsoft Build 2022 we've announced the new Azure SQL Database local development experience to the world. The combination of Visual Studio Code and Azure Data Studio extensions in addition to the new Azure SQL Database emulator for local and offline database development are aimed to significantly improve developers' experience and boost ...

Create REST API in Python with Django, using the Django REST Framework and Azure SQL

Django is a Python-based open-source web framework. It is a popular and well-liked web framework among developers all around the world. But wouldn't it be amazing to build a website with Django while also taking advantage of Azure SQL database's security, performance, high availability, and other great capabilities? In this article, we will...

Practical Azure SQL Database for Modern Developers

Practical Azure SQL Database for Modern Developers: a book to learn how to take advantage of the all the breakthrough technologies available in Azure SQL like columnstore, in-memory lock-free tables, row-level-security, graph and geospatial support to create modern, scalable and secure applications.