Scripting

Article

Sometimes there is a need to find if a string value exists in any column in your table. This script will help you find all occurrences in all columns in the table.

2020-09-25

Execute on DMVs without user having View Server State

by inkosi_dba_dev

SQLServerCentral

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

Discuss

Recover database encrypted modules code with dbatools

by Cláudio Silva

SQLServerCentral

Article

If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

5 (1)

2020-08-18

2,095 reads

Discuss

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

by Cláudio Silva

SQLServerCentral

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.