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
Export/Import SqlBak job in a JSON file
Starting from SqlBak app version 3.2.9, you can export a job to a JSON file and then import it using the SqlBak.Job.Cli.exe utility. This functionality is needed primarily for automated deployment of the SqlBak application and backup jobs creation. A simple tutorial on how to do this is described in the following blog post: How to deploy SqlBak app automatically. Continue reading Export/Import SqlBak job in a JSON file
SqlBak.Job.Cli.exe reference manual
The sqlbak.job.cli.exe utility is a programming interface for working with the SqlBak application. It is located in the root directory where the application is installed.
This tool can be used to register the application, manage connections to DBMS, and import jobs from JSON configurations. Continue reading SqlBak.Job.Cli.exe reference manual
How to deploy SqlBak app automatically
When SqlBak is installed on a large number of servers, the deployment can be automated in 3 steps:
How to backup SQL Server databases to multiple destinations
Storing backups only on a local disk is not a good practice, because you risk losing them if the disk becomes corrupted. It is recommended, therefore, that you send backups to multiple destinations to always be able to restore your databases. In this blog post, we will show how to create regular SQL Server backups and automatically send some of them to a local folder and some to the cloud (Azure Storage, for example) via SqlBak.
Continue reading How to backup SQL Server databases to multiple destinations
How to backup SQL Server databases
This article looks at different ways to back up SQL Server, from classic and conventional to exotic and situational.
But first, a few words of theory. Continue reading How to backup SQL Server databases
Automated SQL Server Backups to Amazon S3 on Windows
Problem
The BACKUP DATABASE command syntax allows performing backups by specifying a drive, a network folder or Azure storage as the destination. Although it is not possible to set an Amazon S3 bucket as a backup save point, you can transfer the file to S3 using a batch script or a third-party utility. Continue reading Automated SQL Server Backups to Amazon S3 on Windows
MySQL Maintenance Automation
For the MySQL database to work quickly and without interruptions, it is necessary to perform maintenance jobs from time to time. This mostly just means running a few commands, but let’s address first things first. Continue reading MySQL Maintenance Automation
PostgreSQL Maintenance Automation
One of the primary responsibilities of the DBA is to create regular backups. However, maintenance of the database is not limited to this.
The mechanisms that enable a relational database to run fast are based on a complex storage system that degrades over time. It leads to a general database slowdown. Continue reading PostgreSQL Maintenance Automation
How to automatically upload MySQL backup to FTP on Linux
The first thing a DBA should do after deploying a database is to ensure that backups are created regularly.
But storing a backup file on the same server where the MySQL server is located would be a big mistake. Therefore, you should create a backup and put it out of the server on which MySQL is located. The simplest solution would be to transfer it to another server via FTP. Continue reading How to automatically upload MySQL backup to FTP on Linux
Automatic backup of Raspberry PI to any cloud
The average lifespan of an SD card on a Raspberry Pi is two years. It is impossible to predict the date of failure of an SD card accurately. However, if you perform a regular backup of data on the card, its potential failure ceases to be an issue.
Continue reading Automatic backup of Raspberry PI to any cloud