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 September 29, 2022 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
SQL Server Docker container with Microsoft SQL Server for Linux images Posted on November 21, 2016, updated on July 1, 2020 by Yannick JaquierTable of contents Preamble Docker installation SQL Server Docker container creation References Continue reading