This blog provides a walkthrough of SQL Server Package Installation requirement for Ubuntu, RHEL & Docker. When you are going to install SQL Server vNext CTP1, you make sure that you are meeting the package installation requirement as per Operating System. Requirements for package installation on Ubuntu Ubuntu 16.04 Minimum of 3.25 GB of RAM […]
An in-depth look at mssql-server.service file on SQL Server on Linux
Read more
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 […]
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 […]
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 […]