Have the Time? Get in the Game.
This year there's a two step process for electing members to the Professional Association for SQL Server (PASS) Board of Directors...
2011-08-11
897 reads
T-SQL Tuesday/Wednesday #21: A Crappy Workaround
A long time ago (in IT terms) in a galaxy far, far away I was helping an organization with a...
2011-08-10
2,070 reads
Functionality and User Experience are important, too
There are a few posts and articles around the security-scape lately concluding Windows 7 is more secure than OS X,...
2011-08-09
822 reads
Security Is Your Responsibility
My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...
2011-08-08
966 reads
MSSQLTips.com Kindle Contest
I'm always wary of contests to win free stuff, but the folks running MSSQLTips.com are legitimate (I write there as...
2011-08-04
1,049 reads
Rant: Security Isn't Sexy and It's a Shame
I grew up immersed in security. My father was a US Marine and going on and off base meant... security....
2011-08-03
1,237 reads
Bad Network Performance? Check the TCP Chimney Offload/Receive Side-Scaling/Network DMA Settings
We recently ran into a case where connecting to a Windows Server 2003 server with SQL Server installed on it,...
2011-08-02
15,685 reads
Bad Admins: Non-Production Servers
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-28
2,193 reads
Bad Admins: Taking Advantage of Maintenance Periods
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-25
1,073 reads
Bad Admins: Stealing the SQL Server Service Account
This is part of a series of tips on how bad/rogue admins can get access to the data in your...
2011-07-22
1,382 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