Pythian Blog: Technical Track

Recent stories

Important pre-checks before running pt-online-schema-change to Add/Drop an index in MySQL

Important pre-checks before running pt-online-schema-change to Add/Drop an index in MySQL


When you're working with large MySQL tables in production, making schema changes like adding or dropping indexes can be ...

6 min read
Improving Backup efficiency on SQL Server 2025 with the new ZSTD algorithm

Improving Backup efficiency on SQL Server 2025 with the new ZSTD algorithm


Native backup compression was introduced in SQL Server 2008 and was a game changer as it reduced the data space ...

6 min read
Next-Gen Data Intelligence: How SQL Server 2025 Redefines the Modern Database

Next-Gen Data Intelligence: How SQL Server 2025 Redefines the Modern Database


SQL Server 2025 is not just another upgrade—it’s a dramatic reimagining of the database for the AI era.

6 min read

More stories