Scripting

Execute on DMVs without user having View Server State

  • Script

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

501 reads

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • Article

Being able to get information and save it on a Excel as a report can be a common and tedious task. What if we could join dbatools and ImportExcel PorwerShell modules to accomplish this in a easier and fast way? We will see how to export roles and its' member and save that info on a multi spreadsheet Excel file with handy tables ready to be explored.

5 (2)

2020-06-30

4,161 reads

Blogs

The First Data Saturday is Tomorrow

By

Data Saturday #2 – Guatemala is tomorrow. This is the first event on the...

Daily Coping 22 Jan 2021

By

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

Daily Coping 21 Jan 2021

By

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

Read the latest Blogs

Forums

Grant user access to view database only

By sql_Reporter

Hi I need to grant a user access to a DB on the server...

Need to strip off the beginning of a field in SELECT statement

By tim8w

I have this table that unfortunately has spaces in the field, which I am...

Aliasing an instance name for remote connections

By Brandie Tarvin

It's been a long time since I set up a 2012 server. We have...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers