Permissions

Technical Article

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

5 (1)

You rated this post out of 5. Change rating

2020-09-24

1,886 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2020-06-30

6,202 reads

Blogs

AI World

By

this month is the big month and a month to remember their are so...

Using Flyway with Feature Flags

By

There is a nice article at Harness.io on their use of feature flags and...

Microsoft Build event announcements on Fabric

By

There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...

Read the latest Blogs

Forums

Calculating moving moving averages for different ranges in one query

By Sezam

I have this query, which is gives result I want (may be not, i...

Monitoring if something is deleted in DB

By Martass

Hello, I have long-term task, which came one year ago, and just now I...

LOGON Trigger Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item LOGON Trigger Count

Visit the forum

Question of the Day

LOGON Trigger Count

I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?

See possible answers