Showing archive results for March 2026

SQL code analysis has been part of the SSDT workflow for a long time. Before deploying a schema change, you could run a set of static analysis rules against your project to catch potential issues, things like missing primary keys, deprecated syntax, or objects that could break under certain compatibility levels. It was one of those SSDT features th...

Making schema changes often means jumping between tools. You write code in VS Code, then switch to a separate tool to deploy your changes : exporting a script, running it manually, or copy-pasting into a query editor. Either way, it pulls you out of your flow. With the latest updates to SQL Database Projects in VS Code, that context switching is n...

Remember when we announced the Public Preview of DiskANN vector indexes back in November and mentioned that once you created the index, your table became read‑only? Yeah… about that... 😅 We shipped early because the demand for Vector search in SQL was overwhelming. We knew the constraints weren’t ideal, but we also knew the fastest way to get this ...

The MSSQL extension for VS Code v1.41 continues to evolve, delivering features that make SQL development more integrated, more powerful, and more developer-friendly. In this release, we're introducing the Public Preview of Schema Designer with GitHub Copilot, Data API builder, and SQL Notebooks, along with the General Availability of Data-tier ...

When JSON Met Graph Part 2 of 4 - The Multi-model Database Series A note on naming. Throughout this series, when we say "SQL Server 2025" we also mean Azure SQL. The multi-model capabilities we discuss - native JSON, graph, vector, and columnstore - are available across both the on-premises engine and the Azure SQL family. In Part 1 we des...

Data API builder (DAB) 1.7+ delivers secure MCP-based CRUD access with deterministic, policy-enforced query generation and an upcoming aggregate tool that enables complex, production-safe analytical questions without exposing raw SQL to AI agents.