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.
This year’s edition of PostgreSQL Conference Europe finished last Friday, the 15th of December. It was the largest ever PostgreSQL Conference Europe with more than 700 attendees. For me the week already started on Monday, because I had to be there the day before the conference for the training day. With 25 people the training was completely sold out and…
Introduction Patching your Oracle Database Appliance (ODA) is highly recommended: once a year being the minimum you could do. It prevents security risks, fixes some bugs and eventually provides new features. And it also keeps your appliance supported: according to MOS note 2757884.1, your ODA should be running version 19.16 for X7-2 series, X8-2 series and X9-2 series, and version…
PostgreSQL, an open-source relational database management system, offers robust features and capabilities for data storage and management. Deploying PostgreSQL within the Oracle Cloud Infrastructure (OCI) provides a scalable and reliable environment. In this guide, we’ll explore the process of setting up PostgreSQL in OCI. We will also push a bit more to learn how backup/restore and failover works. Let’s discover…
Oracle Data Redaction: What It Is and How to use it. A quick example usage case.
Configure Oracle Database Server and it’s Database with OKV using RESTfull API
I know, few years ago, it was uncredible to associate SQL Server & PostgreSQL or see Microsoft in the Open source world. 😉 The world changes and we follow it… My colleague Daniel Westermann will enjoy that I write a blog about PostgreSQL but also SQL Server… My first one in 10 years by dbi services but it’s good to…
Introduction Oracle 23c is not yet available on Oracle Database Appliance (ODA), but it should be ready in 2024. As 23c is the next Long Term release, 19c databases will probably migrate to 23c in the coming years. If you decided to use DB Systems on your ODA, you might think that migration will not be that easy. But it’s…
Recently a customer asked me to check why a load process from a banking application has so poor performance.In fact this process is extremely slow, between 40 minutes up to more than one hour to load around 240’000 rows. As the application is a black box for my customer I have first to find out which queries are running during…
Introduction I was asked by one of my customers to have a look at the SQL Server 2022 Integrated acceleration & offloading feature. The goal of it is to provide a framework for offloading specific SQL Server workload compute to hardware devices. At first it seems very interresting to speed up for instance backup tasks especially for big databases. But…
In this blog post, we will quickly see what is required to monitor a Microsoft SQL Server with Zabbix. Agent Setup Agent setup is not required by MSSQL by ODBC template; thus this step can be skipped. Setup Monitoring Account The best practice is to create an account in the database dedicated to monitoring which will have limited permissions (view,…
Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).
Oracle Key Vault 21.7 introduce the SSH key support, a new type of endpoint(SSH server) and a new wallet type (SSH Wallet).
