The #MS_DatabaseConnector## Role: #SQLNewBlogger
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle...
2026-11-04
13 reads
I had seen these roles in various instances, but never dug into the new Fixed Server roles added to SQL Server. They are supposed to help ensure the principle...
2026-11-04
13 reads
I have a few Azure subscriptions, which are fairly small and not used that often. Mainly I do some SQL Server or Azure SQL experimentation. Sometimes I might create...
2026-11-02
20 reads
We keep adding stuff to Redgate Monitor, and it’s easy to miss some of the improvements. Here’s one that’s been around quite awhile, but while discussing the product with...
2026-11-02 (first published: 2026-10-26)
234 reads
“You don’t need more time because you already have all the time that you will ever get; you need more focus.” – from Excellent Advice for Living Boy, I...
2026-10-30 (first published: 2026-10-23)
156 reads
This month I want to look at a few of the things I’ve seen posted about cars during the last month. These are a few headlines, as well as...
2026-10-30
218 reads
I was looking over the CHOOSE() function while editing an article at SQL Server Central. I realized there isn’t a documentation note on how many parameters can be included....
2026-10-28
112 reads
I had a briefing for the 2026 PASS Data Community Summit, which is just a couple of weeks away. Amongst a bunch of admin type stuff, there was a...
2026-10-27
22 reads
I’m back from a great vacation. I had the chance to visit two new countries (for me and my wife) and many new cities as we cruised around the...
2026-10-23 (first published: 2026-10-22)
1,301 reads
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that Look Too Easy. I decided to give you a few thoughts from me on the...
2026-10-14 (first published: 2026-10-05)
382 reads
This is timely, as I’m currently on a boat in the Adriatic taking a break with my wife. I think I’m in Croatia (or off the coast) today, but...
2026-10-13
67 reads
By Steve Jones
I had seen these roles in various instances, but never dug into the new...
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,...
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
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
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