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

749 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

588 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

743 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,980 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

812 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,039 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)

666 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,547 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,952 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,202 reads

Blogs

The fundamental requirements of a reporting system

By ChrisJenkins

There are some fundamental boxes that your reporting system must tick. ✅ The figures...

Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management

When it comes to managing complex database environments, having the right monitoring solution is...

Check Power BI report interactions with Semantic Link Labs

By Meagan Longoria

It can be tedious to check what visual interactions have been configured in a...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

The Last Good DBCC Run

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Last Good DBCC Run

count the number of NULLs in a row

Hi everyone I have a SP that finds the average based on 3 tables. ...

Visit the forum

Question of the Day

The Last Good DBCC Run

I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?

See possible answers