{"id":51136,"date":"2025-05-19T09:00:00","date_gmt":"2025-05-19T16:00:00","guid":{"rendered":""},"modified":"2026-03-19T16:25:47","modified_gmt":"2026-03-19T23:25:47","slug":"announcing-sql-server-2025-preview-the-ai-ready-enterprise-database-from-ground-to-cloud","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2025\/05\/19\/announcing-sql-server-2025-preview-the-ai-ready-enterprise-database-from-ground-to-cloud\/","title":{"rendered":"Announcing SQL Server 2025 (preview): The AI-ready enterprise database from ground to cloud"},"content":{"rendered":"\n

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale.<\/p>\n\n\n\n

\n
Watch the video: SQL Server 2025 is AI-ready, are you?<\/a><\/div>\n<\/div>\n\n\n\n

SQL Server 2025, now in public preview, empowers customers to develop modern AI applications<\/a> securely using their data, complete with best-in-class security, performance, and availability. It provides built-in, extensible AI capabilities, enhanced developer productivity, and seamless integration with Microsoft Azure and Microsoft Fabric\u2014all within the SQL Server engine using familiar T-SQL language. <\/p>\n\n\n\n

\n
Get started with SQL Server 2025<\/a><\/div>\n<\/div>\n\n\n\n

Your data, any model, anywhere <\/h2>\n\n\n\n

One of the most exciting new capabilities of SQL Server 2025 is the integration of AI directly into the database engine, enabling more intelligent search. With built-in vector search capabilities, you can perform semantic searches over your own data to find matches based on similarity, alongside full text search and filtering you are already using in SQL Server. This built-in capability opens up a host of exciting new use cases such as discovering deeper connections within large datasets, providing a natural conversational experience across various enterprise systems.  <\/p>\n\n\n\n

SQL Server 2025 introduces enhanced model management by building model definitions directly into T-SQL, enabling seamless integration with popular AI services such as Azure AI Foundry<\/a>, Azure OpenAI Service<\/a>, OpenAI, Ollama, and others. Models are all accessed through REST APIs allowing you to deploy any model securely isolated from the SQL Server engine, anywhere from ground to cloud. As developers test embedding models to find the best fit for their use cases, whether running open-source models on laptops or hosting purpose-trained models, SQL Server 2025 makes it convenient to switch models without needing to change the code. <\/p>\n\n\n\n

This release also provides other essential building blocks for AI development and operational retrieval-augmented generation (RAG) patterns powered by AI agents. It includes vector embedding generation and text chunking built into T-SQL, using Disk Approximate Nearest Neighbor (DiskANN) as a vector index for faster, resource-efficient, and accurate results. Additionally, SQL Server 2025 offers seamless integration with popular AI frameworks like LangChain, Semantic Kernel, and Entity Framework Core. <\/p>\n\n\n\n

\n

\u201cWith the new semantic search and RAG capabilities in SQL Server 2025, we can empower existing GenAI solutions with data embeddings to create next-generation, more intelligent AI applications. By connecting systems, we deliver a seamless, natural conversational experience across enterprise environments.\u201d<\/p>\n\u2014Markus Angenendt, Data Platform Infrastructure Lead, Kramer & Crew  <\/cite><\/blockquote>\n\n\n\n

Microsoft\u2019s most significant release for SQL developers in the last decade <\/h2>\n\n\n\n

We understand that developers need the right tools and interfaces for modern, data-intensive applications. SQL Server 2025 delivers a rich set of feature enhancements that significantly streamline development process, reduce code complexity, and improve developer productivity. Along with built-in AI capabilities, this release makes SQL Server 2025 the most significant release for SQL developers since the introduction of SQL Server 2016 a decade ago.  <\/p>\n\n\n\n

Enhancing data enrichment is our first area of focus in this release. SQL Server 2025 offers native JSON support, empowering developers to process JSON documents natively. Combined with REST APIs and Regular Expressions (RegEx) enablement, developers can now enrich, validate, and manipulate their datasets with external data sources. This allows for building more dynamic, enterprise-grade applications with richer functionality and enhanced performance. <\/p>\n\n\n\n

Empowering developers to build real-time, event-driven applications with SQL Server is another scenario that this release unlocks. Change Event Streaming allows users to consume transaction log changes as events directly from SQL Server to Microsoft Azure Event Hubs<\/a>. This provides a new method to mitigate some of the issues developers have seen with the Input\/Output (I\/O) overhead of Change Data Capture (CDC). It also opens new possibilities such as developing real-time, event-driven applications powered by AI agents. <\/p>\n\n\n\n

There\u2019s also excitement on the language and tooling front. We\u2019re thrilled to announce the preview of our new open-source Python driver for SQL Server.1<\/sup> Built from the ground up, this driver offers Python developers a robust, efficient, and fully open-source solution for connecting to SQL Server, as simple as pip install. In addition, we are bringing AI-powered assistance directly into your workflow with the integration of MSSQL Extension for Visual Studio Code with GitHub Copilot, now in preview. With GitHub Copilot aware of your SQL Server database connection, developers can generate SQL and object-relational mapping (ORM) migrations, explore schemas, optimize queries with intelligent suggestions, and streamline database interactions\u2014all within in Visual Studio Code.  <\/p>\n\n\n\n

\n

“I am genuinely enthusiastic about the AI advancements in SQL Server 2025. These features, along with the enhancements in RegEx and JSON data support, promise to make AI functionalities accessible to a broader range of software applications, and significantly enhance our database operations.” <\/p>\n\u2014Jacob Saugmann, SQL Specialist,\u202fJ.H. Schultz Information A\/S<\/cite><\/blockquote>\n\n\n\n

Best-in-class security, performance, and availability <\/h2>\n\n\n\n

This release builds on SQL Server’s history as an industry leader in database security, performance, and availability. For our enterprise customers, security is non-negotiable. SQL Server remains as the most secure database in the last decade.2<\/sup> SQL Server 2025 continues the product\u2019s legacy of top-notch security by incorporating modern identity and encryption practices. Support for Microsoft Entra<\/a> managed identities improves credential management and reduces potential vulnerabilities.3<\/sup><\/p>\n\n\n\n

We\u2019re bringing Optimized Locking to SQL Server, to reduce lock memory consumption and minimize blocking for concurrent transactions through Transaction ID (TID) Locking and Lock After Qualification (LAQ). This capability enables customers to increase uptime and enhance concurrency and scale for SQL Server applications. <\/p>\n\n\n\n

SQL Server 2025 has over 50 enhancements made to the database engine including key improvements for HADR all based on customer feedback. This new release will bring enhancements to performance for applications with no code changes required through Intelligent Query Processing (IQP) and columnstore improvements, enhancements for query processing, and enabling Query Store for readable secondaries.  <\/p>\n\n\n\n

\n

\u201cSecurity Cache Improvement\u202fproved invaluable for high-demand environments like ours, reducing disruption when applying permissions on servers with 20,000\u201325,000 active connections. This enhancement ensures minimal performance impact, streamlining security management. The ordered non-clustered Columnstore index\u202fsignificantly improved query performance by over 63%, optimizing workloads reliant on analytical processing.\u201d<\/p>\n\u2014Madhab Paudel, Database Engineer, Entain<\/cite><\/blockquote>\n\n\n\n

Cloud agility through Azure <\/h2>\n\n\n\n

To build scalable analytics, data needs to be extracted, transformed, normalized, and made available in a central place. SQL Server 2025 will support database mirroring in Fabric<\/a>, giving you near real-time analytics using a zero extract, transform, and load (ETL) experience and allowing you to offload your analytical workloads to Fabric<\/a>.3<\/sup>  <\/p>\n\n\n\n

Azure is a critical component of SQL Server. With Azure Arc, SQL Server 2025 will continue to offer cloud capabilities to enable customers to better manage, secure and govern your SQL estate at scale across on-premises and cloud. <\/p>\n\n\n\n

\n

“Fabric mirroring for SQL Server 2025 helps MSC to build the bridge to bring our operational data into Microsoft Fabric.”<\/p>\n\u2014Javier Villegas, IT Director of DBA and BI Services, Mediterranean Shipping Company<\/em><\/cite><\/blockquote>\n\n\n\n

Get started with SQL Server 2025 today<\/h2>\n\n\n\n

With every AI-powered query for hybrid search, every millisecond saved in query execution, every change event streamed in real time, SQL Server 2025 is a critical building block for modern data-intensive applications in this AI era. Ready to try it out? Learn more about SQL Server 2025<\/a>.<\/p>\n\n\n\n

SQL Server Management Studio (SSMS) 21<\/a>, now generally available, is based on Visual Studio 2022 and includes 64-bit support. This modernized version is available from the Visual Studio Installer, offers automatic updates, and introduces Git integration, query editor enhancements, and a new connection experience.<\/p>\n\n\n\n

Microsoft Copilot in SSMS<\/a>, now in preview, is available as an optional workload when installing SSMS 21, and assists customers in writing, editing, and fixing T-SQL queries using natural language. Leveraging database context, it also helps with database administration, maintenance, configuration and more.3<\/sup><\/p>\n\n\n\n

Explore solutions and capabilities<\/h2>\n\n\n\n