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

Posted in: Technical Track

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


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?


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.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

I have been in love with Oracle blogging since 2007. This blogging, coupled with extensive participation in Oracle forums, plus Oracle related speaking engagements, various Oracle certifications, teaching, and working in the trenches with Oracle technologies has enabled me to receive the Oracle ACE award. I was the first ever Pakistani to get that award. From Oracle Open World SF to Foresight 20:20 Perth. I have been expressing my love for Exadata. For the last few years, I am loving the data at Pythian, and proudly writing their log buffer carnivals.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *