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

5,051 reads

Blogs

Cloud Formations – A New MVP Led Training Initiative

By

Hello, data friends! Let me spread a few words about the new MVP led...

Daily Coping 20 May 2020

By

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

Daily Coping 19 May 2022

By

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

Read the latest Blogs

Forums

Columnstore Index Limits in SQL Server 2019

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Columnstore Index Limits in SQL...

How to use Images in Power BI Report Builder

By Daniel Calbimonte

Comments posted to this topic are about the item How to use Images in...

How to handle sticks on column country1 and country2 columns ?

By ahmed_elbarbary.2010

I work on sql server 2017 i have table data as below i need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers