Log Buffer #439: a carnival of the vanities for DBAs

Posted in: Log Buffer, Technical Track

This Log Buffer Edition covers some nifty blog posts from Oracle, SQL Server and MySQL.


Oracle:

  • Real Application Testing report On Premise vs. Oracle Public Cloud
  • Foreign Keys and Library Cache Locks
  • IN/EXISTS bugs by Jonathan Lewis.
  • Creating a trace file from EM12c is quite easy and doesn’t require a DBA offering up the world to allow a developer or support person to perform this action.
  • Oracle Cloud : First Impressions

SQL Server:

  • Hidden Tricks To SQL Server Table Cleanup
  • An Introduction to the OpenPOWER Foundation
  • Configuring Service Broker Architecture
  • Understand the Limitations of SQL Server Dynamic Data Masking
  • Creating Dashboards for Mobile Devices with Datazen – Part 3

MySQL:

  • Second day with InnoDB transparent page compression
  • Amazon RDS Migration Tool
  • A new client utility called mysqlpump that performs logical backups, producing a set of SQL statements that can be run to reproduce the original schema objects and table data.
  • How MySQL-Sandbox is tested, and tests MySQL in the process
  • Orchestrator 1.4.340: GTID, binlog servers, Smart Mode, fail-overs and lots of goodies

 

Learn more about Pythian’s expertise in Oracle SQL Server & MySQL.

email

Author

Interested in working with Fahd? Schedule a tech call.

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 *