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 Replication SubscriptionStreams setting

by Dharmendra Keshari

SQL Geek

In this blog, we will talk about improving distribution agent throughput by modifying the profile parameter – “SubscriptionStreams”. I will be...

2017-10-23 (first published: 2017-10-14)

6,900 reads

Extracting Deadlock information using SYSTEM_HEALTH Extended Events

by Dharmendra Keshari

SQL Geek

Extended Events is a powerful feature that was introduced into SQL Server 2008 and onwards. It keeps historical system health...

2017-10-12 (first published: 2017-10-07)

13,485 reads

What Immediate_sync means in Transactional Replication – Part1

by Dharmendra Keshari

SQL Geek

In my previous two blogs – Capture Important Parameters of the SQL Server Replication and Add new articles to existing Transactional Replication...

2017-07-31 (first published: 2017-07-18)

2,800 reads

SQL Server 2017 – DMV – sys.dm_os_host_info

by Dharmendra Keshari

SQL Geek

I always love to get my hands dirty with new features of SQL Server. I was exploring SQL Server on...

2017-07-27 (first published: 2017-07-14)

2,171 reads

Connect SQL Server on Linux using Bash on Ubuntu on Windows

by Dharmendra Keshari

SQL Geek

Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You...

2017-07-21

17,078 reads

Add new articles to existing Transactional Replication without initializing old articles

by Dharmendra Keshari

SQL Geek

Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...

2017-07-20 (first published: 2017-07-10)

12,108 reads

Capture Important Parameters of the SQL Server Replication

by Dharmendra Keshari

SQL Geek

Whenever there is a business requirement to add a new article to an existing publication, you want to know how...

2017-07-13 (first published: 2017-07-03)

1,682 reads

SQL Server Database Files Wise I/O Latency Details PART#1

by Dharmendra Keshari

SQL Geek

One of the real-world I/O troubleshooting problems is – If you have your databases spread across multiple LUNs and you want...

2017-07-03 (first published: 2017-06-26)

4,234 reads

SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2

by Dharmendra Keshari

SQL Geek

Since the DMF sys.dm_io_virtual_file_stats shows cumulative I/O statistics value for the database files, you can’t just use the DMF to...

2017-06-29

1,166 reads

How the Initial VLF sequence number gets decided of the default transaction log file

by Dharmendra Keshari

SQL Geek

In last three years, I presented two times on the topic Transaction Log File Architecture. During the sessions, when I discussed...

2017-06-28 (first published: 2017-06-20)

1,568 reads

Blogs

RANK() vs DENSE_RANK(): #SQLNewBlogger

I haven’t done one of these in awhile, but I saw an article recently...

Using CAT for Testing of Data Agents

By Joyful-Craftsmen

In last months one of the scenarios where you can use AI has been...

Are you getting value from your reporting?

By ChrisJenkins

Do you spend so long manipulating your data into something vaguely useful that you...

Read the latest Blogs

Forums

Fun with JSON

Comments posted to this topic are about the item Fun with JSON

Creating JSON II

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON II

Engineer Lessons

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Engineer Lessons

Visit the forum

Question of the Day

Creating JSON II

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON)
GO

See possible answers