Dharmendra Keshari

Dharmendra is a SQL Server/Microsoft Data Platform professional with over eight years of experience. He enjoys helping others in the SQL Server community and does this by contributing on blogs, speaking at several SQL events. His passion and focus is to explore and share more and more on SQL Server.

Introduction to Extended Events

by Dharmendra Keshari

SQL Geek

Since I started playing with Extended Events, it has been my favorite toy for performance troubleshooting. It was introduced in...

2017-11-29

760 reads

SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL

by Dharmendra Keshari

SQL Geek

In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...

2017-11-25

591 reads

SQL SERVER ON LINUX INSTALLATION – PART3 – INSTALL SQL SERVER COMMAND-LINE TOOLS ON RHEL

by Dharmendra Keshari

SQL Geek

As installing SQL Server on Linux doesn’t install SQL Server command-line tools by default. So, you have to install it...

2017-11-23

746 reads

Finding Input Parameters in an Execution Plan

by Dharmendra Keshari

SQL Geek

The query execution plan is a map of work which SQL Server is going to perform to execute a query....

2017-11-22 (first published: 2017-11-11)

7,013 reads

SQL SERVER ON LINUX INSTALLATION – PART2 – INSTALL SQL SERVER ON RHEL

by Dharmendra Keshari

SQL Geek

In the previous blog, we discussed how to install RHEL Server on the virtual machine. In this quick tutorial, we...

2017-11-22

815 reads

SQL Server on Linux Installation On RHEL Server – PART1

by Dharmendra Keshari

SQL Geek

In the previous posts, we learned how toinstall SQL Server on Ubuntu Server&install SQL Server on CentOS. Today, we’ll walk...

2017-11-21

1,043 reads

Figuring out Time-Out Prone queries

by Dharmendra Keshari

SQL Geek

Recently, I was helping one of the community attendees on the SQL Server Query Time-Out issue. Once we are done...

2017-11-20 (first published: 2017-11-09)

671 reads

SQL Operation Studio Tool

by Dharmendra Keshari

SQL Geek

Microsoft finally has launched most awaited tool – SQL Operation Studio (aka OpsStudio)!!!
SQL Operation studio is a lightweight open source...

2017-11-20

1,553 reads

Getting Query Execution Statistics

by Dharmendra Keshari

SQL Geek

If you hate things that are slow, I bet you certainly want to know the reason for the slowness. So,...

2017-11-17 (first published: 2017-11-06)

6,002 reads

Over-Indexing can hurt your SQL Server performance

by Dharmendra Keshari

SQL Geek

Indexes are a vast subject and well documented elsewhere on the web. But, it is still a very commonly asked...

2017-11-15 (first published: 2017-11-05)

5,216 reads

Blogs

Advice I Like: Pyramid Schemes

If someone is trying to convince you it’s not a pyramid scheme, it’s a...

Using Prompt AI for a Travel Data Analysis

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By Ige Adetokunbo Temitayo

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

Read the latest Blogs

Forums

Database file shrink issue.

Hi experts, I have a 3+ TB database on a 2019 sql server which...

The North Star for the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The North Star for the...

Multiple Escape Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Escape Characters

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation):

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';

What is returned?

See possible answers