Jupyter Notebook is a great tool for data analysis. And one of its greatest features is that you can easily combine runnable code with rich-text annotations. Markdown cells that contain such annotations support both HTML and Markdown syntax. Continue reading Jupyter Notebook Markdown Cheatsheet
How to Enable Binary Log in Linux
Below is the short tutorial on how to enable binary log in Linux. Continue reading How to Enable Binary Log in Linux
Prod and Dev: Sync two MySQL databases – easy!
No matter what IT project you create, you always need a sandbox to conduct testing and development. If your product has a MySQL database, then you will need to create a database in development environment. Continue reading Prod and Dev: Sync two MySQL databases – easy!
MySQL Backup Strategy
How to Copy SQL Server Database from Windows to Linux
After Microsoft has launched SQL Server for Linux, even if your main tech stack is tied to Windows Server you may need to copy the database to another SQL Server located on a Linux computer.
For example, this can come in handy if you want to provide developers with a database for testing without buying a Windows Server license.
There are a few ways to tackle this task. This article examines the following methods to copy SQL Server database from Windows to Linux:
- Using T-SQL’s BACKUP DATABASE and RESTORE DATABASE commands;
- Generation of T-SQL database script (such as mysqldump);
- Creating BACPAC;
- SqlBak service.
Continue reading How to Copy SQL Server Database from Windows to Linux
How to automate MySQL databases backups to S3
If you have a database, then you need to back it up regularly, and preferably not manually. To perform regular backups is only half the battle, you also have to consider where to store them. Saving the backups on the same server where MySQL Server is installed isn’t safe, because if it crashes, you will lose everything. Continue reading How to automate MySQL databases backups to S3
How to get app keys for OneDrive For Business
Below is a short step-by-step tutorial on how to get private keys for OneDrive for Business. Continue reading How to get app keys for OneDrive For Business
How to Automate PostgreSQL Database Backups in Linux
A question of regular backup sooner or later comes up for any DBMS. PostgreSQL is no exception. As a rule, the pg_dump utility, which is part of the PostgreSQL client, is used to create a hot backup.
Continue reading How to Automate PostgreSQL Database Backups in Linux
How to Automate MySQL Database Backups in Linux
Automated backup of MySQL databases can be a serious task. The proper way to automate backups involves the following steps:
- Create a database backup
- Zip the backup
- Encrypt the compressed file
- Send the backup to storage over the Internet, FTP, Dropbox, AWS, Google Drive, etc.
- Receive email notifications concerning backup results
- Create a backup schedule
- Delete old backups
Continue reading How to Automate MySQL Database Backups in Linux
How to Update SqlBak on Linux
Basically, to update SqlBak on Linux you need to update the package lists and reinstall or restart the SqlBak application. Below are some examples of how to do it on popular Linux distributions. Continue reading How to Update SqlBak on Linux
