SQL University: SQL Server Security Architecture - 3rd Party, No Options
Welcome back to day 2 of Security Week for this semester of SQL University. If you missed yesterday's introduction, you'll...
2011-02-08
2,488 reads
Book #2 - Dynasty in the making?
Ok so dynasty might be a bit strong, but check out this
newest volume from the folks @ Pragmatic Works. We...
2011-02-08
633 reads
10 Things Every DBA Should Do
Recently I spoke about how The Best Database Administrators Automate Everything, as well as Document Everything and this got me...
2011-02-08
2,363 reads
February PASSMN Meeting Announced
If you are looking for a change to get together with other SQL Sever professionals in February to talk about...
2011-02-07
727 reads
Promoted to MSDB Rockstar Blogger
I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger...
2011-02-07
497 reads
SQL Saturday #60: The Saga
First, let me thank Erin Stellato (blog|twitter) and all the volunteers for running such a great event. Nicely done.
This event...
2011-02-07
767 reads
SQLSaturday #62–Tampa Recap
I had the privilege of attending and speaking at SQLSaturday #62 – Tampa the weekend of January 15th and this is my belated recap post of what I did...
2011-02-07
18 reads
Speaking at the Houston SQL Server Users Group
Since I am working at a client this week in Houston, I begged Nancy Hide Wilson (President Houston SQL Server Users...
2011-02-07
599 reads
PowerShell: Download List of SQL Server MVPs
Turtle Shell?!
This weekend, I was working on something that I will blog about later this week. As part of that,...
2011-02-07
767 reads
SSIS: Custom Folder in your Package Store
Recently at SQL Saturday #57 – Houston I explained how to add a custom folder to your SSIS package store. I...
2011-02-07
1,487 reads
Blogs
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
The #MS_DatabaseConnector## Role: #SQLNewBlogger
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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