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,906 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,500 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,079 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,111 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,683 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,235 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,168 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

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

AI: Blog a Day – Day 7: Vector and Vector Databases

By Vinay Thakur

Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...

Read the latest Blogs

Forums

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Restoring On Top I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring On Top I

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers