Checking out Windows Server Technical Preview on Azure !
I’m a great fan of running the latest version of Windows Server whenever I deploy SQLServer. I always try to...
2014-10-10 (first published: 2014-10-04)
6,172 reads
Common Table Expressions (CTE)
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...
2014-10-08 (first published: 2014-10-03)
9,033 reads
Reblog: September 26 to October 2
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-10-03
841 reads
Friday Followup For October 3, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-10-03
345 reads
Microsoft, Me and the MVP
October 1st is one of the quarterly dates that Microsoft announces all of the new people into the MVP program. It is also a day in which Microsoft recognizes...
2014-10-02
18 reads
Microsoft, Me and the MVP
October 1st is one of the quarterly dates that Microsoft announces all of the new people into the MVP program....
2014-10-02
589 reads
Testing your API
I think learning to better test our software, including the database objects, is one of the ways in which we’ll...
2014-10-02
795 reads
Let’s Create More After Hours Events at the Summit
We’ve got a good handful of events listed for After Hours so far, but couldn’t we have more? A couple...
2014-10-02
843 reads
The PASS Board: #passvotes
Ever been in a fight? Ever been in one that’s not completely going your way? I’ve done this and seen...
2014-10-02
477 reads
Fixing SCOM After a Hardware Upgrade
Quick note in case I need again some day. The team recently moved all the user databases for a monitoring...
2014-10-09 (first published: 2014-10-02)
6,031 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