How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023, updated on May 10, 2023 by Yannick JaquierTable of contents Preamble Preparation of the test environment The old legacy technique The alter table switch technique The view technique The synonym technique The schema transfer technique Conclusion References Continue reading
Polymorphic Table Functions (PTF) hands-on Posted on April 20, 2023, updated on April 20, 2023 by Yannick JaquierTable of contents Preamble Polymorphic Table Functions (PTF) basic example Polymorphic Table Functions (PTF) manipulating output Polymorphic Table Functions (PTF) debugging References Continue reading
Table and scalar SQL macros hands-on Posted on March 3, 2023, updated on March 20, 2023 by Yannick JaquierTable of contents Preamble Table SQL Macros Scalar SQL Macros Conclusion References Continue reading
Immutable tables and blockchain tables hands-on Posted on March 28, 2022, updated on February 20, 2023 by Yannick JaquierTable of contents Preamble Immutable tables Blockchain tables Basic testing Signing rows 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
Gradual Database Password Rollover hands-on Posted on December 28, 2021, updated on December 14, 2021 by Yannick JaquierTable of contents Preamble Gradual Database Password Rollover testing Continue reading