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.

All authors

Adding File to Database in AlwaysOn Availability Group

by Dharmendra Keshari

SQL Geek

When a database is part of AlwaysOn Availability Group, it means whatever commands we are executing on Primary replica database,...

2018-07-27

5,988 reads

AlwaysOn_health Extended Event Session

by Dharmendra Keshari

SQL Geek

The AlwaysOn_health XEvent session is installed by SQL Server by default, and started by the Create Availability Group wizard when...

2018-07-25

2,983 reads

AlwaysOn Dashboard uses System Policies

by Dharmendra Keshari

SQL Geek

The AlwaysOn Dashboard is an excellent tool in SQL Server Management Studio that allows you to monitor Replica status, Availability...

2018-07-24

659 reads

Why Availability Databases Are Not Synchronizing?

by Dharmendra Keshari

SQL Geek

If you are working on SQL Server Availability Group Databases, you may have seen that Availability Group is online but at-least...

2018-07-23

926 reads

Another MVP Award – 2018-2019

by Dharmendra Keshari

SQL Geek

Gladly sharing that I got the news of my MVP award on 1st July. I am happy, honored, and humbled...

2018-07-16

235 reads

Enable SQLCMD Mode in SQL Server Management Studio

by Dharmendra Keshari

SQL Geek

SQLCMD mode in SSMS allows you to use the command line tool within SSMS. Using this feature of the SSMS,...

2018-06-07

15,789 reads

SQL Server Stress Testing Using OStress – RML Utilities

by Dharmendra Keshari

SQL Geek

As a DBA, implementing a new database consists of a variety of aspects like correct table structure, tuning the stored...

2018-05-28 (first published: 2018-05-21)

7,238 reads

Find Query with Implicit Conversion in the Plan Cache

by Dharmendra Keshari

SQL Geek

In my previous blog, I discussed about “Which are the queries using a particular index or table?“. Today’s post, I am...

2018-05-13

3,026 reads

Which are the queries using a particular index or table?

by Dharmendra Keshari

SQL Geek

The DMV sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats give you excellent detailed information about how the indexes are being used and what operations...

2018-05-07

1,058 reads

Determine Referenced Objects in the Stored Procedures

by Dharmendra Keshari

SQL Geek

It is very common to see in a relational database that stored procedures are using many Tables, Views, Sequence Object,...

2018-05-01

1,639 reads

All authors

Dharmendra Keshari

Adding File to Database in AlwaysOn Availability Group

AlwaysOn_health Extended Event Session

AlwaysOn Dashboard uses System Policies

Why Availability Databases Are Not Synchronizing?

Another MVP Award – 2018-2019

Enable SQLCMD Mode in SQL Server Management Studio

SQL Server Stress Testing Using OStress – RML Utilities

Find Query with Implicit Conversion in the Plan Cache

Which are the queries using a particular index or table?

Determine Referenced Objects in the Stored Procedures

Blogs

The Benefits of Teaching

Power BI, Excel, OneLake – Dreams Do Come True!

The Book of Redgate: What Our Staff Says

Forums

Deny Connect problem

Website Stability 2025/12/05

403 Forbidden

Question of the Day

Fabric Mirroring