SQL Saturday #70 - Tomorrow will be here soon!
We are in the final stages of prepping for SQL Saturday #70, here in Columbia, SC. We have right around...
2011-03-18
736 reads
Databases – Infrastructure – Security
Beginner Sessions at SQL Saturday #70 - Columbia, SC
A very good question was asked about the SQL Saturday #70 session track, and that's "What courses are best suited...
2011-03-15
860 reads
SQL Server Connectivity Issues with Named Instances
This came up on Twitter last night and if you're not very strong on networking, this can be really confusing....
2011-03-10
13,538 reads
[OFF-TOPIC] Make a difference
I follow the blog of Johnny Long (twitter) from time-to-time, especially as he chronicled his work in Uganda. I know...
2011-03-09
812 reads
Selecting Speakers for SQL Saturday #70
The Call for Speakers for SQL Saturday #70 - Columbia, SC, ended on February 17, 2011. We wanted to put the...
2011-02-25
1,656 reads
PASS in Five Years: It's about the Members
Andy Warren (blog | twitter) recently blogged about wanting input on What Should PASS Be? and I think it's a reasonable...
2011-02-24
1,508 reads
Configuring Antivirus for SQL Servers
I've been on both sides of the debate with respect to whether or not to install antivirus software on a...
2011-02-24
3,398 reads
PASS Election Review Committee: NomCom Process
Over on the ERC forums, Bill Graziano (blog | twitter) has posted the proposed NomCom selection process. We would really like...
2011-02-23
610 reads
Shameless Self-Promotion - Introduction to SQL Server [Book]
My introductory text to SQL Server, appropriately titled Introduction to SQL Server, is now in print and available for sale. The...
2011-02-22
963 reads
Use Patterns and Prior Code and Don't Reinvent the Wheel
In recent days I've seen folks try to recreate functionality when they had access to code that already did effectively the...
2011-02-21
1,991 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