What account is xp_cmdshell using?
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. ... Continue reading
2021-05-25
179 reads
Kenneth Fisher
All jobs that ran during a given time frame.
Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of ... Continue reading
2021-05-17 (first published: 2021-05-06)
689 reads
#PowershellBasics: Comments and comment based help
I’ve talked about SQL Server comments before and how important they are. In PowerShell comments are important for all the same reasons and then some. So first of all...
2021-05-13
94 reads
What do you do when technology changes? : T-SQL Tuesday #138
Our host for this month’s TSQL Tuesday is Andy Leonard (blog|twitter). He’d like us to discuss how we handle changes ... Continue reading
2021-05-11
26 reads
#PowershellBasics: Setting a variable vs a comparison.
In SQL Server both the set and equality functions are handled by the equals sign (=). For example: Set Equality ... Continue reading
2021-05-10 (first published: 2021-04-27)
423 reads
SQL Homework – May 2021 – Extended Events.
You’ve probably heard about extended events right? I honestly don’t care if you are #teamProfiler or #teamXE you need to ... Continue reading
2021-05-04
136 reads
WITDC Mental Health and Wellness Day- May 7th
Next Friday WITDC is having a Mental Health and Wellness Day virtual event and I’ll be speaking! I can’t tell ... Continue reading
2021-04-29
43 reads
Right sizing int : T-SQL Tuesday #136
Brent Ozar (blog|twitter) is our host this month, which will make this the most popular #tsql2sday to date I’m sure. ... Continue reading
2021-03-15 (first published: 2021-03-09)
349 reads
What is the CONTROL permission?
One of the most powerful permissions available in SQL Server is control. But what exactly is it? Per BOL: CONTROL: ... Continue reading
2021-01-27 (first published: 2021-01-19)
559 reads
“They need help, we must help.” #forGarethSwan
We just finished a memorial for Gareth Swanepoel. He was an amazing person and someone I wish I’d gotten to ... Continue reading
2021-01-22 (first published: 2021-01-14)
340 reads
Blogs
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
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...
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