Showing category results for Azure SQL

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 Multimodal Database Series A note on naming. Throughout this series, when we say "SQL Server 2025" we also mean Azure SQL. The multimodal 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 descr...

Part 1 of 4 - The Multimodal Database Series This is a four-part series about what happens when a single database engine handles relational, document, graph, vector, and analytical workloads natively - and what you stop paying for when it does. You spin up a database, point an agent at it, and start building. The first few tables go fast - user...

The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more integrated, more powerful, and more developer-friendly. In version v1.40.0, we're introducing the ADS Migration Toolkit, Basic Database Management, Flat File Import, Database Backup & Restore, Database Object Search, and Query Profiler — six ...

Data API builder (DAB) supports multi-source configurations Data API builder (DAB) connects to your database with a safe REST or GraphQL endpoint. But DAB is not limited to just one database. Using a multi-source configuration, you can connect to more than one database simultaneously. Learn more about Data API builder: https://aka.ms/dab/docs ...

For decades, DBAs relied on linked servers to stitch data together. If you needed data from two places, you wired them up and moved on. It worked. It was straightforward. It felt native to SQL. But what if linked servers are not an option? What if policy blocks them? What if one of the systems is not SQL or lives in another cloud? How do you cross...

Perhaps we missed it at first, but Copilot is more than comfortable with SQL. This goes beyond autocomplete. This is moving from nothing to a working database without leaving our tools. Have we really arrived? Yes, sort of. For database engineers and app engineers alike, we have crossed an important line. Making us more productive is easy for Copi...