As we already know, SQL Server 2025 has been part of our catalog since late 2025. This new version introduces significant enhancements to Intelligent Query Processing (IQP). These innovations focus on automating tasks, reducing the need for manual tuning, and optimizing performance through the use Read More

Last week we attended the Microsoft AI Tour Madrid, where Satya Nadella put a key topic for regulated organizations on the table: digital sovereignty. For those who want the official context, this Microsoft summary explains it very clearly: Artificial intelligence and digital sovereignty take center Read More

Introduction For many years, working with text in SQL Server has been a frustrating task. While some engines offered advanced support for regular expressions, others had to rely on combinations of LIKE, PATINDEX, CHARINDEX, or even CLR functions to solve relatively common problems. In 2025, Read More

Introduction It is clear that AI is here to stay, and Microsoft knows it. That is why the 2025 version of SQL Server comes with a new feature for the AI era: the use of vectors for search. By this point in 2026, terms like Read More

Evolution of JSON support in SQL Server Since SQL Server 2016, Microsoft introduced support for JSON data, allowing developers to store and query semi-structured information within relational databases. However, until now, working with large volumes of JSON data could be complex and costly in terms Read More

Welcome to a new article on the Aleson ITC blog. In today’s post, we’ll talk about CES (Change Event Streaming) for SQL Server 2025. We’ll explain what it is, how it works, what it’s used for, and the different scenarios where this feature can be Read More

With the arrival of SQL Server 2025, Microsoft has introduced ZSTD as a new backup compression algorithm. This addition aims to significantly optimize backup operations, improving both execution speed and efficiency in the use of system resources. The introduction of ZSTD in SQL Server 2025 Read More