MCITP and ME
Last year (and this year too) I had set the goal to renew my certification. I failed miserably at it...
2011-05-19
523 reads
Change SQL Servers Authentication Mode with PowerShell
Lately I've been working on scripts to check and set security and configuration settings for SQL Server using PowerShell. One...
2011-05-19
5,887 reads
WHERE HAVE YOU BEEN, patrick leblanc????
Ok, so what have I been up to?Well a lot has changed for me over the past couple of months,...
2011-05-19
1,134 reads
Report Builder: Change Report Server Connection
A question that I have been asked quite often is, “How can I change the Report Server that I am...
2011-05-19
6,502 reads
The 2013 PASS Summit Goes to Charlotte
Just in case you didn’t catch the news yesterday on Twitter, the PASS blog, or via the PASS Connector, we...
2011-05-19
698 reads
Answering SQL Questions and Forum Fun Overview
Why SQL questions are interesting and how I'm using forums to challenge myself and help others.
I like a good SQL...
2011-05-19
659 reads
Fun with SQLskills
I’m in a fun mood today, so a few silly items for you.
The last few weeks, Paul Randal (blog | @PaulRandal)...
2011-05-18
900 reads
Summit Preference Voting
This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...
2011-05-18
738 reads
New Microsoft BI Labs site
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,129 reads
The Recursive CTE
(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...
2011-05-18
1,729 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
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
Planning for Change
Comments posted to this topic are about the item Planning for Change
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