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(…)
Database Administration & Monitoring, Database management 2025.pgconf.de recap 13.05.2025 by Daniel Westermann ( note: I am writing this as member of the pgconf.de organization team, and not as a dbi services employee ) After almost half a year of planning and preparation PostgreSQL Conference Germany 2025 finally took(…)
Database management, Development & Performance, SQL Server Set SQL Server Trace Flags Automatically and Smoothly 29.04.2025 by Hocine Mechara Managing SQL Server trace flags effectively is a common task for DBAs and system engineers, especially when tuning the SQL Server behavior for specific use cases or performance optimizations. While trace flags can be enabled programmatically using T-SQL commands such(…)
AWS, Ansible, Azure, Database management, DevOps YaK Core – The Holy Grail for Deploying Ansible Code Everywhere 29.04.2025 by Hervé Schweitzer YaK core Multi-Platform open source Automation Tool simplifies the deployment of Ansible playbooks through a clean UI and API. It offers an intuitive interface where users can upload playbooks, configure parameters, and deploy them seamlessly across various platforms, and(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Support for asynchronous I/O 10.04.2025 by Daniel Westermann This is maybe one the biggest steps forward for PostgreSQL: PostgreSQL 18 will come with support for asynchronous I/O. Traditionally PostgreSQL relies on the operating system to hide the latency of writing to disk, which is done synchronously and can(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Add function to report backend memory contexts 09.04.2025 by Daniel Westermann Another great feature was committed for PostgreSQL 18 if you are interested how memory is used by a backend process. While you can take a look at the memory contexts for your current session since PostgreSQL 14, there was no(…)
Database Administration & Monitoring, Database management PostgreSQL 18: Allow NOT NULL constraints to be added as NOT VALID 08.04.2025 by Daniel Westermann Before we take a look at what this new feature is about, let’s have a look at how PostgreSQL 17 (and before) handles “NOT NULL” constraints when they get created. As usual we start with a simple table: postgres=# select(…)
Database Administration & Monitoring, Database management SQL Server AlwaysOn – Alert database Not Synchronizing / Suspect 04.04.2025 by Stéphane Haby Few days ago, through our alerting at the Service Desk, we receive an alert about a database in an AlwaysOn cluster with the message: CRITICAL: Database xxxx [replica: xxxxxx] [role: SECONDARY] state is SUSPECT, synchronization health is NOT_HEALTHY, synchronization(…)
Database Administration & Monitoring, Database management PostgreSQL 18: “swap” mode for pg_upgrade 28.03.2025 by Daniel Westermann When you want to upgrade from one major version of PostgreSQL to another you probably want to go with pg_upgrade (or logical replication). There are several modes of operations for this already: –copy: Copy the data(…)