News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
dbi Blog
Once upon a time in IT project land What an achievement, it’s been a good while your team is working on a huge project and it’s finally completed. All related documentation is well registered and managed into your knowledge workers enterprise content management, M-Files. Time to get some rest and move on other tasks. Hence […]
dbi Blog
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 to quickly provision “lightweight” database clones for their development teams. As part of the […]
dbi Blog
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 on one Engine High Availability (HA) feature: Availability Group Commit Time. For a little background, Always […]
dbi Blog
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 some limitations.For the time being, supported backups on a secondary replicas are: So we cannot […]
dbi Blog
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: In this blog, we will compare MS_XPRESS and ZSTD. Environment To perform these tests, the following virtual machine was used: Additionally, I used the StackOverflow database to run the backup […]
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
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
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
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
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 […]