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.
No comments