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

SQL Server 2017 sys.dm_os_enumerate_fixed_drives

by Dharmendra Keshari

SQL Geek

In SQL Server 2017, you can use the new DMV sys.dm_os_enumerate_fixed_drives to identify free disk space. The DMV is replacement...

2017-05-15

1,194 reads

Setting Up a Subscription

by Dharmendra Keshari

SQL Geek

In the last two blogs, we went through Configure Distribution Database and Publication Creation. If you haven’t read them, I...

2017-05-10

2,441 reads

Setting Up a Publication for Transaction Replication

by Dharmendra Keshari

SQL Geek

In the previous blog, we discussed how to Configure Distribution Database. Once you setup your Distribution database successfully, you can...

2017-05-09

1,997 reads

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

942 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

429 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

713 reads