Women in technology
Earlier this week a friend of mine (Lynn Swayze (Hall) (b/t)) posted this great article on women in technology. It’s...
2015-11-25
636 reads
SQLStudies
Using multiple log files
The transaction log is made up of one or more files that are used sequentially. So in other words if...
2015-11-27 (first published: 2015-11-23)
1,565 reads
Naught to Speaker pt 3
Becoming a speaker is one heck of a journey. Early this year I submitted a session to speak at Pass...
2015-11-18
643 reads
SSMS Setup
Every time I install a new version of SSMS I make a handful of changes to the default setup. For...
2015-11-16
1,153 reads
Hiding one or more columns
This isn’t something you have to do frequently, but sometimes you don’t want the users to have access to certain...
2015-11-12
696 reads
Why are you still using datetime?
It’s almost Thanksgiving time again! Let’s see, what am I thankful for? T-SQL Tuesday! Someone else get’s to pick a...
2015-11-12 (first published: 2015-11-10)
4,857 reads
Questions from “SQL Server Security for Everyone”
I recently gave my SQL Server Security for Everyone session at Summit 2015. (I’m still in awe about that by...
2015-11-04
524 reads
Administrative Logins and Users
If you’ve ever worked through an audit you have probably gotten a request that looks a lot like this:
Please give...
2015-11-02
530 reads
Who’s on call
Of all the posts I’ve written I think this one is my favorite, even though it’s not a technical post....
2015-10-28
507 reads
Finding and keeping your #SQLPassion
I consider myself lucky. I fell into a job that I truly enjoy, something that I do for fun even...
2015-10-26
496 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