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
SQL Server on Linux – Log Shipping – part 4 Posted on January 1, 2023, updated on March 24, 2023 by Yannick JaquierTable of contents Preamble Samba installation and configuration On primary server On secondary server Log shipping configuration On primary server On secondary server Start the log shipping configuration Log shipping failover testing Log shipping monitoring References Continue reading
SQL Server on Linux – Availability Groups – part 3 Posted on December 1, 2022, updated on March 24, 2023 by Yannick JaquierTable of contents Preamble Cluster nodes preparation Availability Group for High Availability (CLUSTER_TYPE = EXTERNAL) Availability Group creation for SQL Server Availability Group creation for Pacemaker Linux Availability Group for Read Scale (CLUSTER_TYPE = NONE) Availability Group creation for SQL Server Manual failover without data loss References Continue reading
SQL Server on Linux – Failover Cluster Instances – part 2 Posted on November 1, 2022, updated on March 24, 2023 by Yannick JaquierTable of contents Preamble Pacemaker, SQL Server and Linux installation Failover Cluster Instances Pacemaker configuration SQL Server failover testing Conclusion References Continue reading
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
Audit creation and deletion of users for SOX evidences Posted on February 17, 2017, updated on February 21, 2022 by Yannick JaquierTable 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