Database Administration & Monitoring, Database management, Development & Performance, SQL Server Customer case study – Partition switching and transactional replication 31.07.2025 by Amine Haloui The client’s environment includes two SQL Server instances (I1 and I2). One of the databases, D1 (on I1), is replicated to I2 via transactional replication. Additionally, the tables in this database are partitioned. The largest table (which is the one(…)
Business Intelligence, Database management, SQL Server SQL Server 2025 – Retirement of SQL Server Reporting Services (SSRS) 20.06.2025 by Amine Haloui 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,(…)
Database Administration & Monitoring, Database management, Development & Performance, SQL Server SQL Server 2025 – ZSTD – A new compression algorithm for backups 23.05.2025 by Amine Haloui 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(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server 2025 – Standard Developer edition 20.05.2025 by Amine Haloui 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(…)
Azure, Business Intelligence, Cloud, Database Administration & Monitoring, Database management SQLDay 2025 – Wrocław – Sessions 19.05.2025 by Amine Haloui 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(…)
Azure, Business Intelligence, Cloud, Database Administration & Monitoring, Database management SQLDay 2025 – Wrocław – Workshops 19.05.2025 by Amine Haloui 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(…)
Azure, Database Administration & Monitoring, Development & Performance, SQL Server An introduction to Azure Database watcher 17.02.2025 by Amine Haloui Azure Database watcher is a managed monitoring service designed to provide insights and diagnostics for Azure databases and Azure Managed Instance. It helps database administrators and developers track performance, detect anomalies and troubleshoot issues efficiently. By collecting telemetry data, logs(…)
Database Administration & Monitoring, Database management, Development & Performance, SQL Server Customer case study – SQL Server table partitioning 07.02.2025 by Amine Haloui A client submitted the following issues : Their database hosts multiple tables, including one table of approximately 1 TB, consisting of several billion rows. This table is continuously fed by various data sources. Additionally, it is also used to generate(…)
Cloud, Database management, Development & Performance Future Data Driven 2024 – introduction to vector databases 30.09.2024 by Amine Haloui I had the opportunity to participate in the Future Data Driven 2024 event (https://datadrivencommunity.com/FutureDataDriven2024.html) with my colleague Stéphane Haby. Many speakers were present, and I was able to attend several sessions covering the following topics: Azure, AI, CosmosDB,(…)
Business Intelligence, SQL Server Power BI – Scheduled refresh stuck 23.08.2024 by Amine Haloui Introduction When creating reports, there are several modes through which we can import data. In our case, reports had been created using the “import mode.” In this mode, the data is imported or copied into our reports to be included.