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.

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

Blogs

Daily Coping 16 Sep 2021

By

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

#PowershellBasics: Running a .sql script file.

By

As with all programming tasks there are a number of ways to do something,...

sp_RestoreScript 1.9 – a dirty little bug squished!

By

It look like we had a little bug in sp_RestoreScript that was putting a...

Read the latest Blogs

Forums

Multiple instance on SQL server 2017 with VS 2019.... ERROR 26 on Visual Studio

By Charitto95

I have a system with multiple clients and each one in different virtual machines,...

SSRS 2017 How to check which SSL cert is bound

By webrunner

Hello experts, I need to update the SSL certificate on our SSRS 2017 instance....

Rebuild index

By Chitown

I have a table which is partitioned (Total 10). The table is 1.6 TB...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers