Cláudio Silva

I am a SQL Server DBA working from SQL2000 to SQL2019. I love using PowerShell to make my life ridiculously easier! I contribute to dbatools PowerShell open-source module.

SQLServerCentral Article

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

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,714 reads

Blogs

Daily Coping 19 Oct 2021

By

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

Commenting a branching IF-THEN-ELSE.

By

I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an...

External Temp Tables Preventing Plan Reuse in Stored Procedures

By

Here’s an interesting issue that recently came up. We were seeing very high compilations...

Read the latest Blogs

Forums

Migrate the SSIS Catalog in Just a Few Clicks

By Kunal Rathi

Comments posted to this topic are about the item Migrate the SSIS Catalog in...

Grouping , time difference in minutes

By gjoelson 29755

Hi, I'm trying to query the amount of minutes a column value stays below...

Reset of a single column in sys.dm_exec_query_stats

By obouda

Dear friends, I have a custom performance monitor based on snapshotting sys.dm_exec_query_stats, and now...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers