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

Posted in: Microsoft SQL Server, MySQL, Oracle, Technical Track

This Log Buffer Edition covers various blog posts from the last week regarding Oracle, SQL Server and MySQL.

Oracle:

  • Merging Overlapping Date Ranges with MATCH_RECOGNIZE
  • The latest version of Enterprise Manager, EM 12.1.0.5, has been announced!
  • Kdump is the Linux kernel crash-dump mechanism. In the event of a server crash, Kdump creates a memory image (vmcore) that can help in determining the cause of the crash.
  • APEX Connect Presentation and Download of the sample application
  • One of my favorite feature of ZFS is the I/O aggregation done in the final stage of issuing I/Os to devices.

SQL Server:

  • Reusing T-SQL Code is catching on.
  • SELECT INTO vs INSERT INTO on Columnstore
  • SQL Monitor Custom Metric: WriteLog wait time
  • Query Performance Tuning – A Methodical Approach
  • How to Get SQL Server Dates and Times Horribly Wrong

MySQL:

  • Hash-based workarounds for MySQL unique constraint limitations
  • Replicate MySQL to Amazon Redshift with Tungsten: The good, the bad & the ugly
  • Indexing MySQL JSON Data
  • Improving the Performance of MySQL on Windows
  • Auditing MySQL with McAfee and MongoDB

Learn more about Pythian’s expertise in Oracle , SQL ServerMySQL, as well as the author Fahd Mirza.

email

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 *