Install SQL Server 2017 on CentOS 7 / Red Hat Enterprise Linux 7, configure its repository and instance, and connect with SQLCMD.
Por fin podemos instalar SQL Server 2017 en servidores Linux. En esta entrada vemos cómo instalarlo en CentOS 7 / RHEL 7, desde el repositorio hasta la conexión con SQLCMD.
We previously covered installing SQL Server on Ubuntu 16.04; here we will install SQL Server on CentOS 7 / RHEL 7. Continue reading “Install SQL Server 2017 on CentOS 7 / RHEL 7”
At last, we can install one of the best databases on our Linux servers: SQL Server 2017 supports Linux!
In this article, we will go through the step-by-step installation of SQL Server 2017 on Ubuntu 16.04. Continue reading “Install SQL Server 2017 on Ubuntu 16.04”
In this short post, we are going to learn how to list all columns of every table in a SQL Server database.
We want to get the schema, the name of the table, the name of the column and the data type. Continue reading “Listing all columns from a SQL Server database”
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”
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”
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”
