Sqlglot as a backup for your database migration Posted on April 20, 2026 , Modified on March 27, 2026 , by Yannick JaquierTable of contents Preamble Sqlglot installation Sqlglot testing References Read more MariaDB, MySQL, Oracle, PostgreSQL, Python, SQL Server Development Leave a comment
SQL Server compression methods testing and comparison Posted on April 10, 2025 , Modified on October 28, 2025 , by Yannick JaquierTable of contents Preamble SQL Server compression test case SQL Server compression testing sp_estimate_data_compression_savings Row compression Page compression COMPRESS/DECOMPRESS compression Columnstore compression Columnstore archive compression SQL Server compression wrap up References Read more SQL Server Tuning 2 comments
Resource Governor implementation to control workload Posted on July 10, 2024 , Modified on July 9, 2024 , by Yannick JaquierTable of contents Preamble Resource Governor pre-requisites Resource Governor configuration Resource Governor testing Resource Governor to go further References Read more SQL Server Resource Governor 2 comments
In-Memory OLTP for rapid data ingestion Posted on April 20, 2024 , Modified on April 22, 2024 , by Yannick JaquierTable of contents Preamble In-Memory OLTP preparation In-Memory OLTP testing In-Memory OLTP to durable tables INSERT INTO disk_based_table SELECT FROM memory_optimized_table Temporal memory-optimized table Issues encountered References Read more SQL Server SQL, Tuning Leave a comment
How to online refresh BI tables with minimum impact to end users Posted on May 10, 2023 , Modified on October 13, 2026 , 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 Read more MariaDB, MySQL, Oracle, PostgreSQL, SQL Server Development, SQL Leave a comment
SQL Server on Linux – Log Shipping – part 4 Posted on January 1, 2023 , Modified 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 Read more SQL Server High Availability Leave a comment