Oracle e-Business Suite administrators have access to pretty extensive documentation regarding Patching procedures. In Oracle EBS 12.2 Oracle introduced ADOP patching method along with Oracle Database EBR (edition-based redefinition) feature that allows minimizing downtimes for patching activities. As with everything…

CockroachDB is a distributed SQL Database that has been gaining popularity in the last years because of its features. It is easy to deploy, with strong consistency, designed for the cloud, it has distributed transactions and easy to scale. Not…

In our previous post we discussed creating a data strategy storyboard. This first asset is important to align our executive and working teams on the measures and work tracks of our data strategy. Next, we explore the Lean Canvas (LC)…

Recently, I was helping a client with their AWS Elastic File Service (EFS), which is a managed NFSv4.1 service, with some additional connectivity and authentication capabilities. I was new to this client, so had little prior knowledge of their NFS…

Intro When we want to perform a heavy ALTER TABLE against  a several gigabytes table the options are quite a few but the one I tend to use the most is pt-online-schema-change (pt-osc). This tool is very mature and solid…

The package DBMS_CLOUD was first introduced in the Autonomous Database to provide a simple way to interact with an object store from the database. It is now available for on-premise databases starting with 19.9c and 21c. It works with OCI,…

This is the third and final post in the series of blog posts for MongoDB replica set backups with Point In Time Recovery (PITR). This will be focused on restores, particularly details on PITR using the full and incremental backups….

Recently I was working on a client request where a CDB along with a subset of its PDBs had to be cloned to a new server for testing purposes. This post illustrates that in certain circumstances the outcome of this…

In our previous post we explored how to inventory existing data assets as a baseline for understanding what assets we have available to influence our data strategy and accelerate its execution. This baseline allows us to quickly identify immediate use…

We previously discussed the successful formula for creating and executing an organization’s data strategy. The process of developing a data strategy should be led by executives focused on transformation, go-to-market or data. While the technology teams should be part of…