Azure SQL Devs’ Corner

Avoid T-SQL anti-patterns with the free T-SQL analysis tool

T-SQL Analyzer is a free, open-source, cross platform command line tool for identifying, and reporting the presence of anti-patterns and desig...

4 days ago

Efficiently and Elegantly Modeling Embeddings in Azure SQL and SQL Server

Storing and querying text embeddings in a database it might seem challenging, but with the right schema design, it’s not only possible, ...

6 days ago

MSSQL Extension for VS Code: Introducing Schema Compare (Preview)

Overview We are excited to introduce Schema Compare in the MSSQL Extension for VS Code! It can be tedious to manually manage and synchronize d...

12 days ago

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 response_format parameter. This ...

21 days ago

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

1 month ago

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

1 month ago

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

1 month ago

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

1 month ago

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

1 month ago

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

1 month ago