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

436 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

958 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,276 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

365 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,615 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,067 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,470 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,706 reads

Blogs

Flyway Tips: AI Deployment Script Descriptions

With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...

A New Word: Fawtle

fawtle – n. a weird little flaw built into your partner that somehow only...

Post-quantum key exchange – Insurance policy for your packets

By anup.varier@gmail.com

AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...

Read the latest Blogs

Forums

Semantic Search in SQL Server 2025

By Deepam Ghosh

Comments posted to this topic are about the item Semantic Search in SQL Server...

Encoding URLs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Encoding URLs

An SSIS Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item An SSIS Upgrade

Visit the forum

Question of the Day

Encoding URLs

I have this data in a table:

CREATE TABLE Response
( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY
, ResponseVal VARBINARY(5000)
)
GO

If I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use?

See possible answers