Enhanced password strength in MySQL with validate_password plugin Posted on April 12, 2017, updated on April 12, 2017 by Yannick Jaquier Table of contents Preamble Validate_password plugin installation Validate_password plugin testing References Continue reading
Automatic extended statistics to improve performance Posted on April 6, 2017, updated on April 6, 2017 by Yannick Jaquier Table of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
OGG-03517 when moving to Unicode from any other character set Posted on March 10, 2017, updated on April 24, 2017 by Yannick Jaquier Table of contents Preamble OGG-03517 with character set conversion Oracle Database Migration Assistant for Unicode References Continue reading
Audit creation and deletion of users for SOX evidences Posted on February 17, 2017, updated on March 1, 2017 by Yannick Jaquier Table of contents Preamble Oracle Legacy audit Unified audit Audit cleaning SQL Server Audit Audit cleaning MySQL MariaDB audit plugin McAfee audit plugin Percona audit plugin References Oracle SQL Server MySQL Continue reading
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017, updated on August 7, 2018 by Yannick Jaquier Table of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Continue reading
GoldenGate 12c (12.2) installation and configuration Posted on January 16, 2017, updated on January 16, 2017 by Yannick Jaquier Table of contents Preamble GoldenGate 12c installation GoldenGate 12c configuration GoldenGate 12c initial loading GoldenGate 12c apply change data References Continue reading