Change the TCP Port on SQL Server on Linux

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

Read more
Read SQL Server Error Log on Linux System

Since I started blogging on SQL Server on Linux, I was asked a couple of questions on it. One of the most common questions was on SQL Server Error log. Therefore, I decided to write this blog. It may help you to explore all possible way to read the SQL Server Error Log file on a […]

Read more
Create a Shared SQL Server Backups Folder on Linux

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

Read more
Connect SQL Server Linux Instance using SSMS

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

Read more
Stop, Start or View SQL Server Service Status on Linux

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

Read more
Configure Networking for Hyper-V Virtual Machines

In this tutorial, I am going to discuss “External Network” connectivity. The External Network allows you to access the internet on your virtual machine. When you setup the external network, the virtual switch is connected to a physical network adapter (Ethernet or Wi-Fi) which provides connectivity between the physical network, the Hyper-V host, and the virtual machine. Setting […]

Read more