Grant Fritchey

Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Advocate in January 2011. Find Grant on Twitter @GFritchey or on his blog as the Scary DBA.

Twitter: @https://twitter.com/gfritchey
Website: https://scarydba.com
LinkedIn: https://www.linkedin.com/in/grant-fritchey/
Bluesky: https://bsky.app/profile/gfritchey.bsky.social

Life/Work Balance

by Grant Fritchey

The Scary DBA

Technology, especially information technology, is the greatest thing to ever happen to mankind, freeing us from toil and drudgery. Technology,...

2010-12-13

927 reads

12 Days of SQL, On the 2nd Day of SQL…

by Grant Fritchey

The Scary DBA

Microsoft gave to me, an excellent new management language. Yeah, so it doesn’t rhyme or match the song in any...

2010-12-10

790 reads

SQL Saturday New England, #71

by Grant Fritchey

The Scary DBA

I’ve finally got everything together to get the web site going for SQL Saturday #71. The call for speakers is...

2010-12-09

597 reads

So you want to write a book

by Grant Fritchey

The Scary DBA

I had posted a while back on the process of book writing. It was an attempt to educate while scaring...

2010-12-08

700 reads

Review: Idera SQL Doctor

by Grant Fritchey

The Scary DBA

Recently, a co-worker practically slammed me up against the wall, exclaiming “You have to check out this new tool, right...

2010-12-06

2,607 reads

SQL Spackle

by Grant Fritchey

The Scary DBA

I previously mentioned how SQL Server Central was listing ideas for articles, primarily for short, quick, pointed articles that they...

2010-12-02

1,215 reads

Regressions

by Grant Fritchey

The Scary DBA

Hannah Dustin, Upset about Regression
One of the most important take-aways from David Dewitt’s presentation at the PASS Summit was the...

2010-11-30

1,637 reads

FreeCon

by Grant Fritchey

The Scary DBA

I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.
FreeCon is the brain child...

2010-11-24

1,645 reads

Do Foreign Key Constraints Help Performance?

by Grant Fritchey

The Scary DBA

Most people are very aware of the fact that having a foreign key constraint in place on your tables adds...

2010-11-22

1,711 reads

Un-SQL Friday: Branding?

by Grant Fritchey

The Scary DBA

Following in Midnight DBA’s more interesting half new blog fest topic.
My branding? I don’t have a clue. There, I said...

2010-11-19

671 reads

Blogs

The #MS_DatabaseConnector## Role: #SQLNewBlogger

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

By MarlonRibunal

For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...

Read the latest Blogs

Forums

Pay for Performance

By Steve Jones - SSC Editor

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

By Bruno De Grauwe

Has anyone encountered recurring request latency when using Microsoft Access with SQL Server 2025...

The ##MS_DatabaseConnector## User

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The ##MS_DatabaseConnector## User

Visit the forum

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
GO

I then login as Demo and run this:

USE sandbox
go
SELECT CURRENT_USER

What is returned?

See possible answers