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,707 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,175 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,790 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,163 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

16,993 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,034 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,664 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,220 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,154 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,556 reads

Blogs

Measuring and Improving SQL Server Query Plan Cache Efficiency

Measuring and Improving SQL Server Query Plan Cache Efficiency The query...

Communicate to the Individual

By Brian Kelley

I may think I'm trying to reach the crowd, but I'm really trying to...

PESTLE Analysis for Databases Explained | Real-World Use Cases & Tool

📘 Understanding PESTLE PESTLE is a strategic framework used to evaluate external macro-environmental factors...

Read the latest Blogs

Forums

The Technical Debt Anchor

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Technical Debt Anchor

Getting the Updated Column List

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Getting the Updated Column List

SSRS: An error occurred during local report processing. The definition of ...

Here's the complete error: An error occurred during local report processing. The definition of...

Visit the forum

Question of the Day

Getting the Updated Column List

What happens when I run this code in SQL Server 2022?

UPDATE dbo.CustomerLarge
 SET CustomerContactFirstName = 'Andy'
 WHERE CustomerID = 1

SELECT COLUMNS_UPDATED()

See possible answers