Log Buffer #365, A Carnival of the Vanities for DBAs

This Log Buffer edition covers various tips, new releases, and technically rich blog posts from the worlds of Oracle, SQL Server and MySQL.

Oracle:

Why choose Oracle for Advanced Analytics? Mark Hornick answers.

Michael Rainey talks about Data Integration Tips: ODI 12c – Substitution API GUIDs.

Warren Baird has shared a tip.  If you are using AutoVue with large 3D models it is often valuable to increase the maximum heap size available to the AutoVue client.

Sveta reports that new version of JSON UDF functions: 0.3.1 has been released. This is development release which contains new functionality. You can download functions from the MySQL Labs website.

A new IOUG research report “Efficiency Isn’t Enough: Data Centers Lead the Drive to Innovation” presents the results of a survey of 285 data managers and professionals.

SQL Server:

A drive on a mission-critical server is reaching capacity, and the new DBA is panicking. How do you approach a ballooning log file that won’t stop growing?

Is there a way to process only the new data for a partition in SQL Server Analysis Services? Yes, this is accomplished in SQL Server Analysis Services with the ProcessAdd option for partitions. Daniel Calbimonte demonstrates how it works.

Stairway to XML: Level 1 – Introduction to XML

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code.

Private Cloud, What Is It and Why Do You Need It?

MySQL:

Performance_schema success stories : replication SQL thread tuning

Real-Time Data Loading from MySQL to Hadoop with New Tungsten Replicator 3.0 — Webinar-on-Demand

There was an exciting announcement today about WebScaleSQL, the new “branch” (not a fork, they say!) of MySQL created by folks from MySQL engineering teams at Facebook, Google, LinkedIn, and Twitter.

I have wanted multi-source replication in MySQL since 4.0, so I was delighted to see this feature appear in MariaDB 10.0.

Joro wrote recently about MySQL 5.6.17‘s new support for AES-256 encryption, and it’s a great improvement for people need to encrypt their data at rest.