PRKO-2002 : small things, large shadows

This short blog post is a reminder to remember the syntax.

I was just trying to bring down local listeners ...

Reserved words usage in MySQL

It is not uncommon to come across MySQL databases where reserved words are in use as identifiers for any kind of ...

Step-by-step guide to January 2016 PSU patch apply on 12c drid and RDBMS homes in Linux

How to build a multi-domain cluster with AlwaysOn availability groups - SQL Server 2016

SQL Server 2016 is making lots of news, and promises to be a revolutionary SQL Server version. In talking about ...

An UNDO in a PDB in Oracle 12c?

MySQL InnoDB’s full text search overview

NOTE: If you want to read and play with the interactive application, it has been developed using Shiny/R in order to ...

Oracle RAC on Azure

Microsoft Azure provides an acceptable and affordable platform for a training environment. I am an Oracle DBA, and ...

More fun with oracle timestamp math

Timestamp Math

Issues with Oracle secure external password stores

Background

Securing Oracle monitoring and backup scripts

Background

Redshift table maintenance: vacuuming

Overview of managed service maintenance

Part of the appeal of AWS' Redshift is that it's a managed service, ...

Oracle's CREATE INDEX command can take a hint

While experimenting with Auto DOP (parallel_degree_policy) in Oracle 12c, I stumbled upon a highly ...

Oracle Live SQL: explain plan

We've all encountered a situation where

Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

Introduction

When you have a SQL Server environment where a very complex replication setup is in place, and ...

Improve parsing and query performance - fix Oracle's fixed object statistics

What do I mean by 'fix' the the fixed object statistics? Simply gather statistics to help the optimizer. What are ...

GoldenGate 12.2 big data adapters: part 1 - HDFS

December 2015 brought us a new version of GoldenGate, and a new version for Big Data adapters for the GoldenGate. ...

Data encryption at rest

This blog post was co-authored by Peter Sylvester and Valerie Parham-Thompson Introduced in version 10.1.3 ...

SQL server 2016 - AlwaysOn basic availability group

Recently I was playing with the SQL Server 2016 CTP 2 and noticed that there was a new ...

Enabling large pages on Oracle Database 11g running on IBM AIX

For implementing Large Pages on AIX first you will need to choose large page size at OS level. On AIX you can have ...

GoldenGate 12.2 big data adapters: part 3 - Kafka

This article continues our deep dive into the GoldenGate Big Data adapters, specifically focusing on the ...

How to deal with MetaData Lock

What is MetaData Lock?

MySQL uses metadata ...

More effective anti-entropy repair in Cassandra

1. Introduction

Changes to DBCA patch application behaviour causes PDB cloning to fail

Background

GoldenGate 12.2 big data adapters: part 2 - FLUME

In this blog post, we continue our review of the new Oracle GoldenGate Big Data adapters. In the ...

Connection timeout parameters in MySQL

Introduction

• wait_timeout
  
  
• interactive_timeout
  
  
...