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

444 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

989 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,286 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

533 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

376 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,845 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,069 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,719 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

12,497 reads

Blogs

Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone

I’ve had a Dropbox account for years. Like a lot of people, I started...

KDA: Echoes of Deception - Case 4

Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...

EightKB 2026 – Schedule and Registration

By Andrew Pruski

Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...

Read the latest Blogs

Forums

identity increments by 10,000 when it was supposed to be 1

hi a peer of mine who ive never known to be wrong says a...

Displaying Money

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Displaying Money

The Slow Growing Problems

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Slow Growing Problems

Visit the forum

Question of the Day

Displaying Money

I want to get the currency sign displayed with my amount stored in a money type. Does this work?

DECLARE @Amount MONEY;
SET @Amount = '?1500';

SELECT CAST( @Amount  AS VARCHAR(30)) AS Euros

See possible answers