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

682 reads

Blogs

Getting Started with Power Virtual Agents

By

Power Virtual Agents empowers subject matter experts to build intelligent conversational bots, using a...

How SQL Server stores data types: DATETIMEOFFSET

By

If you’d like to check out the previous instalment in this series on storing...

Daily Coping 16 Jun 2021

By

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

Read the latest Blogs

Forums

Inventory toolkit issues

By mtz676

Anybody has run into MAPS assessment toolkit installation issues for sql server 2019/2017.Also maps...

Have an emergency. Prod is down.

By ALearningDBA

Our prod server is down. I was applying a security patch on our secondary...

Help with Boolean check box combinations

By Hogie503

Hi SQL Experts, I have a Store Procedure with snippets of code listed below....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers