The tempdb’s use as a temporary area space to create and delete temporary objects. The heavy usage of tempdb can lead to latch contention on the pages required to allocate or deallocate. In this blog, we’ll be covering what is tempdb contention and how quickly you can check the tempdb contention issue on your server. What […]
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 […]
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 […]
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 […]
SQL Server on Linux Installation – Part1 – Create Virtual Machine
Read more
The series of this blog provide you a complete walkthrough of SQL Server on Linux installation processes. It includes the creation of Hyper-V virtual machine, Installation of Ubuntu Server, Installation of SQL Server and SQL Server Tools on the Linux machine. The first part of the “SQL Server on Linux Installation” blog will talk about […]
The Secret of the Database Boot Page#9 – Part1
Read more
Recently, I presented on SQL Server database “Boot Page” at Singapore SQL Pass Chapter user group. It was a great knowledge sharing experience, and It motivated me to share the knowledge to a wider audience. So, I will be blogging all the part of the demos with all possible details so that you enjoy the […]