roles

SQLServerCentral Article

Generate Role Member Reports using dbatools and the ImportExcel PowerShell modules

  • 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.

5 (2)

You rated this post out of 5. Change rating

2020-06-30

5,683 reads

Blogs

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks

By

I’ve been using Azure SQL Database for quite some while and have set up...

Create and Verify Microsoft Fabric Capacity

By

From June 1, 2023, Microsoft Fabric (preview) capacities are available via the Azure portal....

Read the latest Blogs

Forums

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

In SQL Server database, there is a table InventDim with two indexes: Idx1 with...

how to determine if we can delete the index can be removed

By 892717952

The table InventDim has some indexes, we create one index idx1 which has index...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Refresh Limits

See possible answers