Every once in a while, you'll have a slightly more complex UPDATE statement in an OLE DB Command or Destination. You'll use an UPDATE statement or a destination table that needsto use...
2011-05-18
15 reads
Interesting new BI site from Microsoft called “BI Labs“. This site says: “BI Labs is a collection of experimental business...
2011-05-18
1,129 reads
I blogged a week ago about the sessions that I submitted for the PASS Summit this year. At the point...
2011-05-18
1,085 reads
This year the PASS organization is asking us to vote on the PASS Summit 2011 sessions, not as a means...
2011-05-18
738 reads
(Yet another boring org chart example – except this one has multiple roots)
One of my apps has a hierarchial org chart...
2011-05-18
1,729 reads
A discussion of where logic should go and why SQL might be the best place.
SQL is a powerful language and...
2011-05-18
850 reads
Someone posted this query recently:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name = 'INSERT'
and
b.grantee_principal_id = a.principal_idThat’s a little ugly, so let’s fix...
2011-05-17
2,251 reads
I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”. The idea is that there’s...
2011-05-17
799 reads
May 17th NJSQL UG Meeting - SQL Server 2008 Database mirroring with MAK
Date: Tuesday, May 17th
Topic: SQL Server 2008...
2011-05-17
901 reads
Since I’ve been blogging about my progress through the SQL Server MCM certification, it makes sense to follow-up with my...
2011-05-17
685 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