Filip Holub15. 2. 20191 minChange default backup directory in SQL Server on LinuxWhen we have the installation of SQL Server on Linux done, location for backup files is here /var/opt/mssql/data, by default. In this...
Filip Holub15. 2. 20192 minChange default folder for data and log in SQL Server on LinuxWhen we have installation of SQL Server on Linux done, location for data and log files is here /var/opt/mssql/data, by default. In this...
Filip Holub3. 2. 20191 minSet the Memory limit for SQL Server on LinuxAfter installation SQL Server on Linux si Memory for SQL Server set on 80% of the total physical memory, by default. This command is...
Filip Holub3. 2. 20191 minChange SQL Server collation on LinuxI will try write a couple of steps how correctly change collation for SQL Server Instance on Linux. The following command set-collation...
Filip Holub1. 2. 20191 minEnable SQL Server Agent on LinuxAfter installation of SQL Server is SQL Server Agent disabled, by default! Today, I will show you simple command for enable SQL Server...
Filip Holub1. 2. 20191 minHow to change the port for SQL Server on Linux?After installation is TCP port for SQL Server set to 1433, by default. Now, I will show you - How to change TCP port for SQL Server on...
Filip Holub30. 1. 20191 minHow to allow port and remotely connect to Management Studio on Ubuntu?Today I will demonstrate how to allow default port 1433 after installation in order to remotely connect to Management Studio. "First of...
Filip Holub30. 1. 20191 minInstall SQL Server Agent on UbuntuToday I will show you, you will see that installation is pretty simple and fast, it cointains only three or four commands. SQL Server...
Filip Holub29. 1. 20191 minEnable or Disable SQL Server on LinuxThere can be a few reasons, why have the SQL Server service disabled on your Linux machine. Today, I will show you, how to disabled or...
Filip Holub29. 1. 20191 minHow to Start, Stop and Restart SQL server on Linux?The following commands are exactly the same in each Linux distribution, such as RHEL, Ubuntu or Suse. They are very simple for keep in...
Filip Holub28. 1. 20192 minHow to install SQL Server 2017 on Ubuntu?In this post, I will demonstrate how to install SQL Server 2017 on Ubuntu. I will describe all the process of installation in detail...