News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
dbi Blog
The database Capture/Replay feature of the Real Application Testing (RAT) suite enables you to capture the workload from a production database and replay it on a test or development environment. This allows for realistic testing of database changes, such as upgrades, patches, or hardware migrations. In this blog, we’ll explore how to accomplish this when […]
dbi Blog
When people talk about containers in FreeBSD, they usually talk about Jails. We’ve already seen how this works in general here and here. An additional option you have, is to install Podman on FreeBSD. Podman is well known in the Linux world and can be used to build and run containers. With the release of […]
dbi Blog
Now that we know how to work with the ports collection let’s have a look another option you have in FreeBSD: Sometimes it might be required to run unmodified Linux binaries on FreeBSD and to achieve this, FreeBSD comes with a Linux compatibility layer. This is optional and not enabled by default, but pretty easy […]
dbi Blog
If you followed the previous introduction posts about FreeBSD (here, here, here, here and here) you should already know how to install binary packages. On FreeBSD this is done using pkg, and if you are familiar with apt, dnf, or zypper (or any other package manager on Linux) this should not be a big deal. […]
dbi Blog
Over the years, ORMs have industrialized query generation, allowing developers to focus on optimizing the few queries that truly need it. However, they can sometimes produce overly complex SQL with excessive joins and business logic, making tuning a nightmare. It is sometimes hard to know when you should split a query in multiple smaller parts. […]
dbi Blog
A few days ago a customer called me to ask if I could help him with a problem with the log file. He tried to shrink it, but the system wasn’t doing anything and he didn’t know why. With the column ‘log_reuse_wait_desc’ you can find it out. When I asked him what was in the ‘log_reuse_wait_desc’ […]
dbi Blog
I blogged in the past about running an Oracle database for testing purposes on Apple Silicon. Initially with emulated Intel code here and then (when Oracle released its 19c database software for ARM) with UTM as a wrapper for the QEMU hypervisor here. In the meantime another possibility came up since Oracle released its type […]
dbi Blog
Now that we know how to get started with FreeBSD, how to manage users and groups, and how to work with services, we’ll look a bit into Jails today. But before we do this, let’s look at what we have in Linux today when it comes to containerization and virtual machines. Obviously we can manage […]
dbi Blog
1 Introduction Hello, Readers! Recently, I was tasked with preparing a demo for Power BI Report Server. Everything proceeded smoothly until I reached the step of deploying a report to the server, where I encountered an interesting authentication challenge that highlights the complexities of working with mixed domain environments. The report deployment phase revealed an […]
dbi Blog
Introduction One of the nice things with cloud providers is the low costs of their storage. Whenever you want to optimize your long-term backups and push them on Azure, you might face a wall of questions on how to do it with PostgreSQL securely and whether it would align with disaster recovery plans.The following setup […]
dbi Blog
This is the third post in the series about getting started with FreeBSD. We’ve looked at the first steps here, and users and groups here. Today we’re looking at how FreeBSD handles services. For those who still don’t like systemd the good news is: There is nothing like systemd in FreeBSD. For those who do […]
dbi Blog
Contexte : Mon client travail dans le domaine des échanges de marchandises et ressources primaires et son métier repose sur l’utilisation de différents outils informatiques pour faire ses affaires. Dans le but de consolider ses données afin de pouvoir générer des rapports d’activités globaux, dbi-Services a été sollicité pour réaliser un Data Warehouse (DWH) et […]
dbi Blog
In case you follow the blogs here, you might have noticed that I got interested in FreeBSD over the last months (or even year(s)). The reasons for this are multiple: FreeBSD development is organized in very much the same way as it is with PostgreSQL. The license is very much the same. The history is […]
dbi Blog
In the last post, we’ve initially configured FreeBSD so that networking is up and running, additional packages can be installed, and the system was patched to the latest release. In this post we’ll look at how users and groups are managed in FreeBSD and what FreeBSD provides when it comes to additional security mechanisms. On […]
dbi Blog
In the last post about PostgreSQL on ZFS the pgbench tests showed, that ZFS was slower for the standard tests compared to ext4 on Debian. A comment to that post made me wonder if changing the ZFS record size would change the results, so this blog post is about exactly that. There is plenty of […]
dbi Blog
Introduction Since patch version 19.21 (current one is 19.25), Oracle Database Appliance (ODA) X7, X8 and X9 will require the use of Data Preserving Reprovisioning (DPR) to apply the patch coming from 19.20 and previous releases. Unlike traditional patching, DPR erases the system disks but keeps data on ASM/ACFS disks. Data means databases, ACFS volumes, […]
dbi Blog
1 Introduction Hello, Readers! While exporting data to Azure Blob Storage using SQL Server Integration Services (SSIS), I encountered the “Unable to create Azure container” error. This article will guide you through a straightforward solution, aiming to save you time and prevent similar frustrations in the future. 2 Context The logic of the example is […]
dbi Blog
I often see customers with Virtual Machines or Containers that have IPv6 disabled. I assume this is mainly for simplicity, since most services are usually only running internally, and organizations don’t really need more IPs than what IPv4 can provide to begin with. In this blog, I will talk about an upgrade project from Documentum […]
dbi Blog
In the last post we’ve set the baseline for comparing ext4 to zfs when it comes to PostgreSQL. We’ve ended with two PostgreSQL clusters, one running on the ext4 file system while the other is running on top of the ZFS file system. In this post we’ll look at how they compare when it comes […]
dbi Blog
Last week, at the Pass Data Summit, they announce the new version of SQL Server Management Studio: SSMS 21 You can find the preview in here. It’s a good opportunity to test this new version before installing it by customers… After downloading the file vs_SSMS.exe (4,3 MB), start the file to doanload and install it. […]
dbi Blog
1 Introduction Recently, a colleague approached me, saying, “Hey Nicolas, I’m thinking of going for the PL-300 (Microsoft Power BI Data Analyst Associate) certification. Do you have any advice on how to pass it with confidence?” As knowledge sharing is one of the core values at dbi services, both internally and externally, I thought it […]
dbi Blog
Introduction As PostgreSQL continues to gain traction in enterprise-grade applications, I am increasingly tasked and asked about implementing robust security policies. And, as most current DBA positions are multi-systems nowadays, I wanted to make a quick summary on roles and how they can be leveraged to implement those policies. For those accustomed to managing accounts […]
dbi Blog
Recently I’ve switched my PostgreSQL playground from Linux to FreeBSD. Not because I don’t like Linux anymore, just because I like trying out other operating systems and see what works the same and what is different. When you install FreeBSD and stick to the defaults, you’ll get a ZFS root filesystem and usually I don’t […]
dbi Blog
If you are familiar with Java, you probably know that starting with JDK 9, you may need to add some “–add-exports” or “–add-opens” parameters to the JAVA_TOOL_OPTIONS. This is the Strong Encapsulation, which started with JDK 9 and was only displaying warnings until JDK 16. With Java 17, however, it is now fully in effect […]
dbi Blog
The PostgreSQL mailing list archives are a wonderful place to get new ideas just by reading through random posts. This time I found an interesting idea on how to partition an existing table almost online without dumping and reloading the data in some way. For those who remember: Before PostgreSQL 10 the only way to […]
dbi Blog
While investigating a customer issue (details here) one of the replies suggested to use pre_auth_delay to add a delay before a session is authenticated. Even if this was not useful for the actual issue, this can be very useful for other scenarios, and this is the reason for this short blog post. Let’s assume you […]
dbi Blog
As I reflect on my last day at PGConf.EU 2024 in the beautiful city of Athens, I am filled with a profound sense of gratitude and excitement. The conference was a melting pot of innovation, knowledge sharing, and community spirit, all centered around PostgreSQL—a project that continues to inspire and evolve. Here are few of […]
dbi Blog
The PostgreSQL community is growing every year and the same happens for pgconf.eu, which happened in Athens, Greece, this year. Attending this event is one of the best opportunities to get in touch with the people behind PostgreSQL. This year we had 778 attendees. May it be PostgreSQL hackers, users, developers, organizers or anyone else […]
dbi Blog
Here’s the following day 2 of the PostgreSQL Conference Europe 2024 in Athens, if you haven’t read the first day here is the link. After a fantastic first day, I was excited to dive into the next day of the conference, which offered a mix of technical sessions that covered essential topics like upgrading PostgreSQL, […]
dbi Blog
Attending PostgreSQL Conference Europe 2024 in Athens is an incredible experience, full of enriching conversations and technical deep dives. As a DBA Consultant and speaker (on the reserve list and honored to have been chosen), it was my first time meeting this amazing community in person and I was immediately struck by the camaraderie and […]
dbi Blog
Last week, I had the pleasure to be invited to the M-Files Regional Partner in Geneva. M-Files people rallied around us: Tero Antila – Director EMEA Partner SalesHelinã Mellanen – Senior Enablement ManagerEmilie Feat – Senior Partner Manager SwitzerlandSebastian Wegener – Senior Partner Manager Germany & AustriaJoachim Bleicher – Senior Partner Sales EngineerMustapha Laouari – […]