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...
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...
SQL Server 2025 marks a major milestone in database innovation by introducing native support for VECTOR data types and vector functions. These are now fully available in the freshly released SQL Server 2025 RTM. This means you can store and process high-dimensional embeddings directly within your database. It eliminates the need to move data acr...
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...
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,...
We are happy to announce that Native vector support in Azure SQL Database and Azure SQL Managed Instance is moving to General Availability this summer. Deployments are already underway, and several regions have begun receiving the feature. What is going GA? Integrated Vector Data Type Azure SQL introduces a dedicated VECTOR data type that simpl...
I'm happy to announce that SQL Server 2025 CTP 2.1 is now available, and it brings significant improvements to DiskANN support. While DiskANN remains in preview, each release continues to remove limitations and boost performance. In this release, we’ve made a particularly notable leap in vector index creation speed, with more enhancements on th...
Back in the earlier part of the year (February maybe?), I put this tutorial together for our early adopters in the SQL Server 2025 program. It’s a guide for setting up SQL Server 2025 in a Hyper-V VM (I used Windows Server) with Ollama and ngnix as an https proxy. It's a variation of my workshops for Ignite 2024 and a SQL in Fabric one from Februar...
