Postgres Covering Indexes and the Visibility Map

Covering indexes in Postgres came up in our weekly tech call because of a query optimization review one of the teams ...

ProxySQL Query Rules: Notes From Production

Oracle RAC: Network Performance with Jumbo Frames

Introduction When working with Oracle RAC, it's strongly advised to use Jumbo Frames for the network that provides the ...

Query Statspack's "SQL ordered by" Sections Over a Time Period

In this post, I'll present the statspack_top_sqls.sql script, which returns SQL performance statistics by mining the ...

Mining Statspack and AWR Repositories for Historical Trends

There are various ways that we can approach the analysis of a past database performance problem. The initial steps ...

Postgres Security Patches Related to the Search Path

There were some security patches released this month for Postgres, to put further restrictions on pathways that ...

PostgreSQL Backups

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and ...

VPN Options with Azure: Azure to Site

As business entities move some of their services to Microsoft Azure Cloud (Azure), we see hybrid networks emerge that ...

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL ...

The things I hate about Apache Cassandra

Intro First, let me start by saying I do not hate Cassandra. I love Cassandra. In its place, Cassandra is a powerful ...

Migrating SQL Server On-Premise to Azure SQL

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. ...

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

It’s one of those classic "Oracle knows best" moments, isn't it? You try to take back control of your own schema, and ...

Datapatch Failing on ORA-65108 (PDB$SEED): Applying Datapatch Manually

Problem In a new 12c environment (which actually includes 18c and 19c, as per the 12c family), the datapatch failed on ...

Installing OCI Command Line Utilities in Linux and Windows

As part of a recent project, I installed the Oracle Cloud command line utilities (oci) on the following Linux systems:

Migrate Postgres Database from EC2 instance to RDS using AWS DMS (Data Migration Services)

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data ...

Caution: Using AutoUpgrade with Multiple Databases from the Same ORACLE_HOME

Here's a short and sweet post. "In Deploy mode, AutoUpgrade also confirms that the upgrade has succeeded, and moves ...

Cassandra Vulnerability - CVE-2020-13946 - Apache Cassandra RMI Rebind Vulnerability

On September 1, 2020, Apache disclosed a security vulnerability for Apache Cassandra. Summary: It's possible for a ...

How To Export Collections in SCCM to CSV Using Powershell

Your mission: Gather a list of servers in a specific collection on System Center Configuration Manager (SCCM) so you or ...

CreateGoldImage Followup - Is CreateGoldImage Required for Cloning Oracle Home?

Comparing CreateGoldImage and Traditional Tar Cloning On October 31, 2019, I blogged about How To Use CreateGoldImage ...

Exadata's InfiniBand Switch: Incorrect NTP settings Leading to Evictions, and Patching Recommendations

Overview This post describes a recent outage during a routine Exadata (X7-2) patching to the 19.2.12.0.0.200317 release ...

AWS RDS: 5 Must-Know Actions for Oracle DBAs

Managing Oracle on AWS has some twists. Here are five daily DBA activities that have changed on AWS:

Deep Learning: Techniques to Avoid Overfitting and Underfitting

Machine Learning is all about striking the right balance between optimization and generalization. Optimization means ...

DBAs and the Cloud: Evolving Roles and New Challenges

The adoption of cloud services is soaring and causing an enormous shift in the role of DBAs. Depending on whether an ...

How to Connect from Cloud Functions to the Private IP Address of Cloud SQL in Google Cloud

Cloud functions allow you to run single-purpose functions without having to manage instances in Google Cloud. Cloud SQL ...