Azure SQL Dev Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
Updated .NET and JDBC Drivers with Native Vector Data Support for High-Performance AI Workload
We’ve just released major updates to our data access libraries, bringing native support for vector data to both the .NET and JDBC ecosystems, unlocking significant performance gains for AI and machine learning workloads. Microsoft.Data.SqlClient 6.1.0 With the new class, you can now handle vector data in binary format, replacing the slower JSON array approach. This means: Check out the official documentation with a sample: Native vector data type .NET Driver Support For all details, check out the release notes: https://github.com/dotnet/SqlClient/releases/tag/v6.1.0 Microsoft JDBC Driver ...
Announcing General Availability of UNISTR function and ANSI SQL || Operator in Azure SQL
We’re excited to announce the General Availability (GA) of two long-standing capabilities that address critical needs for SQL developers and enterprise customers in Azure SQL Database and Azure SQL Managed Instance, configured with the Always-up-to-date update policy: These additions improve ANSI SQL compliance in Azure SQL, streamline migration from other platforms, and boost developer productivity. UNISTR function: Unicode made easy The UNISTR function provides support for Unicode string literals by letting you specify the Unicode encoding value of characters in the string, making...
MSSQL Extension for VS Code: Agent Mode Updates, Colored Connections, and Schema Designer Enhancements
The MSSQL Extension for VS Code keeps getting better—bringing thoughtful updates that make SQL development more conversational, more visual, and more local. In version v1.34.0, we’ve focused this release on deepening GitHub Copilot Agent Mode, improving connection clarity through color-coded indicators, making local container workflows more flexible, enhancing the Schema Designer, and solving bugs across the experience. Here’s a look at what’s new in this release and how it helps simplify your SQL development workflow. What’s new in MSSQL extension for VS Code v1.34 This release includes three major improvem...
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. Deployments are already underway, and several regions have begun receiving the feature. What is going GA? Integrated Vector Data Type Azure SQL introduces a dedicated VECTOR data type that simplifies the creation, storage, and querying of high-dimensional vector embeddings  vector embeddings directly within your relational database. Built-in Vector Functions Includes essential vector operations like: VECTOR_DISTANCE , VECTOR_NORM  VECTOR_NORMALIZE. Read ...
MSSQL Extension for VS Code: Local Containers, GitHub Copilot Agent Mode and Connection Groups
The MSSQL Extension for VS Code continues to evolve, bringing powerful new features that make SQL development more local, more organized, and more intelligent. In version v1.33.0, we’re introducing Local SQL Server container, GitHub Copilot Agent Mode, and Connection Groups—three capabilities designed to simplify and modernize the way developers build applications using SQL Server in Visual Studio Code. Here’s a closer look at what’s included in this release and how these features can enhance your SQL development workflow. What’s new in MSSQL extension for VS Code v1.33 This release introduces three major ca...
SQL Server 2025 CTP 2.1: DiskANN Improvements
I'm happy to announce that SQL Server 2025 CTP 2.1 is now available, and it brings significant improvements to DiskANN support. While DiskANN remains in preview, each release continues to remove limitations and boost performance. In this release, we’ve made a particularly notable leap in vector index creation speed, with more enhancements on the horizon. What’s New in DiskANN DiskANN is Microsoft’s algorithm for large-scale vector search and recommendation systems. It’s designed to scale to web-sized datasets while maintaining high recall and performance. With SQL Server 2025, DiskANN is fully integrated in...
An open-source AutoScaler for Azure SQL Hyperscale Elastic Pools
TrackAbout is a worldwide provider of SaaS applications for tracking reusable, durable, physical assets like chemical containers and gas cylinders. With over 22 million physical assets tracked across 350 customers, each with their own Azure SQL database, optimizing our infrastructure for both cost and performance is a critical, ongoing mission. Our journey with Microsoft technologies goes back to our founding in 2002. We started by racking our own servers, moved to managed hosting, and finally migrated to Azure in 2016 to gain more control and scalability. A core part of our architecture today is Azure SQL...
A story of collaborating agents: chatting with your database the right way
Today, more and more customers are embracing AI with one clear goal in mind: they want to chat with their data. And by "data," they mean all of it: structured tables, unstructured documents, images, audio, and more. This demand has given rise to hybrid approaches that blend semantic understanding with precise data retrieval. But here’s the challenge: while embeddings and vector search play a critical role in semantic search, they’re not enough on their own — especially when the question is highly specific and demands an exact answer. As I discussed in Improve the “R” in RAG and Embrace Agentic RAG in Azure...
Azure SQL Cryptozoology AI Embeddings Lab Now Available!
Missed out on MS Build 2025? No worries! Our lab is now available for your exploration. Dive into a unique cryptozoology experience using Azure SQL and Azure AI to uncover intriguing (and true) connections among cryptids worldwide. Curious about who would reign supreme in a battle royal or which regions of the world hold the key to encountering these mysterious creatures? Embark on a journey of discovery with the Azure SQL Cryptozoology AI Embeddings Lab! Discover more HERE!