log reader uses single CPU
For replication even if you have multi core CPU it uses only one as log reader agent has single threaded...
2015-10-09
444 reads
Vinay Thakur
Whats new in SQL Server 2016
While learning SQL Server 2014. looks like we need to swing on it as SQL Server 2016 is coming with...
2015-07-31
1,642 reads
hey its time for 2016!!!
Hi all Yeah its true microsoft announced SQL server 2016 and CP2 has been released to public also we can...
2015-05-29
1,227 reads
Whats New 2014
Hey all, Continue to my whats New series, I am going through its new features and the more I am...
2014-12-19
579 reads
Re-initialize replication not working
For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask...
2014-02-22
568 reads
Sql Cluster Resource not comming online
when you check on the sql server services and sql agent services it’s getting started on windows cluster but on...
2014-02-22
686 reads
TempDB Contention 2.1.%
Problem: When you are performing many DML operations and makes tempdb contesnion on it, You may get wait_resource of 2.1.103...
2013-10-16
749 reads
Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
898 reads
LogReader agent failed
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
841 reads
Sql Server 2014…….What!!!
Yes, its true. Microsoft vice president has announce that new version of sql server 2014, will release on 2014… do...
2013-06-17
1,078 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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