Azure SQL Devs’ Corner
Voices from the Azure SQL PM Team, focusing on development and developers
Latest posts
Predictable LLM results with Structured Output and sp_invoke_external_rest_endpoint
OpenAI recently introduced a powerful new feature for developers: structured output using JSON Schema via the parameter. This makes it possible to request responses from a GPT-4o model that strictly match a given schema—no free-text, no guesswork. If you're working with Azure SQL, this is a game-changer. Combined with the stored procedure and SQL Server's built-in JSON functions, you can now: What Is Structured Output? By default, LLMs like GPT-4 return free-form text—which can be difficult to parse reliably. With structured output, you provide a JSON Schema along with your request, and the m...
Enhancing Search Capabilities in SQL Server and Azure SQL with Hybrid Search and RRF Re-Ranking
In today's data-driven world, delivering precise and contextually relevant search results is critical. SQL Server and Azure SQL Database now enable this through Hybrid Search—a technique that combines traditional full-text search with modern vector similarity search. This allows developers to build intelligent, AI-powered search experiences directly inside the database engine. Funny enough one of the key algorithms needed for implementing Hybrid Search, BM25, has been included in SQL Server is almost forever, without much fanfare: RAG pattern and similarity search is bringing it to the light. What Is Hybrid S...
SQL Conf() 2025 Highlights: So Much Developer Innovation!
For decades, SQL Server has been a cornerstone of data management, evolving to meet the needs of modern developers. What began as a traditional relational engine is now a cloud-enabled, AI-integrated platform designed for building real-world applications. SQL Server continues to meet developers where they are—offering tools, services, and capabilities that simplify complexity and support innovation across the stack. SQL Conf() 2025, held February 26, was a developer marathon built specifically for application developers. While DBAs and data engineers often lead the conversation, this event flipped the focu...
Secure APIs with Data API Builder, Keycloak, and SQL Server
In this article, we'll explore how to create a secure, on-premises API using Data API Builder (DAB), Keycloak, and SQL Server. You'll learn to set up JSON Web Token (JWT) authentication with Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC), and Row-Level Security (RLS), ideal for secure business scenarios. Want to replicate this setup?All the configuration files, SQL scripts, and Docker setup used in this article are available here: https://github.com/yougnoli/secure-onprem-api-dab-keycloak-sqlserver Technologies Overview What We'll Cover RBAC a...
Vector Search with Azure SQL, Semantic Kernel and Entity Framework Core
Vector databases like Qdrant and Milvus are specifically designed to efficiently store, manage, and retrieve embeddings. However, many applications already use relational databases like SQL Server or SQL Azure. In such cases, installing and managing another database can be challenging, especially since these vector databases may not offer all the features of a modern relational database like Azure SQL or SQL Server. This is where the new vector data type in SQL Azure becomes extremely useful. It allows you to create Retrieval-Augmented Generation (RAG) solutions by storing embeddings in the same place as y...
Build a Streamlit application with Fabric SQL Database
Building an application allows you to operationalize the data you have in Microsoft Fabric, such that it can be consumed by stakeholders in your organization to generate business insights. Streamlit is easy to use to build simple applications without needing to know front-end application frameworks like Flask, Django etc. It makes it easier to prototype and visualize your data in Microsoft Fabric with Streamlit framework. In this blog post we will show how to develop an app using Streamlit and Fabric SQL database. Consider a scenario that you are a data engineer in a retail company and want to keep track of y...
Exploring SQL Server Integration with .NET Aspire: A Collection of Hands-On Samples
I'm happy to share a new GitHub repository with developers: azure-sql-db-aspire. This collection of eight hands-on examples demonstrates how to integrate SQL Server and Azure SQL with .NET Aspire, making it easier to build modern, cloud-native applications. Why .NET Aspire for SQL Server? .NET Aspire is a new opinionated, cloud-ready stack for .NET applications that simplifies development, observability, and orchestration. SQL Server and Azure SQL are well-supported, allowing developers to quickly integrate databases into their applications while benefiting from Aspire’s service discovery, dependency injection,...
MSSQL Extension for VS Code: What’s new and what’s next
The MSSQL Extension for VS Code continues to evolve, bringing powerful new features and enhancements that make SQL development more seamless and efficient. In this update, we’re excited to share the latest improvements in v1.29.0 and give you a sneak peek at what’s coming next in our open roadmap. This extension is designed for developers working with Azure SQL (including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs), SQL Database in Fabric (Preview), or SQL Server as a backend. With a rich set of features for connecting to databases, managing schemas, executing queries, and visual...
Exciting new T-SQL features: Regex support, Fuzzy string-matching, and bigint support in DATEADD – preview
We are thrilled to announce the public preview of three powerful T-SQL features that will elevate your SQL queries: Regular Expressions (Regex) support, Fuzzy string-matching, and bigint support in DATEADD. These enhancements are now available in Azure SQL Database and SQL Database in Microsoft Fabric, offering developers more flexibility, efficiency, and precision in their data operations. They will also help simplify complex operations that previously required workarounds or external processing. In this post, we'll explore the capabilities of each feature, provide practical examples, and explain how they wil...