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.
Few days ago, I install new instances SQL Server 2022 and the new SSMS by a customer and when I register the instances in the Central Management Servers (CMS), I was surprise by the error coming from the connection test: ERROR Message: A connection was successfully established with the server, but then an error occurred during the login process. (provider:…
Procedure to check a one-to-one migration between different database types autogenerated and generically with OMrun.
The PostgreSQL Conference Germany 2023 is over and it was a success. We had 250 attendees which made this year’s edition of the conference the largest ever. For us the conference already started Monday evening with the speakers and volunteers social event and dinner. We had a great tour through the Zeche Zollverein and learned a lot about German mining…
Since Apple released their Apple Silicon Laptops based on the ARM processor architecture, it became difficult for Consultants with such a device to run their Oracle Sandbox environment, because the main Oracle products are running on the Intel architecture. Hence a virtual machine on an Apple Silicon MacBook cannot be used for e.g. an Oracle Database Sandbox environment. You may…
Introduction: As for Redis , MongoDB has its own backup utility to export and import data.This tool allow you in a single command to backup your database and your collections and then to load them. To save your data, we will see how to use mongodump and then for restoration we will use mongorestore.Note that we can also use mongoimport…
Introduction: MongoDB and Redis are both NoSQL databases.In other words they don’t use “traditional” relational database to manage data. Although they have the same label – NoSQL – their storage concepts are very different: MongoDB stores data on disk, whereas Redis is an in-memory database. These aren’t the only differences between these two great tools, and that’s what we’re going…
Introduction: Hi Team , today we will see a very interesting and useful feature of Redis.The Redis geospatial indexing What is Geostail indexing? Redis geospatial indexes let you store coordinates and search for them. This data structure is useful for finding nearby points within a given radius or bounding box. It’s really useful in applications that deal with large amounts…
Introduction Patching an Oracle Database Appliance is divided in 4 main steps with 4 odacli commands in this order: It’s always recommended to update all the components, but it’s possible to stop after storage update if you want to keep older versions of the DB homes. Normally, the update-server wouldn’t need looking into DB homes, but it requires your DB…
Zabbix comes with an Oracle Database monitoring template out-of-the-box, so it should not be too complicated to integrate one server. Nevertheless, I faced a few issues while trying to setup one and I will detail these steps below. Agent Installation Firstly, we need to install Zabbix Agent 2 on the Oracle VM. The official web site is guiding us to…
Oracle provides an OVA (Open Virtual Appliance) file to install the 23c Free Developer Release on Virtualbox. An OVA file contains metadata and file elements in the Open Virtual Format (OVF) to package and distribute one or more virtual machines. The OVA-file provided by Oracle can also be used to import the Oracle 23c Free VM to Proxmox. Here are…
PostgreSQL 16 is already in feature freeze and Beta1 has been released on May 25th. This is the time you should start testing and report any issues back to the community. There are plenty of new features, as usual, and in this post we’ll take a look a additional statistics in the pg_stat_*_tables catalog views. Let’s create a small simple…
Time flies, we are in June already and at the end of this month two PostgreSQL conferences will take place: There is 2023.pgconf.de, this year in Essen, the 27th of June. For the first time in the same week and for the first time one and a half day, there is the Swiss PGDay, the 29th and 30th of June…
