Reblog: September 19 to September 25
Photo credit – Mike Lynch
A good cure to a creepy doll is a good old post that is still useful. In...
2014-09-26
800 reads
PASS Rocks SQL Saturday
I had another piece that looked at some issues with PASS slated for today, but it’s been a tough morning....
2014-09-26
1,038 reads
Development, Leadership, Age
While I was at the VMWare HQ getting some amazing training a few weeks ago, we had the opportunity to...
2014-09-26
671 reads
People Helping People – Volunteers
Continuing on with things that PASS does well, since I want to be balanced, I wanted to talk about volunteers....
2014-09-26
905 reads
Friday Followup For September 26, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-09-26
455 reads
2014-09-26
11 reads
2014-09-26
13 reads
2014-09-26
26 reads
Re-Indexing – The quest of ultimate automation
In this session, Prakash will walk you through design considerations, accompanied with a script demo using PowerShell to generate a...
2014-09-26
634 reads
Wait Statistics #4 LCK_M_xx
In the 4th article of the Wait Statistics series we will dive into LCK_M_xx waits. This is another wait type...
2014-09-26
1,329 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
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
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