In this post, we are configuring automatic backups on a SQL Server 2017 instance on Linux.
We will use a script launched from Crontab. As simple as that. Continue reading “Automatic Backup in SQL Server 2017 Express Edition in Linux”
SQL Server Database size
How can I know the size of my SQL Server databases?
In a SQL Server instance we might have several databases and each one of them have at least one file for data and another one for the transaction log, so we need to sum up data and log to know the size of each database. Continue reading “SQL Server Database size”
SQL Server database restore with sqlcmd
Since SQL Server 2005 version, there is an excellent tool to manage SQL Server instances, that tool is “SQL Server Management Studio” (SSMS)
It is the regular tool to deal with SQL Server instances, but it is not the only way to do it. Continue reading “SQL Server database restore with sqlcmd”
Database size of a PostgreSQL server instance
How to obtain the database size of a PostgreSQL Server instance? Continue reading “Database size of a PostgreSQL server instance”
SQL Server Error: 15023
When we are restoring a database in a different SQL Server instance, it could happen that there is a Login with the same name of an existing user in the database. Continue reading “SQL Server Error: 15023”
MySQL database table creation
Do you need to create a table in MySQL? We show you how to do it with a small example. Continue reading “MySQL database table creation”