August 28, 2017
The R&D team decided to delete an old non-relevant data of customers in order to decrease database size. The marketing department send this data in CSV format only therefore we need to load these accounts into MySQL temporary table for the future...
May 1, 2017
Pavel Zeger is an open - source data platform consultant at NAYA-Tech.
MySQL server upgrade with minimum downtime
(as a part of migration from Ubuntu to CentOS)
We suggested to one of our client to migrate Linux servers from Ubuntu to CentOS and upgrade MySQL instances to...
Snowflake - Getting Started Guide
March 20, 2020
Restoring SQL Server System Databases
May 8, 2019
Amazon EMR Cluster to Athena Partitioned Data - Qu...
August 2, 2018
MongoDB Backup Data Directory
May 3, 2018
Moving Always On DBs without Restarting SQL
March 14, 2018
MariaDB Galera Cluster Installation
March 8, 2018
Create Logins On Log Shipping Databases
January 21, 2018
A first timer PASS summit 2017 journey
November 11, 2017
A rich man's problem…
October 31, 2017
Changing INT to BigInt
October 29, 2017
SQL Server (43)
Galera Cluster (1)