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

Another Execution Plan… In the Cloud!

by Grant Fritchey

The Scary DBA

A couple of weeks ago I posted about how different execution plans look when using the Azure Management Portal. I...

2012-08-23 (first published: 2012-08-20)

1,910 reads

24 Hours of PASS, Fall 2012

by Grant Fritchey

The Scary DBA

It’s time to get your learn on again. The schedule for the Fall 24 Hours of PASS is up and...

2012-08-22

708 reads

Coming to Your Town

by Grant Fritchey

The Scary DBA

I can’t sing and I can’t play and I left the young generation behind a while ago, but I’m still...

2012-08-16

1,176 reads

Being Right, the Other Side

by Grant Fritchey

The Scary DBA

I read an excellent article by Camille Fournier about the importance of recognizing that being right is not the only...

2012-08-15

854 reads

Execution Plans … In the Cloud!

by Grant Fritchey

The Scary DBA

If you’re moving to a fully-fledged SQL database as part of Azure you may never even touch SQL Server Management...

2012-08-10 (first published: 2012-08-01)

2,739 reads

SQL In The City: London 2012, Recap

by Grant Fritchey

The Scary DBA

Wow!
How’s that for a recap?
The concept for the SQL in the City events is pretty simple. Put on a free...

2012-07-17 (first published: 2012-07-16)

2,093 reads

Does Encryption Affect Seeing Statements in Deadlock Graphs?

by Grant Fritchey

The Scary DBA

Good question. I don’t have a clue. So let’s set up a test. I’ll create this stored procedure:
CREATE PROCEDURE DL2e
...

2012-07-03 (first published: 2012-06-25)

2,277 reads

Querying Information from the Plan Cache, Simplified

by Grant Fritchey

The Scary DBA

One of the great things about the Dynamic Management Objects (DMOs) that expose the information in plan cache is that,...

2012-07-02

1,508 reads

The New Phone Book Is Here!

by Grant Fritchey

The Scary DBA

I can’t help it. I get really terribly excited when I publish a book. Maybe it should be old hat....

2012-06-27

1,614 reads

Problems with my new book

by Grant Fritchey

The Scary DBA

First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...

2012-06-26

839 reads

Blogs

Wait… Could This Be the End of Index Maintenance?

By Monica Rathbun

While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...

Copilot on the Power BI Report Canvas vs. Modern Report Builder

(This is the second post in a three-part series on how AI is changing...

The #MS_DatabaseConnector## Role: #SQLNewBlogger

I had seen these roles in various instances, but never dug into the new...

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