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

4,934 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,705 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

616 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

881 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

231 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

13,190 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,208 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

2,615 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

970 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

914 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

T-SQL Tuesday #174 – My Favorite Interview Question

T-SQL Tuesday #174: Job Interview Questions

Power BI: Refreshable Excel Files in PBI Service

Forums

SSIS Connecting to Azure SQL Managed Instance w/ MFA

Summarizing Raw Sales Data with Group Summaries and Final Summary

Subscription to Oracle DB not working after upgrading subscriber to Oracle 19c

Question of the Day

The Query Traceflag