Showing category results for SQL Server 2025

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

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

The next leap in data interaction isn't just about efficient processing; it's about intuitive and meaningful conversation with your own data. For years, the true power of SQL Server databases has been locked behind complex query languages and specialized tools, accessible primarily to developers and database administrators. But what if anyone, rega...

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