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
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
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
GoldenGate 12.2 big data adapters: part 3 - Kafka

GoldenGate 12.2 big data adapters: part 3 - Kafka

Mar 31, 2016 12:00:00 AM 16 min read
In depth: MySQL 5.6+ DDL

In depth: MySQL 5.6+ DDL

Mar 29, 2016 12:00:00 AM 8 min read
Amazon database migration service - first try

Amazon database migration service - first try

Mar 28, 2016 12:00:00 AM 6 min read
Apache Cassandra 2.1 incremental repair

Apache Cassandra 2.1 incremental repair

Mar 21, 2016 12:00:00 AM 3 min read
GoldenGate 12.2 big data adapters: part 2 - FLUME

GoldenGate 12.2 big data adapters: part 2 - FLUME

Mar 17, 2016 12:00:00 AM 14 min read
Converting Hortonworks Sandbox to run on Hyper-V

Converting Hortonworks Sandbox to run on Hyper-V

Mar 15, 2016 12:00:00 AM 2 min read
Changes to DBCA patch application behaviour causes PDB cloning to fail

Changes to DBCA patch application behaviour causes PDB cloning to fail

Mar 11, 2016 12:00:00 AM 12 min read
Centralized authentication with Red Hat directory server for Linux systems

Centralized authentication with Red Hat directory server for Linux systems

Mar 10, 2016 12:00:00 AM 12 min read
Debugging Kibana using Chrome developer tools

Debugging Kibana using Chrome developer tools

Mar 8, 2016 12:00:00 AM 3 min read
SQL Injection with MySQL SLEEP()

SQL Injection with MySQL SLEEP()

Mar 2, 2016 12:00:00 AM 4 min read
Google Cloud Dataproc in ETL pipeline - part 1 (logging)

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

Feb 22, 2016 12:00:00 AM 4 min read
The value of Pythian’s internship program

The value of Pythian’s internship program

Feb 19, 2016 12:00:00 AM 2 min read
Data encryption at rest

Data encryption at rest

Feb 18, 2016 12:00:00 AM 9 min read
How to build a multi-domain cluster with AlwaysOn availability groups - SQL Server 2016

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

Feb 17, 2016 12:00:00 AM 4 min read
How to migrate from on-premises to Azure SQL database

How to migrate from on-premises to Azure SQL database

Jan 15, 2016 12:00:00 AM 11 min read
SQL server 2016 - AlwaysOn basic availability group

SQL server 2016 - AlwaysOn basic availability group

Jan 5, 2016 12:00:00 AM 2 min read
How to decipher oracle Internal datatype storage

How to decipher oracle Internal datatype storage

Dec 11, 2015 12:00:00 AM 9 min read
Benchmarking Google Cloud SQL instances

Benchmarking Google Cloud SQL instances

Dec 10, 2015 12:00:00 AM 3 min read
Why locking Oracle accounts is a bad idea

Why locking Oracle accounts is a bad idea

Dec 10, 2015 12:00:00 AM 2 min read