In my previous blog, we walked through how to Stop, Start or View SQL Server Service Status on Linux. If you find SQL Server service is disabled or you want to disable or enable it, how would you do it on Linux system? It may sound very basic step, but if you don’t know the […]
Modify the collation of SQL Server Instance on Linux
Read more
Changing the default collation of SQL Server Instance on Windows can be a complicated, time-consuming and painful task. But, SQL Server on Linux provides very interactive and handy option to modify the collation of SQL Server instance. All you need to follow just a few steps to change the collection of SQL Server Instance rest everything will […]
Validate the configuration of SQL Server on Linux
Read more
The mssql-conf tool validates multiple configuration options for SQL Server on Linux. When you run the mssql-conf utility with validate parameter, the tool creates a configuration file to store the configuration changes that user has specified. These configurations are stored in a config file by name mssql.conf at the location /var/opt/mssql. By default, this tool does […]
Enable or Disable Trace Flags Globally on SQL Server on Linux
Read more
You can enable or disable trace flag at the session level for analyzing something, or at the server level for all connections. In this blog, we shall see how to enable or disable trace flags in SQL Server on Linux for the startup of the SQL Server service so that it can be used globally. Enable […]
Change the default backup folder location on SQL Server on Linux
Read more
Use the mssql-conf utility to change the default location where the backup files are generated. In SQL Server on Linux, the default location where backup files are created is ‘/var/opt/mssql/data’. Let’s connect to SQL Server Linux Instance using SSMS and go to the instance property, select ‘Database Settings’ tab, and get the database backup default location. Change the default backup […]
Change the Default Data or Log Directory Location on SQL Server on Linux
Read more
When you install SQL Server on Linux, the default instance file location is setup to ‘C:\var\opt\mssql\data\’ for data and log file. Sometimes, it is necessary to relocate the physical files to different drives to get better throughput. In this post, we shall walkthrough a step by step process of changing the default location of data […]
Change the TCP Port on SQL Server on Linux
Read more
When you install SQL Server on Linux, the default instance is setup to listen on port 1433. Most of the companies don’t follow the default port because of vulnerability issue. In this case, you may consider using any other ports instead of the default port 1433. In this article, I will discuss how to change the […]
Read SQL Server Error Log on Linux System
Read more
Since I started blogging on SQL Server on Linux, I was asked a couple of questions on it. One of the most common questions was on SQL Server Error log. Therefore, I decided to write this blog. It may help you to explore all possible way to read the SQL Server Error Log file on a […]
Create a Shared SQL Server Backups Folder on Linux
Read more
To Transfer files from Windows to Linux (Ubuntu) or vice versa, you can use Samba to create a shared folder on the Linux system. This allows the files to be shared on the network through the SMB protocol. This will also allow Windows hosts to get access remote to the files using file explorer. We […]
Restore SQL Server Database Backup on SQL Linux Instance
Read more
It may be a very easy task for SQL DBAs to restore a database backup on a SQL Instance which is running on Windows server. With the launch of SQL Server on Linux, It may not be as easy as it is with Windows, If you don’t have knowledge of Linux operating system. In this […]