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 […]
Mapping SQL Trace to Extended Events
Read more
Since I started actively participating in SQL community, I found it is very common that people will approach to seek help on their SQL related issues. I do love to help people because it is always a win and win situation for both of us. Recently, I had a phone conversation with one of the […]
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 […]
Introduction to Extended Events
Read more
Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in SQL Server 2008, and it provides a very rich method of collecting diagnostic data from SQL Server. You can get in-depth detailed information using extend event for troubleshooting which was never possible with SQL Trace. […]
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 Server on Linux Installation On RHEL Server – PART1
Read more
In the previous posts, we learned how to install SQL Server on Ubuntu Server & install SQL Server on CentOS. Today, we’ll walk through how to install SQL Server on RHEL Server. At the end of this blog, you will be familiar with the installation of SQL Server on RHEL system. Let’s hop over to my previous blog “how […]
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 […]