SQL Replication SubscriptionStreams setting
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)
7,030 reads
Dharmendra Keshari
Extracting Deadlock information using SYSTEM_HEALTH Extended Events
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,781 reads
What Immediate_sync means in Transactional Replication – Part1
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,821 reads
SQL Server 2017 – DMV – sys.dm_os_host_info
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,201 reads
Connect SQL Server on Linux using Bash on Ubuntu on Windows
Since Microsoft has launched SQL Server on Linux, you would be working on both the platforms Linux and Windows. You...
2017-07-21
17,153 reads
Add new articles to existing Transactional Replication without initializing old articles
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,180 reads
Capture Important Parameters of the SQL Server Replication
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,719 reads
SQL Server Database Files Wise I/O Latency Details PART#1
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,261 reads
SQL SERVER DATABASE FILES WISE I/O LATENCY PART#2
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,190 reads
How the Initial VLF sequence number gets decided of the default transaction log file
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,589 reads
Blogs
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers