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 at half rack ...

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?

SQL Injection with MySQL SLEEP()

Recently we've received an alert from one of our clients that running threads are high on one of their servers. Once we ...

Network multicast support on Azure

Configure high availability - load balancing for Hiveserver2

We are noticing a steady adoption of Hive adoption among our customers. Due to the increased workload we want to make ...

Oracle RAC on Azure

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

More fun with oracle timestamp math

Timestamp Math Several years ago I wrote an article on Oracle date math. Amazingly, that article was still available ...

Issues with Oracle secure external password stores

Background In the previous article, I covered the basics of how to remove database passwords (credentials) from Oracle ...

Securing Oracle monitoring and backup scripts

Background Almost every DBA writes and uses various custom scripts to monitor and backup their Oracle databases. ...

Redshift table maintenance: vacuuming

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

How to run OpenTSDB with Google Bigtable

In a previous post ( OpenTSDB and Google Cloud Bigtable) we discussed OpenTSDB, an open source distributed database ...

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 effective (and ...

Oracle Live SQL: explain plan

We've all encountered a situation where you want to check a simple query or syntax for your SQL and don't have a ...

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 you need to ...

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. Let's ...

Data encryption at rest

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

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 feature introduced - Basic ...

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 Kafka adapter. ...

Google Cloud Dataproc in ETL pipeline - part 1 (logging)

Google Cloud Dataproc, now generally available, provides access to fully managed Hadoop and Apache Spark clusters, and ...

More effective anti-entropy repair in Cassandra

1. Introduction Cassandra offers three different repair mechanisms to make sure data from different replicas are ...

Changes to DBCA patch application behaviour causes PDB cloning to fail

Background A test upgrade from 11g to 12c and conversion to a container and pluggable database recently pointed out ...

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 first part of the ...

Connection timeout parameters in MySQL

Introduction wait_timeout interactive_timeout net_read_timeout net_write_timeout What do these timeouts do in MySQL? If ...

Centralized authentication with Red Hat directory server for Linux systems

User management on Linux systems can be tedious, and when you add in more than 10 systems the chances are it is going ...