T-SQL Tuesday 109: Influence Somebody Invite
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote...
2018-12-04
10 reads
Building on the work of these three fine individuals, here comes the difficult task. You have been the benefactor of some awesome help from somebody else. You even wrote...
2018-12-04
10 reads
How have you impacted somebody in the community?
It has now been 28 months since the last time I hosted a...
2018-12-04
233 reads
I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...
2018-12-03
27 reads
One of the really super cool things about the SQL community is the frequent opportunity one could have to get involved.
One of my favorite methods of getting involved is...
2018-11-30
14 reads
It’s a Wonderful Life
One of the really super cool things about the SQL community is the frequent opportunity one could...
2018-11-30
269 reads
Working as a Data Professional
An old friend Malathi Mahadevan (b | t) asked me one day if I would be interested...
2018-11-29
254 reads
Not only will you encounter some interesting stories, but I believe you will also encounter some interesting insight into some of the contributors for this book: Data Professionals at...
2018-11-29
13 reads
When it comes to characteristics of an MVP, the two groups (geek and jock) are no longer at the opposite ends of the spectrum. Rather, they are very similar...
2018-11-28
15 reads
How to be an MVP in LIFE
One of the fun things about being involved in the community is the opportunity...
2018-11-28
306 reads
As a Database Administrator, something that should be part of your database audit is monitoring the growth of files. That...
2018-11-27
574 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