Struggling With Due Diligence
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
548 reads
It’s been a while since my last post, there are various reasons for my absence: work, illness, having our house...
2016-06-23
548 reads
Did you know that the call for speakers for PASS Summit 2016 opened on February 3, 2016?
Did you know that...
2016-02-15
454 reads
One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you...
2016-02-02 (first published: 2016-01-25)
3,038 reads
It’s that time of year, planning for PASS Summit 2016. We’ve already put out the Call for Volunteers, which closes...
2016-01-22
392 reads
It seems like PASS Summit 2015 was just yesterday and here we are again, getting ready for Summit 2016 already. ...
2016-01-08
427 reads
As a DBA, I have a collection of scripts that I use for anything from auto-fixing logins to seeing who...
2015-11-20
981 reads
If you use SQL Server Data Tools (SSDT) and SQL Server Data Tools – BI (SSDT-BI) for your SQL Server 2012...
2015-11-19
475 reads
There we so many cool announcements at the PASS Summit this year, but one of my favorites was the “One...
2015-11-18
609 reads
Recently I attended Reg-Gate’s SQL in the City event in Seattle, WA. I was in Seattle for the annual PASS...
2015-11-10 (first published: 2015-11-05)
2,690 reads
October has been such a whirlwind of PASS activity for me. Two SQL Saturdays and the PASS Summit. This post...
2015-11-03
516 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