Reset SA password on SQL Server on Linux

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

Read more
Introduction to Extended Events

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

Read more
SQL Server on Linux Installation On RHEL Server – PART1

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

Read more
SQL Operation Studio Tool

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

Read more
Finding Input Parameters in an Execution Plan

The query execution plan is a map of work which SQL Server is going to perform to execute a query. It provides a lot of useful information like operators, cost, estimated rows, actual rows, predicate details, parallelism, and much more information to troubleshoot the performance issue. During the troubleshooting of the performance issues, I would […]

Read more
Figuring out Time-Out Prone queries

Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done with troubleshooting, he asked a very excellent question; “I am dealing with very critical OLTP systems. As my company has been expanding the business, the data is rapidly growing. It is causing a lot of […]

Read more