Re-blog – May 6-12
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-05-13
548 reads
An Update To My Previous Post
I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve...
2011-05-13
577 reads
Project Management: Dedicated vs. Shared Resources
As an infrastructure type person, I typically represent a "shared" resource. What that means is I'm not dedicated to just...
2011-05-13
18,962 reads
Please vote for my SQLPASS precon and sessions
A few days ago, SQLPASS opened the voting for the precon’s and sessions for the annual
SQLPASS community summit. I’ve also...
2011-05-12
637 reads
A curious case of a missing configuration group.
G’day,
I recently received a brand new windows 7 virtual machine for my every day work use and one of the first things...
2011-05-12
1,500 reads
Notes from SQLRally Orlando
Tuesday afternoon started with me being an unexpected behind schedule, and then another interruption or two, but by 4:30 pm...
2011-05-12
700 reads
SQL Rally Day 1 PreCon
Yesterday was the first day of the SQL Rally conference in Orlando, FL.It was a great first day because I...
2011-05-12
827 reads
Clean Code is Easier to Read – SQL Prompt
I saw a post recently that had query that looked like this:
select a.*,name, b.*
from sys.database_principals a, sys.database_permissions b
where permission_name...
2011-05-12
1,839 reads
You Are Responsible for You
Steve Jones wrote an editorial yesterday called The Poor Soul. It talked about being thrown into a responsibility one didn't...
2011-05-12
752 reads
Locking While Dropping or Altering an Index
Yesterday I was trying to drop some hypothetical indexes in production against a fairly active table. I started causing blocking...
2011-05-12
7,586 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