Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.
By Mouhamadou Diaw Generally we do active duplicate from primary database, but I think it should be fine to see what happen if we do active duplicate a database from a standby database. So, I do some tests and I write the results in this blog Below the actual configuration of my Data Guard environment 1 2 3 4 5…
In this blog-post I will discuss about my first test with Striim. Striim is a data integration platform which can ingest real-time data from a variety of sources (SQL Server, Oracle, Kafka, Hadoop…) and quickly deliver it to Cloud systems or even to an on-premise infrastructure. The goal today will be to do the creation of my schema data in…
Introduction Before Visual Studio 2019, you were able to install the SSDT with the offline installer. You were able to install it as a standalone Visual Studio for SSDT or for an already installed Visual Studio 2017. It was almost straightforward. With Visual Studio 2019, there is no SSDT standalone installer, so you have to install the extensions. Of course,…
This Blog is about a setup of RHEL 9 BETA and changes to RHEL 8 and Fedora 34 which is the base of RHEL 9. Let’s start with the setup. Start the installation. Preview warning: Language selection: Main setup window, similar to RHEL 8, for this blog I choose the workstation setup with Office: Checking network setup, without network there…
By Clemens Bleile I had a discussion with a customer recently about the risk of running into an issue with ransomware encrypting data of Oracle databases. Just to quickly recap on what ransomware is: Wikipedia: Ransomware is a type of malware from cryptovirology that threatens to publish the victim’s personal data or perpetually block access to it unless a ransom…
During our PostgreSQL DBA Essentials workshops we install PostgreSQL from source code. We do that, to provide the participants all the options they have. There is nothing wrong with using a packaged distribution of PostgreSQL, don’t get me wrong, but knowing how it is working in the background is always a good idea. One question that comes up quite frequently…
I have recently deployed a new ODA with last version 19.14 at customer side, and we could face an interesting failure deploying the appliance, which I would like to share with you. Problem description After reimaging the ODA and configuring the network interface with configure-firstnet, we created the appliance : [root@oak ~]# odacli create-appliance -r /u01/patch/ODA01.json Enter an initial password…
Since Tuesday, I have the chance to follow the SQLBits 2022 conference. Sadly, I have to do it remotely this year but I promise next time I will come in-person 😉 SQLBits is one of the largest SQL Server conference in the world with some famous speakers like Brent Ozar, Bob Ward, Erik Darling… In this blog post, I will…
As a consultant at dbi services, I am lucky enough to have time dedicated to training and conferences. This week I have the chance to attend one of the most important conferences for Data professionals: SQLBits 2022. The SQLBits conference is currently taking place at ExCel London and features over 300 sessions over 5 days. Tuesday and Wednesday, the pre-conference,…
By Mouhamadou Diaw With Oracle 21c (In fact Oracle 20c), we have a nice new feature with the broker which is the Fast-start Failover Callout Configuration scripts. I talked about this feature in some presentations I did about the new features with Oracle 21c for the broker This feature will allow to automate tasks that must be performed before and…
This blog describes the setup of a Consul Cluster on RHEL 8 and clones, it will be the base for a Patroni HA setup using RPM Packages from postgresql.org. Many Patroni setups are using ETCD, but ETCD is not available as RPM out of the box for RHEL 8 and clones, and in many cases using tar files or RPMS…
Introduction Patch 19.14 is now available on Oracle Database Appliance. It’s time to test it. What’s new? This version brings January’s PSU to database and grid homes with their bug fixes, as usual. It also brings latest 21.5 but only for DB Systems (21c being an innovation release). Don’t expect too many new features for this release (actually, I don’t…
