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

Posted in: Technical Track

This Log Buffer Edition marvels at the ease, simplicity, and power of the database bloggers as they go about their adventures in the realms of Oracle, SQL Server, and MySQL.

Oracle:

The new Oracle Database 12c’s “Implicit Result Sets” (IRS) feature allows query results to be returned from a stored PL/SQL procedure (or a PL/SQL anonymous block) without requiring a special PHP code.

Ranka has been spending a lot of time on big data and its application, architecture, and processes.

Kashif Manzoor tells us how to use the new Clone Log Parser utility in Oracle E-Business Suite.

Neil Chandler is killing a session OS style.

With the release of Oracle 12c, we get new functions/procedures and some updated ones for Oracle Data Miner, which is part of the Advanced Analytics option.

SQL Server:

SSRS has a default set of color combinations for charts. Let’s face it, they aren’t pretty. Jes Schultz Borland tells all.

Prashanth Jayaram is sharing a query to find data, log, Total Size, and other useful information on all databases.

Crash when inserting to a FileTable with a parallel plan.

Here is a post about resolving concurrency problems in SQL Server 2012.

What to do when you encounter DBCC CHECKDB … Terminated Abnormally Due to Error State 6.

MySQL:

Tony Darnell is creating and restoring database backups with mysqldump and MySQL Enterprise Backup.

Percona is glad to announce the release of Percona Monitoring Plugins 1.0.4. The components are designed to integrate seamlessly with widely deployed solutions, such as Nagios and Cacti, and are delivered in the form of templates, plugins, and scripts.

The MySQL Developer Tools team is pleased to announce the availability of the third beta release of MySQL Workbench 6.0. It is the new major update of the Development and Administration tool for MySQL.

Geoffrey Anderson has Innobackupex, schema migrations, and more!

pt-query-digest is the tool you use to generate a report of your slow query log (or some other supported sources) and is similar to, for example, the Query Analyzer in MySQL Enterprise Monitor.

Interested in working with Fahd? Schedule a tech call.

About the Author

I am in love with Oracle blogging since 2007. The 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 enabled me to get 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. These days for the last some 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 *