We’re excited to announce major improvements to DiskANN in SQL Server 2025 RC1, making vector search faster, more scalable, and more storage-efficient than ever before. ⚡ Significantly Faster Index Builds Building DiskANN indexes is now considerably faster, thanks to optimizations that better utilize all available CPU cores and improve the ef...

The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more integrated, more consistent, and more developer-friendly. In version v1.36.0, we’re announcing the Public Preview of Fabric Connectivity (Browse), SQL Database in Fabric Provisioning, and GitHub Copilot Slash Commands — three capabilities that br...

This article presents an AI-powered approach to automating SQL Server code analysis and refactoring. The system intelligently identifies inefficiencies and common T-SQL anti-patterns, applying best practices through a set of formalized coding rules, using prompt-driven instructions. It not only automatically rewrites problematic and inefficient...

I recently created a GitHub repository to share the T-SQL scripts I've accumulated over 10 years as a DBA. However, I've always struggled to find the right script when I need it. For years, I relied on simple shell commands like find or just my memory, which could take 10-30 minutes, if I was lucky enough to find it. But, we are in the AI age,...

With the release of SQL Server 2025 RC0, we have enabled the ability to use a local ONNX model on the server for embeddings. This allows you to use these models without having any network traffic leaving the local environment. Getting Started This example guides you through setting up SQL Server 2025 on Windows with an ONNX runtime to enabl...

The MSSQL Extension for VS Code continues to evolve, delivering features that make SQL development more visual, more consistent, and more developer-friendly. In version v1.35.0, we’re announcing the General Availability (GA) of Schema Designer, Schema Compare, and Local SQL Server Containers — three powerful tools that bring structure, clarity, and...

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

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

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

How often have you wished you could just talk to your data? Imagine extracting crucial insights, updating records, or building complex reports without wrestling with intricate query languages or relying on a dedicated developer. For many professionals, the true power of their enterprise data remains locked behind technical barriers, hindering agile...