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

Posted in: Log Buffer, Technical Track

This Log Buffer edition works it way through some of the coolest blog posts from Oracle, SQL Server and MySQL of the past week.

Oracle:

  • What if I’m a developer or QA person using a copy of production database to do my work. What if my copy of production is now out of date and I want to refresh my data with the data as it is on production.
  • Direct path and buffered reads again.
  • Copy Data Management for Oracle Database with EMC AppSync and XtremIO.
  • Little things worth knowing: automatic generation of extended statistics in 12c.
  • Any time you execute more than one SQL statement in a PL/SQL procedure the results of executing that procedure may not be self-consistent unless you have explicitly locked your session SCN to a fixed value!!!!!

SQL Server:

  • An Introduction to the SQLCMD Mode in SSMS (SQL Spackle).
  • Describes the idle connection resiliency feature, which allows ODBC and SqlClient data access applications to maintain their connections to SQL Server 2014 or an Azure SQL Database.
  • How to Upgrade SQL Server.
  • Integration Services Logging Levels in SQL Server 2016.
  • Understanding the OVER clause.

MySQL:

  • Proxy Protocol and Percona XtraDB Cluster: A Quick Guide.
  • Do not run those commands with MariaDB GTIDs.
  • What If You Can’t Trace End-to-End?
  • Storing UUID Values in MySQL Tables.
  • How to Deploy and Manage MaxScale using ClusterControl.

 

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 *