To be brief. What to do when PATH variable is too long to be real PATH.
Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...
2014-09-15
858 reads
Sometimes after installing pretty useful addins when starting SSMS you can see error message like "Exception has been thrown by...
2014-09-15
858 reads
Some days back, I received one query on my facebook page that user want to create Database Snapshot frequently & want...
2014-09-15
504 reads
Awesome crowd this morning for my SQL Admin Best Practices with DMV's presentation at Houston TechFest 2014, thanks very much...
2014-09-13
574 reads
Continuation from the previous 40 parts, starting from http://www.nikoport.com/2013/07/05/clustered-columnstore-indexes-part-1-intro/
Note: This article is in’s 2nd version, after correcting comments done by...
2014-09-13
245 reads
Reg count at 479. Looking very good for hitting 500!First sponsor sent out a geo-targeted message for us, another one...
2014-09-12
645 reads
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-09-12
811 reads
Hello Dear Reader! Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional...
2014-09-12
2,065 reads
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-12
579 reads
Schema on Read vs Schema on Write in Business Intelligence
When starting build out a new BI strategy. There are more...
2014-09-12
1,226 reads
PASS Virtual Chapter Events: September 2014
Join SQL Server professionals from around the world for free online technical training and networking...
2014-09-11
641 reads
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item Planning for Change
Comments posted to this topic are about the item Importing Excel files into SQL...
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