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 […]

2020-09-24

283 reads

Blogs

VMworld 2020 – Top 10 Database Sessions (Part 1)

By

Whether you are a SQL Server Database Administrator, Infrastructure Architect, or any other member...

Daily Coping 24 Sep 2020

By

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

VMworld 2020 SQL Server session preview

By

Join me, David Klee, Microsoft Data Platform MVP and VMware vExpert, for a preview...

Read the latest Blogs

Forums

Always On - tips for running large transactions

By NicHopper

Hi all, I wanted to get a second opinion on something, this weekend I...

Encrypted column copy

By IT researcher

I am using SQL Server 2008 R2. I have encrypted some of the columns...

SQL query error help

By rocky_498

Hi Guys, I have a table, around 320 fields. I am trying to use...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers