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

Posted in: Technical Track

This Log Buffer Edition goes out deep into the vistas of database world and brings out few of the good ones published during the week from Oracle, SQL Server, and MySQL.

Oracle:

  • Overriding Default Context-Sensitive Action Enablement
  • This is an alternative to if… then… else… elsif… end if when you want to use conditional statements in PL/SQL.
  • Achieving SAML interoperability with OAM OAuth Server
  • Release of BP02 for Oracle Identity Manager 11.1.2.3
  • IT Business Edge: Oracle Ties Mobile Security to Identity and Access Management

SQL Server:

  • How to render PDF documents using SQL CLR. Also a good introduction on creating SQL CLR functions.
  • What is DNX?
  • SQL Server Performance dashboard reports
  • Using Microsoft DiskSpd to Test Your Storage Subsystem
  • Connect to Salesforce Data as a Linked Server

MySQL:

  • Optimizing PXC Xtrabackup State Snapshot Transfer
  • Adding your own collation to MySQL
  • Monitoring your Amazon Aurora Databases using MONyog
  • How much could you benefit from MySQL 5.6 parallel replication?
  • MySQL checksum

 

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 *