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,861 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,425 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,797 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,167 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,063 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,094 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,679 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,231 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,163 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,564 reads

Blogs

The Benefits of Teaching

By Brian Kelley

Even preparing for a class or seminar with set materials takes a lot of...

Power BI, Excel, OneLake – Dreams Do Come True!

By DataOnWheels

I can’t believe it’s finally here! A way to have Excel live in OneDrive...

The Book of Redgate: What Our Staff Says

This image is from 2010, and it goes along with my last post of...

Read the latest Blogs

Forums

Deny Connect problem

By Brandie Tarvin

I have a login I need to deny connect to on a server, but...

Website Stability 2025/12/05

By Steve Jones - SSC Editor

All week we've had issues with the site being up and down. There's been...

403 Forbidden

I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...

Visit the forum

Question of the Day

Fabric Mirroring

In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?

See possible answers