Notes From SQLSaturday South Florida
Notes from the trip:
Four hour drive between traffic and rain, about an hour longer than I would have liked. The...
2014-06-16
455 reads
SQLAndy
I Gotta See the Code–Question of the Day
I Gotta See the Code is a security question about viewing the code to a stored procedure. Two points if...
2014-06-16
573 reads
Reflections On Fathers Day
Fathers Day coincided with the family vacation this year and maybe more than some years I had the time to...
2014-06-16
533 reads
SQL Saturday South Florida And Then Vacation
I’m leaving early afternoon for the longish drive to South Florida for SQLSaturday tomorrow. The schedule looks impressive! I missed...
2014-06-13
553 reads
SSIS Lessons Learned, Or Not, And Mistakes Beginners Make
It’s been a while since I’ve used SSIS for anything of substantial complexity, and a lot longer than that since...
2014-06-12
804 reads
Giving Away Woodworking Magazines
I read a lot and one of the topics I enjoy reading about is woodworking. Recently I’ve been on a...
2014-06-12
637 reads
SQLSaturday in Vermont, Idaho, South Dakota, Montana, Alaska, Arkansas, Mississippi, and Wyoming
Did the list of states in the title catch your eye? That’s the list of states where PASS is trying...
2014-06-11
528 reads
Status and Name Please-Question Of The Day
Status and Name Please is my latest Question of the Day at SQLServerCentral. This is a fairly easy question, but...
2014-06-11
405 reads
Editorial: Space Hoarders
I wrote Space Hoarders for SQLServerCentral, a discussion of why we – the DBA’s of course – are always blamed for the...
2014-06-10
483 reads
Prepping For The NomCom
Sunday I spent an hour going over various notes and thinking about what I’ve seen in the past couple PASS...
2014-06-09
357 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
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
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