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.
Introduction During a previous post, we saw how to browse in your Redis data using it’s official tool Redis insight 🙂 As per a customer request we want to centralize all data types and tool in one tool. How to proceed?For this topic we will use a database manager named DBeaver Unfortunately this tool is not supporting Redis, unless we…
Introduction MongoDB is a no sql database based on key value pair database ( as Redis ) In this topic we will check how to install MongoDB Community edition using the MSI file ( with cmd method and setup wizard method ) After that we will be able to use Mongo DB on our windows system and begin to work…
Is the Oracle Cloud a hot topic for you? dbi services organized an event about the Cloud today in Lausanne: “Oracle Cloud Infrastructure: everything for an efficient migration“. After a welcome coffee to meet each other, Pascal Zanette shortly introduced the event and the agenda of the day. Our CTO Hervé Schweitzer presented then YaK, developed by dbi services.The idea…
I ran into an interesting scenario with a customer that I want to share in this blog post.This customer is running a data-loading activity on a monthly basis from his business application.He did not complain about the performance, the time of this activity is quite correct.But, I was asked to monitor the activity from an SQL Server point of view.…
Introduction: Here is the second part of the Redis keys and features, we will see how to use, with a description from the official Redis site and some example for : So open your Redis-server and let’s check what is behind these different data types, and test some great features like: The different Data type Description: HyperLogLog is a data…
Introduction: Hi team , we have seen during previous posts, how is working Redis , how to browse into data using Redis Insight and how to backup your database. This time , in this first part ,we will go deeper by checking the different key type ,how to use it and their limitation. So let’s go! About Redis As a…
After the Keynote about “Oracle Database 23c – the developers release!” by Connor Mc Donald where he presented all the newest features of Oracle 23c Developer release, I decided to attend presentations on following topics:– APEX hidden gems – Template Directives– Authentication management over many applications– Futuristic SQL: Making the Impossible Possible– APEX-Item-Plugin Development for Forms and Interactive Grids– Deconstructing…
I recently patched an Oracle Database Appliance (ODA) from 19.16. to 19.18. Detailed steps on how to patch to 19.18. are available here. During the update-server step I got the following error: So obviously something is wrong with sshd_config. If an error happens when running a job on the ODA with odacli then I check the dcs agent logfile /opt/oracle/dcs/log/dcs-agent.log.…
This year again the APEX connect conference spans over two days onsite in Berlin, with mixed topics around APEX, like JavaScript, PL/SQL and much more.After the welcome speech and the Keynote about “22.2, 23.1, and beyond” by the Oracle APEX Team, I decided to attend presentations on following topics:– How should we design a database? You decide!– IoT and APEX…
I’m going to explain how to do a manual Switchover in a MariaDB HA setups using master-slave replication. In my example, let’s consider that I’ve a server01 and server02, both running on Ubuntu 20.04. server02 is currently the master, server01 the slave. We’ll perform a switchover to come back to a normal status, meaning server01 as master and server02 as…
Introduction: Redis is a nosql database , a high performance key-value database management system that stores information in memory for fast access. It can be used to manage your users’ sessions or your site’s cache, for example. In a previous a blog we have seen how to import a dataset or create one from you own . To perform this…
Introduction: As you may know Redis is a nosql database. It uses key-value pairs to store data whereas SQL database works as a table-based relational database structure. We ever seen how to create entries in Redis using typical commands like HSET , SET ,ZADD and so on ( I will prepare a reminder of these commands with explanations in an…
