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,158 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

431 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

949 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,271 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

524 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

362 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,523 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,063 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,358 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

11,309 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...

A New Word: Foilsick

foilsick – adj. feeling ashamed after revealing a little too much of yourself to...

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