SQL Server 2025 — What's New and Why It Matters

Microsoft released SQL Server 2025 this year — a version that marks a significant step forward in AI integration, real‑time data processing, and overall database performance. This release is not just an evolution of previous versions — it opens new possibilities for analytical scenarios, hybrid architectures, and modern application development.

AI and Vector Search Directly in the Database

One of the biggest innovations is the native support for vectors and AI capabilities. SQL Server can now:

store and query vector data (embeddings) directly in tables,
perform semantic search,
run AI models or call external AI services directly from SQL using special stored procedures.

This enables scenarios such as:

intelligent text search,
generating embeddings for RAG (retrieval‑augmented generation),
combining data and AI logic directly inside the database engine.

Regular Expressions and Enhanced Text Processing

SQL Server 2025 introduces native support for regular expressions, meaning you no longer need external tools or complicated workarounds — you can query and work with complex text patterns directly in T‑SQL.

Other text-related improvements include:

fuzzy matching for approximate text comparison,
enhanced handling of JSON data.

Real‑Time and Hybrid Analytics

SQL Server 2025 significantly improves real-time data capabilities:

Change Event Streaming allows publishing data changes as events to systems like Kafka or Azure Event Hubs without building a custom ETL layer.
Deeper integration with Microsoft Fabric enables smooth transitions between OLTP and analytical workloads without complex data movement.

Performance and Intelligent Query Processing

SQL Server 2025 continues to push performance and scalability with:

enhanced Intelligent Query Processing (IQP),
improved algorithms for lock management and concurrency,
extended Accelerated Database Recovery and additional mechanisms to reduce latency and speed up queries.

Security and Modern Protocols

Security is a major pillar of the new version, bringing:

default support for TLS 1.3 and the newer TDS protocol for secure communication,
stronger focus on encryption and identity management through Azure Entra,
modern password hashing and updated security policies for both Linux and Windows instances.

Developer Experience and Tools

Microsoft has also improved the developer environment:

SQL Server Management Studio (SSMS) is now fully 64‑bit and includes Git integration,
Copilot preview in SSMS for generating queries and analyzing performance.

Deprecations and Removed Features

As with any major release, some older technologies are being retired:

Master Data Services (MDS),
Data Quality Services (DQS),
Synapse Link, and others.

Next article Previous article

Clients who trust us

Customer satisfaction defines our success.

Check out our trusted clients.

BLUE TECHNOLOGY s.r.o.

The speed of purchasing licenses and assigning them to the customer account is excellent. This is very useful in case someone forgets to order licenses for a customer. It’s great that Ms. Adámková is there—she knows the system well and provides help, which is a huge support. Overall, I think it serves its purpose and, compared to the old system, it’s a tremendous improvement.

Show all

Daisybits s.r.o.

As a Microsoft partner, I was looking for a way to purchase CSP licenses, and the solution from eD on the rethinkportal.com platform came at exactly the right time for me. After a brief introduction to the portal and basic setup, I was able to quickly purchase my first licenses and add customers. If a customer already has a tenant, you need to add them to the system and request proper classification, but Ms. Adámková from eD is extremely helpful and always accommodating. When creating a completely new customer without a tenant, the process is fully automated—the system on the portal and on Microsoft’s platform creates everything needed, and I can immediately start creating users and assigning licenses. Based on my experience so far, I can only recommend this solution and thank the eD system team for excellent cooperation.

Show all

Martin Pražma, Argument s.r.o.

First of all, I’m very glad to have the opportunity to use the portal. A major advantage is the speed of license activation, as licenses become active practically immediately after ordering. It’s also convenient to create my own product categories, where I can keep my most frequently used products.

Show all

Tomáš Suchý

I have been using the portal to order SaaS for six months, and I appreciate its simplicity and speed. Immediate activation and delivery to the customer is a major benefit. Compared to CSP, purchasing additional licenses is easier, and maintaining the same expiration date eliminates complicated invoicing for customers who have multiple products with different expiration dates. The only thing to keep in mind is to calculate the price of the product for the shorter period before offering it to the customer.

Show all

Find out more