SQL Server on Linux – installation – part 1 Posted on October 1, 2022, updated on April 26, 2023 by Yannick JaquierTable of contents Preamble SQL Server on Linux installation SQL Server on Linux command-line tools installation Final cleaning to have all database files in good directories AdventureWorks example database installation Conclusion and next steps References Continue reading
MariaDB PAM LDAP authentication with newest SSSD daemon Posted on February 28, 2022, updated on February 23, 2022 by Yannick JaquierTable of contents Preamble MariaDB PAM LDAP Linux and database configuration Ldapsearch configuration MariaDB PAM LDAP authentication with legacy nslcd configuration MariaDB PAM LDAP authentication with System Security Services Daemon (SSSD) References Continue reading
Database Resident Connection Pooling (DRCP) hands-on Posted on January 28, 2022, updated on January 25, 2022 by Yannick JaquierTable of contents Preamble Database Resident Connection Pooling creation Database Resident Connection Pooling testing References Continue reading
PostgreSQL graphical monitoring tools comparison Posted on August 28, 2021, updated on May 8, 2023 by Yannick JaquierTable 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
PostgreSQL backup and restore tools comparison for PITR recovery Posted on July 28, 2021, updated on September 20, 2023 by Yannick JaquierTable of contents PostgreSQL backup and restore Pg_basebackup PgBackRest EDB Backup and Recovery Tool Barman To be continued... References Continue reading
GoldenGate for Big Data and Kafka Handlers hands-on – part 2 Posted on June 28, 2021, updated on June 22, 2021 by Yannick JaquierTable of contents Preamble Oracle test case creation GoldenGate extract configuration GoldenGate for Big Data and Kafka Handler configuration GoldenGate for Big Data and Kafka Connect Handler configuration References Continue reading