News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
dbi Blog
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 easy to setup and configure and all you need are the client libraries (for Db2 in this case). But […]
dbi Blog
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 are the different editions available in SQL Server 2025: What problem does this solve? Some […]
dbi Blog
This is a short blog post to share that the SQL Server 2025 public preview is now available for download. At the same time, SSMS 21 has also been released and is now generally available. The LinkedIn post by Bob Ward announcing the news can be found here: Announcing SQL Server 2025 Public Preview In […]
dbi Blog
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 first day was fully dedicated to pre-conference workshops. The general sessions are scheduled for the […]
dbi Blog
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 of the main conference. Morning Kick-Off: Sponsors and Opening The day started with a short […]
dbi Blog
As PostgreSQL 18 Beta 1 has been released (link) and is packed with lots of cool features like improved IO on reads for example, I wanted to test out the new pg_createsubscriber and pg_upgrade options and how they are going to help us performing smoother major upgrades using the “blue-green” migration similar to the ones […]
dbi Blog
After the “Welcome 3rd Day APEX Connect, DOAG e.V.”, and the very entertaining Keynote “Trouble in the Old Republic” by Samuel Nitsche, I decided to attend presentations on following topics:– 23ai – Building an AI Vector Search API using APEX, ORDS, REST and PL/SQL– APEX in Style – Ein Überblick über die verschiedenen UI-Customizingmöglichkeiten– SQL […]
dbi Blog
This year I can unfortunately only attend APEX Connect for 2 days, starting on Day 2 of the conference. Conference is hosted in the famous EuropaPark.The Day has started with the traditional 5K run (which ended up to be 5.8 km in fact) to wake-up the body with fresh air and nice sunshine. After the […]
dbi Blog
( 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 place last week in Berlin. It was in the same hotel as the 2022 edition of PostgreSQL Conference Europe […]
dbi Blog
The last day of the M-Files IMPACT Global Conference 2025 was dedicated to M-Files partners only. Throughout the day, M-Files shared partner-specific information and hot news. Below is a summary of the main topics. Keynote In the Keynote session they emphasised theuir continueing support of their partner network. In addition, to that they shared the […]
dbi Blog
The second day of the M-Files IMPACT Global Conference 2025 commenced at 9 am with a keynote session. On this occasion, the key note was entitled ‘Unlocking the Future of Business’. The Future of AI: Unlocking New Opportunities and Navigating the Challenges Ahead’The importance of AINO was emphasised, especially the automatic filling of metadata. Keynote […]
dbi Blog
This year, the annual M-Files Customer and Partner Conference will be held in the capital of Greece. All M-Filers worldwide are expected to attend the event in Athens, where they will have the opportunity to network with their peers and gain insight into the latest developments concerning M-Files products. I am delighted to have the […]
dbi Blog
Sometimes there is no time for a long analysis of a slow query and a fix (workaround) has to be provided asap. In such cases it often helps to check if a query did run faster with a previous OPTIMIZER_FEATURES_ENABLE-setting. If that is the case, then you also want to find out which optimizer bug […]
dbi Blog
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 as DBCC TRACEON, this approach has an inherent limitation: the flags are session-based or global […]
dbi Blog
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 all managed through a centralized inventory stored in a PostgreSQL database. With YaK Core, developers can […]
dbi Blog
AI projects are increasing and with it comes some risks that are or not related to this technology. Some organizations are jumping straight into “plug the LLM into a vector database” ( like Pinecone, Qdrant, pgvector…) at the risk of replaying the lift-and-shift mistakes made on the cloud projects. This time, hiding years of data-quality, […]
dbi Blog
I recently had to install an Oracle Database Appliance X11 HA and it failed when creating the appliance: It happened randomly in the past that we got this error “host key verification failed” and we just had to rerun our “odacli create-appliance” command again. However, this time restarting was not possible: Following MOS Note “ODA […]
dbi Blog
I recently wrote a blog to show how to configure Veeam RMAN plug-in to take database backups. As all DBA knows, configuring a backup, will not go without testing a restore. In this blog I will show how I tested my previous Veeam configuration and backups performed with this Veeam RMAN plug-in on the same […]
dbi Blog
Introduction to YaK YaK is an open-source automation project developed by dbi services. Built on Ansible playbooks, YaK streamlines the deployment process for various components across any platform. It ensures adherence to best practices, maintains deployment quality, and significantly reduces time-to-deploy. Initially created in response to the growing demand from dbi services’ consultants and clients, […]
dbi Blog
There are several situations when you have to migrate your Oracle databases to a new server. This could be due to hardware lifecycle reasons for on-prem systems or you need to upgrade your Operating System (OS) from Enterprise Linux 8 to Enterprise Linux 9. In this blog I wanted to talk about my recommended methods […]
dbi Blog
Everybody is talking about AI, RAG and language models today. A lot of people are using ChatGPT or other tools to get answers to their questions, generate text or images. While this sometimes is really helpful (depending on how you use it) you still need to be skeptical about the information you get out of […]
dbi Blog
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 lead to double buffering (PostgreSQL shared buffers and the OS file cache). This is most […]
dbi Blog
Last week, I hit a wall when my SUSE Linux Enterprise Server license expired, stopping all repository access. Needing PostgreSQL urgently, I couldn’t wait for SUSE to renew my license and had to act fast.I chose to disable every SLES repository and switched to the openSUSE Leap repository. This worked flawless and made my system […]
dbi Blog
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 way to retrieve that information for another backend. Since PostgreSQL 14 there is the pg_backend_memory_contexts […]
dbi Blog
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: Trying to insert data into that table which violates the constraint of course will fail: Even if […]
dbi Blog
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 state is NOT SYNCHRONIZING [suspended: true] [failover ready: false] [joined: true] After creating the ticket, I […]
dbi Blog
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: What is best for you, depends on the requirements. We usually go with “–link” as this is pretty fast, but you can only […]
dbi Blog
Loosing all the object statistics after a major version upgrade of PostgreSQL with pg_upgrade is one of the real paint points in PostgreSQL. Collecting/generating the statistics can take much longer than the actual upgrade which is quite painful. A first the to resolve this was already committed for PostgreSQL 18 and I’ve written about this […]
dbi Blog
Introduction Patching your Oracle Database Appliance from 19.20 or earlier release to 19.21 or newer release implies the use of Data Preserving Reprovisioning (DPR). Most of the time, and with an adequate preparation, the DPR works fine. But if something goes wrong at the restore-node -g step, you will need some troubleshooting and maybe opening […]