Capturing Current Workload of SQL Server – Part2

In the first part of the capturing current workload of SQL Server blog, I talked about first two steps. Where we created the table “CurrentlyRunningQueries_Snapshot_History” in the first step and wrote the script to capture workload for a live system in the second step. Now, we are going to create and schedule a job which […]

Read more
An in-depth look at mssql-server.service file on SQL Server on Linux

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 […]

Read more
top or htop to check the health of SQL Server on Linux

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” […]

Read more
SQL Debian package details On Ubuntu System

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 […]

Read more
SQL Server Configuration Manager on Linux

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 […]

Read more
Enable or Disable SQL Server Service on Linux

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 […]

Read more
Modify the collation of SQL Server Instance on Linux

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 […]

Read more
Validate the configuration of SQL Server on Linux

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 […]

Read more