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

Blogs

A Live Conference Experience at Data Minds Connect 2021

By

Last week I was privileged to attend a live conference in Belgium. dataMinds Connect...

Daily Coping 25 Oct 2021

By

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

A New Form of Address: Mx

By

When I was presenting at the dataMinds Connect conference, I called on someone in...

Read the latest Blogs

Forums

Need advice with backup plan and transaction log file

By dubem1-878067

I am missing something I guess.  Here's our backup Plan Full backup weekly Differential...

cannot generate SSPI context

By premkuttan

We have one user who face this issue while connecting to SQL server ''Cannot...

Database Corruption - LOB

By database diva

Hello, I have recently inherited a SQL 2012 database (no backups available), running in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

A Simple Error

See possible answers