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.

SQL Database File Wise Disk Space Monitoring

by Dharmendra Keshari

SQL Geek

As a DBA, you get alerts many times regarding the database file space issue. To address the issue, you may...

2017-04-21

1,203 reads

Microsoft Data Platform – MVP 2017!!!

by Dharmendra Keshari

SQL Geek

I’m very pleased and delighted to share that I have been awarded Microsoft Most Valuable Professional (MVP) award 2017. This...

2017-04-14

451 reads

Read Statistics Histogram using DMV

by Dharmendra Keshari

SQL Geek

DMV: sys.dm_db_stats_histogram (object_id, stats_id)
For a long time, the DBCC SHOW_STATISTICS command was the only way to get information about statistics....

2017-02-22

1,013 reads

Out of memory error because of the very low virtual address space – Error 701 – Trace Flag 8075

by Dharmendra Keshari

SQL Geek

If you are dealing with a SQL Server which got a lot of memory, you may encounter the out of...

2017-02-20

1,299 reads

After migrating SQL Server from 2005 to higher version, the waits type PAGELATCH_UP increased

by Dharmendra Keshari

SQL Geek

Recently, I experienced an interesting issue where I found SQL Server wait type PageLatch_UP went up drastically after migration. Let’s...

2017-02-06

545 reads

SQL Server Service Information

by Dharmendra Keshari

SQL Geek

DMV: sys.dm_server_services
Microsoft SQL Server 2008 R2 SP1 and SQL Server 2012 has a new set of DMVs. One of them...

2017-01-11

391 reads

Disk Space Monitoring using SQL Server DMV

by Dharmendra Keshari

SQL Geek

DMV : sys.dm_os_volume_stats
Being a SQL Server database administrator, you may often receive alerts or asked by Senior DBAs to check, if...

2017-01-09

17,998 reads

New String Function – TRIM – in SQL Server vNext

by Dharmendra Keshari

SQL Geek

As SQL developer, you must have often come across a scenario where you need to remove the empty spaces at...

2017-01-06

2,082 reads

When was SQL Server installed?

by Dharmendra Keshari

SQL Geek

In this blog post. Let us learn about how to retrieve date and time when the SQL Server was installed. To retrieve...

2017-01-04

13,917 reads

Identifying Blocking Chain in SQL Server

by Dharmendra Keshari

SQL Geek

HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...

2017-01-01

13,180 reads

Blogs

T-SQL Tuesday #203: Risk and Reward

This is timely, as I’m currently on a boat in the Adriatic taking a...

dataMinds Connect 2026 – Slides & Scripts

By Koen Verbeeck

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

Read the latest Blogs

Forums

Risk Vs Reward, The never ending ROI discussion.

Comments posted to this topic are about the item Risk Vs Reward, The never...

Hyperscale Replicas IV

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Hyperscale Replicas IV

The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek

By Dhananjay Chaudhari

Comments posted to this topic are about the item The SQL Server Date Magic:...

Visit the forum

Question of the Day

Hyperscale Replicas IV

In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?

See possible answers