Public Role and Security
Having flown a fair amount lately, I was thinking about the various levels of security within an airport. Part of...
2011-12-29 (first published: 2011-12-20)
3,548 reads
Jason Brimhall
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out of curiosity, I decided to take a look at...
2011-12-28
13 reads
My Top 5 for 2011
I have seen a few recap posts bouncing around the net and started thinking about my own blog. So out...
2011-12-28
849 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down thrown the tree trying to find that one specific...
2011-12-21
24 reads
Filtering in SSMS
Do you spend seconds, maybe even minutes trying to find things in SSMS? Ever find yourself scrolling up and down...
2011-12-21
1,997 reads
Public Role and Security
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
23 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is Meme15 and is the pet project of Jason Strate (Blog|Twitter)....
2011-12-17
14 reads
Why do I Blog?
Last week I heard about a new blog party/meme coming down the pipe for the #SQLFamily. This new meme is...
2011-12-17
710 reads
T-SQL Tuesday #025 – Holiday Gifts
Tis the Season
It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And...
2011-12-15 (first published: 2011-12-13)
1,490 reads
T-SQL Tuesday #025 – Holiday Gifts
Tis the Season It is the season for TSQL Tuesday. More importantly it is the season for giving and reflection. And whether you celebrate Christmas or Chanukkah or Kawanzaa...
2011-12-13
17 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
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
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
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