Cloud, Database management, Oracle Optimize materialization of Exadata PDB sparse clones 26.05.2025 by Jérôme Witt Well, this blog is unfortunately reserved to DBA folk running Oracle engineered systems #Exadata, #ExaCC, #ExaCS and Oracle Multitenant database (aka. CDB) architecture.One of our #ExaCC customer has a strong DevOps focused business and heavily relies on Exadata sparse clones(…)
Database Administration & Monitoring, Database management, SQL Server SQL Server 2025 – AG Commit Time 26.05.2025 by Nathan Courtine 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(…)
Database Administration & Monitoring, SQL Server SQL Server 2025 – Backups to secondary replicas of an availability group 23.05.2025 by Stéphane Savorgnano 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(…)
Ansible Ansible: reduce output in loops – or replace loops 23.05.2025 by Martin Bracher Reduce the output If you do a loop in Ansible, it always prints the item variable for each loop. “item” is the current list element. If you are looping over a list with small values, then the output is(…)
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 Using dlt to get data from Db2 to PostgreSQL 21.05.2025 by Daniel Westermann For a recent project at one of our customers we needed to get data from a Db2 database into PostgreSQL. The first solution we thought of was the foreign data wrapper for Db2. This is usually(…)
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(…)
Oracle, Security Different types of Oracle wallets 20.05.2025 by Martin Bracher In this blog post I will explain the different types of Oracle wallet with the auto_login feature. What is an Oracle Wallet An Oracle wallet is used to store certificates for Listeners with https protocol, or it can be used(…)
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(…)