A curious mind knows no limits. I was exploring the public preview of SQL Server on Linux to figure out what all the packages get installed during a complete installation (SQL Server, SQL Server Tools, and ODBC) of SQL Server on Linux. I ended up with a couple of interesting findings and thought to write […]
SQL Server on Linux Installation – Part2 – Install SQL Server Tools on CentOs
Read more
You may be already aware that installing SQL Server on Linux does not install SQL Server tools by default. You have to install it separately. In the first part of this series, we saw the installation of SQL Server on CentOs. Now, we will install SQL Server Tools on CentOs. Install SQL Server Tools on CentOs […]
SQL Server ON Linux Installation – Part1 – Install SQL Server on CentOS
Read more
In the previous post, we learned how to install SQL Server on Ubuntu Server. Today, we will learn how to install SQL Server on CentOS. The CentOS is a community driven free operating system. I would like to highlight that Microsoft does not officially support SQL Server on CentOS. But, installing SQL Server on CentOs […]
SQL Server Configuration Manager on Linux
Read more
The mssql-conf is a configuration tool that installs with SQL Server vNext for both Red Hat Enterprise Linux and Ubuntu systems. You can think of this tool as a replacement for SQL Server Configuration Manager which exists on Windows. It allows you to initialize multiple configuration options for the SQL engine. This tool creates a configuration […]
Enable or Disable SQL Server Service on Linux
Read more
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 […]