Optimizing Reports and Automating Failure Monitoring Using PL/SQL and the RMAN Catalog

The blog post is an addition to my earlier blog post

Automating Oracle RMAN Backup Reports with PL/SQL Using the RMAN Catalog

The reason for this blog post is to provide an alternative way on how to review RMAN backups for Oracle Database ...

Resuming OMSPatcher Session When it Failed to Apply a Patch

One of the hidden mechanics of PostgreSQL may not seem important at first

The Power of Three: How Pythian, Oracle, and Google Cloud’s Partnership Means Simpler Cloud Migrations

The

Unlock the Power of Google Cloud: Why It’s Time to Get Off Traditional Databases

Is it time to finally move off your traditional database and into the cloud? Many traditional environments are ...

What is the Best Way to Shrink Your Tables in PostgreSQL?

In PostgreSQL (PG), there are two issues when it comes to table bloat. One is a consequence of the MVCC ...

Solving PostgreSQL's pg_basebackup 'ERROR: temporary file size exceeds temp_file_limit'

When performing a pg_basebackup in PostgreSQL, you might run into this frustrating error:

pg_basebackup: ...
                  

                

Getting started with the Oracle Database @ Google Cloud Service - Service Setup

Now that the new “Oracle Database @ Google Cloud” service is in general availability ...

Installing Oracle Database 23ai Free for ARM - Solution to DBCA ORA-00600

On September 16th, 2024 Oracle released “Oracle Database 23ai Free” (Developer’s Edition) for the ARM (aarch64) ...

How Gemini for Databases Can Optimize Performance with Generative AI

Generative AI isn’t just for composing emails and creating presentations; the power of AI is also coming to ...

I Lost My ORAPKI Wallet Password—Now What?

Usually, you will face this issue when one of your certificates expires and you need to add a new one. When you try ...

How to Promote a Google Cloud Replica from an External MySQL Primary

This is the second blog in a series about how to migrate a MySQL instance from a VM to Google Cloud SQL. See the ...

How to Set Up a Neo4j Database

With the rise of generative AI, graph databases have become a trendy method to store data. Neo4j offers ...

MongoDB metrics and thresholds

In my earlier blog post about Replica Set Maintenance Activities (available ...

MongoDB Replica Set Maintenance Activities

As database administrators (DBAs) responsible for managing MongoDB replica sets, we are pivotal in ensuring the ...

The DBA’s Future Role in Driving Digital Transformation

The CTO's decision to drive digital transformation forward will impact the role of the DBA. The role of the DBA is ...

Expand Elastic Configuration on Oracle Exadata - Part 2

Expand Elastic Configuration on Oracle Exadata - Part 1

Unveiling the power of multi-IP addresses in SQL server always on listener

Expand your Oracle Tuning Tools with dbms_utility.expand_sql_text

Secure the Connection to Your VPC Network from Serverless Environments in Google Cloud

Kafka Monitoring on Kubernetes with Datadog

Mitigating Long Distance Network Latencies with Oracle Client Result Cache

Viewing PostgreSQL Logs from the OCI PostgreSQL Service

Creating an OCI PostgreSQL DB System using the CLI

Removing SQL Reporting Services instances from scale out deployment

Analyzing a Movie Dataset Housed on MongoDB Through GraphQL - Part 1: Introduction & Mongo Database Setup

An Introductory Guide on Deploying Cassandra Database using Ansible

Getting started with the OCI PostgreSQL service