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
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
SQL Server 2025 introduces a long‑awaited improvement in concurrency management with Optimized Locking. This feature, previously available in Azure SQL Database, now arrives in SQL Server 2025, promising more efficient transaction handling without the need to modify existing code. What is Optimized Locking? Optimized Locking Read More
Since SQL Server 2025 was released last November, we took some time before starting this series, but it was about time. This version is packed with new features that deserve a proper review before putting them into production. In this first post, we’ll provide an Read More
Welcome to a new post on the Aleson ITC blog. As many of us know, in SQL Server 2022 there are many new features that we are loving and one of the least known is the ability to manage contained availability groups. What are Contained Read More
Usamos cookies propias y de terceros necesarias para que nuestro sitio web funcione adecuadamente pero también utilizamos otras que nos permiten personalizar el sitio y sus opciones, realizar labores analíticas de tráfico y uso, ofrecer funciones de redes sociales, mejorar la navegación, adaptarse a tus preferencias y poder mostrarte contenido relevante y personalizado. Dispones de más información sobre las mismas en nuestra Política de Cookies. Puedes aceptar todas las cookies pulsando en el botón "Aceptar" o configurarlas a tu gusto o rechazar las no necesarias, a través de las opciones que ponemos a tu disposición. AceptarMás información
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.