In previous blogs, we discuss how to Stop, Start, View, and Enable or Disable SQL Server Service on Linux. Here, we will be discussing mssql-server.service file and will also be talking about dumping the ELF binary file “/opt/mssql/bin/sqlservr” to see – it calls what all the sfp files. The mssql-server.service is a configuration file. It […]
top or htop to check the health of SQL Server on Linux
Read more
Being a Windows user, your first place to check the health of SQL Server is Windows task manager. Since Microsoft has launched SQL Server on Linux operating system, you might be wondering how to check the health of SQL Server on Linux machine now. You can use classical Linux task manager by running the “top” […]
SQL Debian package details On Ubuntu System
Read more
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 […]