Who should own the database?
TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...
2018-01-25 (first published: 2018-01-15)
2,725 reads
SQLStudies
Fun with sp_rename
Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...
2018-01-11
1,613 reads
A Solution for Squirrely SQL Server Security: TSQL Tuesday #98
It’s the first T-SQL Tuesday of the year! Arun Sirpal (b/t) is our host this month. Thanks, Arun! The subject...
2018-01-09
313 reads
SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,504 reads
What is impersonation for?
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
807 reads
Making music with Powershell
Happy holidays everyone! Ok, this isn’t even remotely related to SQL Server but it sounded fun. I found someone playing...
2017-12-20
981 reads
When do usernames and passwords belong in connection strings
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
721 reads
How to: Create an Azure VM with SQL Server using a default template
One of the really cool things about the cloud is how quickly you can spin up a new machine to...
2017-12-14
538 reads
T-SQL Tuesday #97 – Setting learning goals for 2018
T-SQL Tuesday. Each month a different blogger hosts Adam Machanic’s (b/t) blog party. The host comes up with a topic...
2018-01-01 (first published: 2017-12-12)
1,700 reads
Restrict the usage of a SQL Server Authenticated Application Id
SQL Server login ids may not be the most secure thing in the world but they are likely to be...
2017-12-18 (first published: 2017-12-06)
1,734 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
Access + ODBC Driver 18 + SQL Server 2025: ~150–250 ms per request
Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...
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
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