I am a Big Bro
The first time I did any volunteering work for PASS was last year at the Summit. I enjoyed doing it....
2011-08-15
1,684 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send...
2011-08-15
29 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method...
2011-08-15
1,339 reads
Micromanaging
Micromanaging is one of those words that evokes an instant negative image. Certainly there are times when it happens, but...
2011-08-15
638 reads
ColoradoSQL in August
All ColoradoSQL user group meetings start at 5:30 and provide food and refreshments. There is no cost to attend so...
2011-08-15
592 reads
Using Checksum in SSIS for Delta Loads
The checksum function in SQL is a great way to compare two rows to see if the data matches. The...
2011-08-15
4,031 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,492 reads
Notes from SQLSaturday #79
This was the third SQLSaturday in South Florida and the third time I’ve attended, just too good an event to...
2011-08-15
736 reads
SQLPeople INSPIRE NYC - Coming this FALL - November 12, 2011
Nature abhors a
vacuum. So, when I see so many SQL
Server happenings going on all over the country, and indeed the...
2011-08-15
1,857 reads
Don't Wait to Start Blogging
I was reading a post by Jonathan Fields (blog | twitter) about making bad guitars. Okay, so what does that have to...
2011-08-15
2,257 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