Database Resident Connection Pooling (DRCP) hands-on Posted on January 28, 2022, updated on January 25, 2022 by Yannick Jaquier Table of contents Preamble Database Resident Connection Pooling creation Database Resident Connection Pooling testing References Continue reading
Gradual Database Password Rollover hands-on Posted on December 28, 2021, updated on December 14, 2021 by Yannick Jaquier Table of contents Preamble Gradual Database Password Rollover testing Continue reading
Secure Oracle application design and the ANY privileges Posted on November 28, 2021, updated on November 23, 2021 by Yannick Jaquier Table of contents Preamble The not so bad solution to avoid CREATE ANY TABLE Oracle proxy user Conclusion References Continue reading
PHP OCI8 and PDO_OCI extensions installation to access Oracle Posted on October 28, 2021, updated on October 25, 2021 by Yannick Jaquier Table of contents Preamble OCI8 from pecl PDO_OCI OCI8 from PHP source References Continue reading
DBMS_DATA_MINING package for Machine Learning inside the database Posted on September 28, 2021, updated on September 27, 2021 by Yannick Jaquier Table of contents Preamble Loading dataset Dataset queries and charts Model creation and testing Conclusion DBMS_PREDICTIVE_ANALYTICS all in one bonus package References Continue reading
PostgreSQL graphical monitoring tools comparison Posted on August 28, 2021, updated on September 20, 2021 by Yannick Jaquier Table of contents Preamble pgAdmin Postgres Enterprise Manager Postgres Enterprise Manager Server Postgres Enterprise Manager Agent OmniDB Percona Monitoring and Management Server Client PGWatch To be continued... References Continue reading