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 […]
Create a Shared SQL Server Backups Folder on Linux
Read more
To Transfer files from Windows to Linux (Ubuntu) or vice versa, you can use Samba to create a shared folder on the Linux system. This allows the files to be shared on the network through the SMB protocol. This will also allow Windows hosts to get access remote to the files using file explorer. We […]
Restore SQL Server Database Backup on SQL Linux Instance
Read more
It may be a very easy task for SQL DBAs to restore a database backup on a SQL Instance which is running on Windows server. With the launch of SQL Server on Linux, It may not be as easy as it is with Windows, If you don’t have knowledge of Linux operating system. In this […]
Connect SQL Server Linux Instance using SSMS
Read more
I discussed in one of my previous articles how you could connect SQL Server on Linux using command utilities tool. A lot of SQL DBAs are not very comfortable with the command line utility tool. They want to connect SQL Linux Instance using SQL Server Management Studio because it gives them better flexibility. In this blog, we will see how you […]
Stop, Start or View SQL Server Service Status on Linux
Read more
SQL Server runs on Linux as a service that is started as a default after installation. In case, you want to stop, start, or view the status of the SQL Server service; you can follow the below command to check the status of SQL Server. Use the following command to VIEW the status of the SQL […]
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu
Read more
This blog has been updated. Kindly follow the link Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In my previous posts of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install Ubuntu Server on the created virtual […]