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 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
SqlBak on Linux Reference Manual
The SqlBak application connects your computer to sqlbak.com and allows you to manage database backups from the web. In this post, you will see what commands and parameters it supports on Linux.
Starting with SqlBak on Linux
SqlBak application connects your Linux servers to sqlbak.com allowing you to manage MySQL, PostgreSQL and MS SQL Server database backups from the web. It should successfully work on different Linux distributions such as Ubuntu, Debian, Fedora, CentOS, and RHEL, but if you face any difficulty in using the app on your GNU/Linux distribution let us know. Continue reading Starting with SqlBak on Linux
How to backup large databases. Recommendation.
If you have to backup large SQL Server database with the help of SqlBak, here you will find some recommendations that can speed up the backup process. Continue reading How to backup large databases. Recommendation.
How to backup and restore Microsoft Azure Cloud SQL Database
Microsoft Azure SQL Database is a managed cloud database from Microsoft. It runs on a cloud computing platform, and access to it is provided as a service. If you use SqlBak for managing your database backups and want to backup Microsoft Azure SQL Database as well, here you will find a step-by-step guide on how to do it. Continue reading How to backup and restore Microsoft Azure Cloud SQL Database
Why SqlBak is better than Microsoft SQL Server Backup to Microsoft Azure Tool?
If you use Azure Storage to keep your SQLServer backups then you are probably already aware of “Microsoft SQL Server Backup to Microsoft Azure Tool” that allows you to send your backups there. In this post, we will show how it works and why SqlBak does the same thing in a more convenient way.
Continue reading Why SqlBak is better than Microsoft SQL Server Backup to Microsoft Azure Tool?
