When the default value is not the same as the default
I was working on a minor problem recently where controlfile autobackups were written to the wrong...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (108)
Data encryption at rest in Oracle MySQL 5.7
I've previously evaluated MariaDB's 10.1 implementation of data encryption at rest (...
Internals of querying the concurrent requests' queue - revisited for R12.2
Once upon a time I wrote about the Internal Workflow of an E-Business Suite Concurrent Manager...
More effective anti-entropy repair in Cassandra
1. Introduction Cassandra offers three different repair mechanisms to make sure data from different...
Installing SQL server 2016 - standalone instance - new features
In this article I am going to go through a typical install of SQL Server 2016, and explain some of...
Oracle Live SQL: explain plan
We've all encountered a situation when you want to check a simple query or syntax for your SQL and...
Mind your rdbms/audit on 12c
Recently we've ran into an interesting question from one of our clients. They were seeing messages...
Redshift table maintenance: vacuuming
Overview Part of the appeal of AWS' Redshift is that it's a managed service, which means lower...
Migrate a SQL Server environment with complex replication without reinitializing or rebuilding replication
When you have a SQL Server environment where a very complex replication setup is in place, and you...
More fun with oracle timestamp math
Timestamp Math Several years ago I wrote an article on Oracle date math. Amazingly, that article...
