SQL Server compression methods testing and comparison Posted on April 10, 2025 , Modified on October 28, 2025 , by Yannick JaquierTable of contents Preamble SQL Server compression test case SQL Server compression testing sp_estimate_data_compression_savings Row compression Page compression COMPRESS/DECOMPRESS compression Columnstore compression Columnstore archive compression SQL Server compression wrap up References Read more SQL Server Tuning 2 comments
Convert a database to Unicode (AL32UTF8) Posted on March 20, 2025 , Modified on February 11, 2026 , by Yannick JaquierTable of contents Preamble DMU preparation DMU scan the database DMU Resolve migration issue DMU convert the database to Unicode References Read more Oracle Database Migration Assistant for Unicode (DMU) Leave a comment
Transparent Application Continuity (TAC) hands-on Posted on March 2, 2025 , Modified on February 20, 2025 , by Yannick JaquierTable of contents Preamble Transparent Application Continuity (TAC) setup Transparent Application Continuity (TAC) testing with SQL*Plus TAC compatible service Transparent Application Continuity (TAC) testing with Java Errors encountered Service not automatically started References Read more Oracle Data Guard, Development, Transparent Application Continuity (TAC) Leave a comment
Oracle Data Guard per Pluggable Database hands-on Posted on February 10, 2025 , Modified on February 10, 2025 , by Yannick JaquierTable of contents Preamble Databases Data Guard preparation Container databases preparation Create a new pluggable database for replication Data Guard Broker configuration Data Guard Broker configuration creation Copy of source pluggable database datafiles Pluggable Data Guard testing Preparation Switchover Failover Pluggable Data Guard cleaning Errors encountered ORA-00922: missing or invalid option wth edit configuration prepare dgpdb command _DGMGRL legacy service name RMAN duplicate command error DGM-17437 References Read more Oracle Data Guard, High Availability Leave a comment
Is JSON datatype performance really faster than BLOB datatype ? Posted on January 20, 2025 , Modified on June 12, 2026 , by Yannick JaquierTable of contents Preamble Loading JSON into Oracle with Python JSON queries and performance comparison JSON basic queries JSON performance comparison To go further with JSON performance References Read more Oracle Development, SQL Leave a comment
Automatic SQL Plan Management (ASPM) hands-on Posted on December 30, 2024 , Modified on July 13, 2026 , by Yannick JaquierTable of contents Preamble Automatic SQL Plan Management (ASPM) setup Automatic SQL Plan Management (ASPM) test case We live in a peaceful world (so far) Who has messed up ? Automatic SPM to the rescue References Read more Oracle Automatic SQL Plan Management (ASPM), SQL Plan Management (SPM) 1 comment