inkosi_dba_dev


Execute on DMVs without user having View Server State

Wanted to share this script to the community just in case anyone out there may be search for a way to allow a hosted customer the ability to query certain DMVs for information without granting them View Server State. There are some other options out there, but this worked better for me after going through […]

5 (1)

2020-09-24

647 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Incorrect syntax near the keyword 'AS'

By basmster

Hi Everyone. I'm hoping someone can take a look at my code here to...

What counts for a DBA: Foresight

By Louis Davidson (@drsql)

Comments posted to this topic are about the item What counts for a DBA:...

SSRS report server installation

By sqlfriend

If we want to install SQL server SSRS service on another server separating  it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers