SQL University: Who has access to my SQL Server?
Welcome to PowerShell Week #2 for SQL University! One of the frequent questions I hear is, "Who has access to...
2011-04-26
2,803 reads
Databases – Infrastructure – Security
If a web page asks you to update Adobe Flash Player
You don't want to do so from that web page. Instead you want to go to the Adobe web site...
2011-04-22
1,139 reads
Why having two accounts is a good thing
Today on Twitter a friend of mine posted that the AV on his SQL Server flagged two trojans that were...
2011-04-22
715 reads
Evaluating my SQL Connection Scores
This evening I received my SQL Connection scores for the following presentations:
Windows Internals for DB ProsFrom the Ramparts: Knowing What...
2011-04-20
1,492 reads
Cain does LSA Secrets dump on Vista and higher now
Since going back to being a senior DBA, I've not stayed on top of the latest tools like I did...
2011-04-19
2,088 reads
"What's the point?"
This is a crucial question with regards to what needs to be done. It really hit home after listening to...
2011-04-18
812 reads
It's not about whether you're a consultant or full-time staff...
There's an article that's making its way through the SQL Ranks: Consultants are pros, while corporate IT staff are minor...
2011-04-12
1,343 reads
An Appeal to Those Writing Training Documentation and Labs
I'm coming to the end of a week of training in a Microsoft Official Curriculum (MOC) Course. I should expect...
2011-04-08
940 reads
On Leadership - Lead by Example
This is the second part of a leadership series I started with On Leadership - Lead from the Front. To recap...
2011-04-07
1,612 reads
SQL PASS ERC: How to Score the Interview?
One of the topics the Election Review Committee has discussed is how best to score the interview portion. Because of...
2011-04-06
1,365 reads
Blogs
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,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
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