This Log Buffer Edition ventures out in the fields of Oracle, SQL Server and MySQL and picks some of the coolest blog posts for this week.
In Oracle, if we add a column to a table which is NOT NULL, we are allowed to do it directly, in a single statement, as long as we supply a DEFAULT value to populate any pre-existing rows.
There have been rumblings from the HPC community indicating a general suspicion of and disdain for Big Data technology which would lead one to believe that whatever Google, Facebook and Twitter do with their supercomputers is not important enough to warrant seriousness—that social supercomputing is simply not worthy.
Work-around Instance Migration Limits of BPM Suite 11g.
Oracle Event Processing 12c: java errors when deploying a new OEP project.
Creating a WebLogic 12c Data Source Connection to Pivotal GemFireXD 1.3.
It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.
There’s a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can’t find a table.
Stairway to AlwaysOn Level 3: Infrastructure 101.
How to compare two databases and email the results to every one who needs to know.
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA.
Set up an SSL-encrypted connection between Sphinx and MySQL.
Sometimes users ask for something that doesn’t really make sense. On the first glance. But then you start asking and realize that the user was right, you were wrong, and it is, actually, a perfectly logical and valid use case.
PECL/mysqlnd_ms needs updates for MySQL Group Replication.
Why should you migrate from MySQL to MariaDB?
The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3).