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 […]
SQL SERVER ON LINUX INSTALLATION – PART3 – Install SQL Server on Ubuntu
Read more
In last two parts of this series, I discussed how to create a virtual machine using Windows Hyper-V and how to install Ubuntu Server on the created virtual machine. In this post, we shall be installing SQL Server on the Ubuntu Server, but before we start installing the SQL server, I would like to share […]
SQL Server on Linux Installation – Part2 – Install Ubuntu Server
Read more
In the first part of this series, we learned how to a create virtual machine using Windows Hyper-V. Now, we are going to perform a step-by-step basic installation of the Ubuntu Server on the created virtual machine. Once you complete the Ubuntu Server installation, we will perform SQL Server installation in third part of 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 […]
Download the Sample Database Backup File on the Linux machine
Read more
A release of SQL Server 2016 was not only loaded with rich features & enhancements, but it also brought a new sample database known as Wide World Importers (WWI). Here is the official announcement link. As Microsoft has decided to end the era for the SQL Server sample database AdventureWorks, it’s time for us to […]