This article is about how to proceed when you forgot the password of your SQL Server “sa” account, Password was entered wrong many times then “sa” account got locked, or someone wants to reset the password without using SQL Server management studio (GUI). The mssql-conf is a configuration tool that installs with SQL Server on Linux (Red Hat Enterprise Linux, […]
SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL
Read more
In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise Linux, and Install SQL Server Command-Line Tools on RHEL. In this tip, I will explain how to install SQL Server Agent on a Linux server, so we can create SQL Server jobs to schedule repetitive work. […]
SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL
Read more
As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it separately. In my previous tips of this series, I discussed how to create a virtual machine using Windows Hyper-V, how to install RHEL on the created virtual machine, and how to install SQL Server on the RHEL […]
SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL
Read more
In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we will install SQL Server 2017 on Red Hat Enterprise Linux (RHEL). Connect to the RHEL virtual machine and log on to the server by keying username and password Switch to root user (superuser) su root […]
Connect SQL Server on Linux using Bash on Ubuntu on Windows
Read more
Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You can now add Bash shell on Windows 10 to play with SQL Server on Linux instead of using any third party tool like Putty or other SSH clients. Note: Bash/WSL is still in “beta” version. It […]
SQL Server 2017 – DMV – sys.dm_os_host_info
Read more
I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on Linux, and at a point, I had to check the operating system details of the Linux system. Being lazy to figure out Linux OS command to check the operating system details, I started figuring out […]
Install SQL Server Agent on Ubuntu (Linux)
Read more
With the release of SQL Server vNext CTP 1.4, the SQL Server Agent support is included. It enables DBAs to schedule any task using a SQL Server Agent Job on Linux machine. In this post, I will explain how to install the SQL Server Agent package on the Ubuntu system. Before you start installation SQL […]
SQL SERVER ON LINUX INSTALLATION – PART4 – Install SQL Server Tools on Ubuntu – Updated!
Read more
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 machine and how to install SQL Server on the […]
Uninstall SQL Server Tools on Ubuntu System
Read more
If you remember, Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it separately. The same way when you uninstall SQL Server, it won’t uninstall mssql-tools, you have to uninstall separately. In the previous blog post, we discuss how to uninstall mssql-server on Ubuntu System. Here, we […]
Uninstall SQL Server on Ubuntu System
Read more
There are scenarios where you want to uninstall the SQL Server vNext CTP1. This blog describes how to uninstall Microsoft SQL Server on Ubuntu system. It will completely remove Microsoft SQL Server along with repository, data directories, and binary of the SQL Engine. Note: During uninstall mssql-server package, it does not remove all the files […]