Featured blog posts

Things to consider when deciding on a primary key for your INNODB table

Things to consider when deciding on a primary key for your INNODB table

Jun 3, 2016 12:00:00 AM 6 min read
Encrypting sensitive data in puppet using hiera-eyaml

Encrypting sensitive data in puppet using hiera-eyaml

May 27, 2016 12:00:00 AM 3 min read
SharePlex replication between two instances on the same host

SharePlex replication between two instances on the same host

May 25, 2016 12:00:00 AM 6 min read
Understanding the database options - AutoClose

Understanding the database options - AutoClose

May 20, 2016 12:00:00 AM 3 min read
An effective approach to migrate dynamic thrift data to CQL, part 1

An effective approach to migrate dynamic thrift data to CQL, part 1

May 17, 2016 12:00:00 AM 6 min read
MySQL encrypted streaming backups directly into AWS S3

MySQL encrypted streaming backups directly into AWS S3

May 13, 2016 12:00:00 AM 8 min read
Analyze index validate structure - the dark side

Analyze index validate structure - the dark side

May 13, 2016 12:00:00 AM 10 min read
Properly removing users in MySQL

Properly removing users in MySQL

May 12, 2016 12:00:00 AM 4 min read
An effective approach to migrate dynamic thrift data to CQL, part 3

An effective approach to migrate dynamic thrift data to CQL, part 3

May 12, 2016 12:00:00 AM 6 min read
GoldenGate 12.2 big data adapters: part 4 - HBASE

GoldenGate 12.2 big data adapters: part 4 - HBASE

May 11, 2016 12:00:00 AM 13 min read
MySQL InnoDB’s full text search overview

MySQL InnoDB’s full text search overview

May 6, 2016 12:00:00 AM 6 min read
InnoDB flushing and Linux I/O

InnoDB flushing and Linux I/O

May 5, 2016 12:00:00 AM 2 min read
How to deal with MetaData Lock

How to deal with MetaData Lock

May 5, 2016 12:00:00 AM 5 min read
Reserved words usage in MySQL

Reserved words usage in MySQL

May 2, 2016 12:00:00 AM 1 min read
Deploy Docker containers using AWS Opsworks

Deploy Docker containers using AWS Opsworks

Apr 27, 2016 12:00:00 AM 4 min read
How to recover space from already deleted files

How to recover space from already deleted files

Apr 27, 2016 12:00:00 AM 4 min read
Improve parsing and query performance - fix Oracle's fixed object statistics

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

Apr 26, 2016 12:00:00 AM 5 min read
MySQL Query best practices

MySQL Query best practices

Apr 25, 2016 12:00:00 AM 5 min read
When the default value is not the same as the default

When the default value is not the same as the default

Apr 25, 2016 12:00:00 AM 3 min read
Data encryption at rest in Oracle MySQL 5.7

Data encryption at rest in Oracle MySQL 5.7

Apr 20, 2016 12:00:00 AM 5 min read
Internals of querying the concurrent requests' queue - revisited for R12.2

Internals of querying the concurrent requests' queue - revisited for R12.2

Apr 19, 2016 12:00:00 AM 7 min read
More effective anti-entropy repair in Cassandra

More effective anti-entropy repair in Cassandra

Apr 18, 2016 12:00:00 AM 9 min read
Installing SQL server 2016 - standalone instance - new features

Installing SQL server 2016 - standalone instance - new features

Apr 12, 2016 12:00:00 AM 6 min read
Oracle Live SQL: explain plan

Oracle Live SQL: explain plan

Apr 7, 2016 12:00:00 AM 3 min read
Mind your rdbms/audit on 12c

Mind your rdbms/audit on 12c

Apr 5, 2016 12:00:00 AM 3 min read
Redshift table maintenance: vacuuming

Redshift table maintenance: vacuuming

Apr 5, 2016 12:00:00 AM 5 min read
Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication

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

Apr 4, 2016 12:00:00 AM 2 min read
More fun with oracle timestamp math

More fun with oracle timestamp math

Apr 4, 2016 12:00:00 AM 16 min read
Enabling large pages on Oracle Database 11g running on IBM AIX

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

Apr 4, 2016 12:00:00 AM 3 min read
Best practice for setting up MySQL replication filters

Best practice for setting up MySQL replication filters

Apr 1, 2016 9:48:00 AM 11 min read