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

682 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

584 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

738 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)

6,470 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

808 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,036 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)

657 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,536 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)

5,697 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,072 reads

Blogs

How to find free space in Azure PosgreSQL

By hellosqlkitty

I wanted to figure out how big (or approximately how big) my dump file...

T-SQL Tuesday #180: Good enough is perfect Roundup

By hellosqlkitty

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Read the latest Blogs

Forums

Compare rows within the same table

I have a table. Structure in script below. I have to compare and see...

Microsoft Recommendations for Update Stats?

By Brandie Tarvin

I have an application team that is insisting on daily (and for some, weekly)...

how can i tell if our db2 driver is ms or ibm or other?

i see this in the definition of a linked server on our wh sql...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers