PASSion Award Nominations
PASSion Award
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these...
2011-09-04
1,504 reads
Blog Posts
2011-09-03
362 reads
Server sudden shutdown unavailable
It’s not always straightforward to diagnose a server problem. You look through the SQL Server Logs and Event Viewer for...
2011-09-03
1,058 reads
Task Factory: Advanced Email and SMS Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,714 reads
Task Factory: Compression Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,415 reads
Task Factory: Data Cleansing Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,238 reads
Task Factory: Data Validation Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,692 reads
Task Factory: Email Source and Delete Email Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,382 reads
Task Factory: File Properties Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
2,110 reads
Task Factory's Address Parse Transform
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,073 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