In my recent blog, I discussed about how to move master database to another location. One of the readers requested to blog about renaming the master database files. So, we are going to explore step by step process of renaming the files in this blog. Change the name of master database files Connect to SQL Server […]
How to Move Master Database to Another Location – SQL Server On Linux
Read more
With the release of SQL Server 2017 CU4, you can use the mssql-conf utility to move the master database file to another location. By default, master database is located at the location /var/opt/mssql/data. Now, if you want to change the location of master database file to a different location, you can follow the below steps to do […]
Reset SA password on SQL Server on Linux
Read more
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, […]
How to Get Estimated Completion Time of SQL Server Database Backup OR Restore
Read more
“How much time SQL Server is going to take to complete the database Backup or Restore” – This is one of the very common questions DBAs face in day to day life when they are performing database refresh activity, database migration activity, or any adhoc activity where DBA may want to have a DB backup […]
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 […]
SQL Operation Studio Tool
Read more
Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!! SQL Operation studio is a lightweight open source multi-os and multi-RDBMS tool. It provides a modern & intuitive database management experience on their platform of choice to DBAs, Developers, and Sysadmins. It also simplifies configuration, management and monitoring and troubleshooting for SQL […]
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 […]
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 […]