SQL Server

SQL Server 2025: What news on the instance configuration

Like every time with a new version of SQL Server, it’s good to see what the new configurations possibilities are for us to manage the instance. To do this, I will compare SQL 2022 and SQL 2025 using the system(…)

SQL Server 2025 – Retirement of SQL Server Reporting Services (SSRS)

Microsoft has announced the end of the SQL Server Reporting Services (SSRS) service. In other words, Microsoft will no longer provide new versions of SSRS. Currently, the latest available version is the 2022 version (https://www.microsoft.com/fr-FR/download/details.aspx?id=104502). However,(…)

Experiencing SQLBits 2025 in London

This week, I’m in London attending the SQLBits 2025 conference.Since joining dbi services as a consultant, this is my second time taking part in the event. The last time was in 2022, but I attended remotely due to the(…)

Random permission denied when backing up SQL Server databases to AWS Storage Gateway

Before addressing the issue of backup size reduction with compression enabled, let me provide some context. When SQL Server is hosted on AWS EC2 instances, you’ll need to manage the backup strategy appropriate to your business. In order to persist(…)

SQL Server 2025 – AG Commit Time

SQL Server 2025 preview has been publicly available for a week now: you can find all the details in this blog “SQL Server 2025 Public Preview and SSMS 21 now available“.In this blog, I want to make an highlight(…)

SQL Server 2025 – Backups to secondary replicas of an availability group

Backup operations can increase significantly I/O and even CPU utilization when we use backup compression. To avoid using resources on primary replica, offloading backups to a synchronized or synchronizing replicas seems to be the good solution even if we have(…)

SQL Server 2025 – ZSTD – A new compression algorithm for backups

Introduction SQL Server 2025 introduces a new algorithm for backup compression: ZSTD. As a result, SQL Server 2025 now offers three solutions for backup compression: MS_XPRESS QAT ZSTD In this blog, we will compare MS_XPRESS and ZSTD. Environment To perform(…)

SQL Server 2025 – Standard Developer edition

Introduction The arrival of SQL Server 2025 introduces the Standard Developer edition, allowing companies to deploy across all development, quality and testing environments using an edition equivalent to the Standard Edition without having to pay the associated licensing fees. Here(…)

SQLDay 2025 – Wrocław – Sessions

After a packed workshop day, the SQLDay conference officially kicked off on Tuesday with a series of sessions covering cloud, DevOps, Microsoft Fabric, AI, and more. Here is a short overview of the sessions I attended on the first day(…)

SQLDay 2025 – Wrocław – Workshops

I had the chance to attend SQLDay 2025 in Wrocław, one of the largest Microsoft Data Platform conferences in Central Europe. The event gathers a wide range of professionals, from database administrators to data engineers and Power BI developers. The(…)