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,803 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,375 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,795 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,165 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,042 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,079 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,676 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,227 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,161 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,562 reads

Blogs

Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests

By Rayis Imayev

"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...

Adding a Local Model to Ollama through the GUI

I saw some good reviews of the small gemma3 model in a few places...

Connect resiliently to SQL Server

By Peter Skoglund

Why you should connect resiliently to SQL Server Transient failures happen — in the cloud...

Read the latest Blogs

Forums

Some query values change when query is run but not others. Why?

Hi everyone I have a 1000 line SQL query that is too long to...

using different credentials when debugging ssis

hi, now and then i want one connection in my ssis pkgs to use...

AlwaysON health check alerts

By Srinivas Merugu

Comments posted to this topic are about the item AlwaysON health check alerts

Visit the forum

Question of the Day

PWDCompare

What does the PWDCOMPARE function do?

See possible answers