Use case for SQL server table partitioning
Often we are asked by our clients about Table Partitioning, and specifically, which tables will be...
Pythian Blog: Data Analytics, Cloud Computing, and Database Management (112)
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...
Is Oracle smart flash cache a "SPOF"?
Oracle Smart Flash Cache (OSFC) is a nice feature that was introduced in Oracle 11g Release 2. As...
ASM nternals: tracking down failed ASM reads
On a live customer system, we've encountered repeated incidents of errors such as the following:...
Recursion in Hive - part 1
I am going to start this new series of blog posts talking about code migration use cases. We will...
How to decipher oracle Internal datatype storage
What started out as an investigation into how the optimizer deals with predicates that are outside...
Benchmarking Google Cloud SQL instances
Google Cloud SQL is a fully managed database service that makes it easy to set-up, maintain,...
Why locking Oracle accounts is a bad idea
Time and time again I run into database accounts, which are marked "LOCKED" or "EXPIRED & LOCKED"....
How to troubleshoot an ORA-28030 error
ORA-28030: Server encountered problems accessing LDAP directory service. Cause: Unable to access...
Step-by-step upgrades to Cloudera Manager and CDH
Lately, several of our security conscious clients have expressed a desire to install and/or upgrade...
