Working with resource groups in MySQL 8

MySQL 8 is GA and it has a variety of new features. Recently, we happened to work with resource groups to restrict ...

Oracle DBSAT Discoverer feature

Oracle EBS Vision Instance on docker

Continuing my previous efforts in getting docker running on Oracle Linux in this blog post, I worked on getting Oracle ...

Oracle parallel query hints reference - part 6: USE_PARTITION_WISE_GBY

Welcome to part 6 of the series. The USE_PARTITION_WISE_GBY hint is "brand new," introduced in 12.2. I personally ...

Text index usage within MongoDB

Recently a client came to me asking “How do we verify if a full text search index is being used on MongoDB?” The ...

So you have a broken Cassandra SSTable file?

Every few months I have a customer come to me with the following concern: my compactions for one of my Cassandra tables ...

Troubleshooting RAC GoldenGate relocation

During Oracle RAC online patching, the GoldenGate resource must be relocated to a surviving node to maintain ...

MySQL plugin for Oracle Enterprise Manager 13c Cloud Control

This is the same plugin that Alex Gorvachev created back in the day. I've simply modified it to be compatible with both ...

Oracle parallel query hints reference - part 5: PQ_DISTRIBUTE_WINDOW

Welcome to part 5 of the series.

Troubleshooting a datapatch error in Oracle

Troubleshooting datapatch failure As part of patching preparation, the following command was executed and failed: ...

How do you test your Oracle database backup?

From my experience, the one area where a DBA cannot afford to make errors is in database backup. When was the last time ...

Troubleshooting a GoldenGate error code

Introduction After applying Oracle GoldenGate V12.2.0.1.170919 for Oracle Database 12c OPTIMIZER Patch for Bug# ...

Oracle parallel query hints reference - part 7: PQ_DISTRIBUTE and partitioned tables

In Part 1 of the series, we covered in detail how the PQ_DISTRIBUTE can change the data distribution method across ...

How to find unused indexes and drop them safely in MongoDB

Indexes increase read performance and allow queries to access data faster. But they also need to be updated when the ...

How to test an Oracle database upgrade using a physical standby

It was a Thursday morning. I started my day at work and found out that I was tasked with running a test upgrade to ...

HugePages for Oracle Database in Azure Cloud

So, what's up? In case you don't know, my co-worker Gleb Otochkin has written a couple of blog entries about HugePages' ...

Log buffer #555: a carnival of the vanities for DBAs

This log buffer edition covers Cloud, Oracle and MySQL.

Authenticating MySQL 8.0 (Enterprise) against active directory

Recently our team was tasked to implement MySQL 8.0 in production for a client. While MySQL 8.0 is looking very ...

Installing Oracle 18c using command line

Introduction Just three days ago Oracle released Oracle 18c for general installation on-premises. We've had a taste of ...

Does Oracle allocate PGA in HugePages?

The short question While preparing a presentation I am giving this year about HugePages, a colleague of mine at Pythian ...

How to manage multiple MySQL binary installations with SYSTEMD

This blog will go into how to manage multiple MySQL binary installations with SYSTEMD using the systemctl command. With ...

Choosing best index for your MongoDB query

Introduction Indexing plays a quintessential role in database query performance and MongoDB is no exception. Choosing ...

Getting started with Oracle Database Backup Service in 2018

A few years ago I wrote an article on getting started with the Oracle Database Backup Service which can be found here. ...

Installing SQL Server 2008 R2 on Windows 2012 cluster

Despite being an older version, some applications may require you to install a SQL Server 2008 R2 clustered instance on ...

Is slave_exec_mode idempotent actually idempotent?

Background Co-Author: Rafael Alvarez When you look up the word idempotence in wikipedia you get the following ...

News and upates from Microsoft Azure, pt II

I recently joined Chris Presley for his podcast, Cloudscape , to talk about what’s happening in the world of ...