Alas, Poor Snapshot, I Knew Him Well (Question Of the Day)
My latest question of the day is up, this one called Alas, Poor Snapshot, I Knew Him Well. If you’ve...
2014-03-20
508 reads
SQLAndy
Submitting PASS Summit Sessions
I’ve been thinking for a while about what to submit for this year. I knew I wanted to have one...
2014-03-19
641 reads
Why Am I Here? You’re On Retainer
That’s just one of about a hundred great lines from episode 1 of Farmed and Dangerous. A company with the...
2014-03-19
612 reads
A Nicely Made Smoke Detector
This may not be the exact model, but I bought 2 First Alert detectors at Costco for $23. Not a...
2014-03-19
677 reads
Reminder: Orlando Code Camp Is This Weekend (March 22, 2014) and It’s Not Just For Developers!
I’ll be attending the Orlando Code Camp this weekend. I know it says “code”, but there is a SQL Server...
2014-03-18
532 reads
A Minute About Minute Key
You may have seen these minuteKey boxes at your local home supply store (Lowes has it near me) that let...
2014-03-18
741 reads
Rodney Landrum Presenting at oPASS on March 20, 2014
Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover...
2014-03-17
519 reads
Some Notes On Writing A Question Of The Day
I wrote Write The Perfect Question (Of The Day) last week and yesterday dropped a note here about my latest...
2014-03-13
475 reads
You Broke My Tail Light
That’s the first thing I heard when I answered the phone recently. I was working on an change I needed...
2014-03-13
746 reads
Webinar Today at 3pm
I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...
2014-03-13
395 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