Cláudio Silva

I work as Data Platform Architect.
I love performance tuning and I'm also a PowerShell lover who automates any process that needs to be done more than a couple of times.
I contribute to open-source PowerShell modules such as dbatools and dbachecks.

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)

You rated this post out of 5. Change rating

2020-06-30

6,138 reads

Blog Post

TSQL Tuesday

This month’s (#127) T-SQL Tuesday is brought by Kenneth Fisher (B | T) and he asked about Non SQL Tips and tricks. As a Windows user I know there...

2020-06-09

3 reads

Blogs

Elastic Jobs for Azure SQL DB

By

I know if you are a SQL Server DBA using Azure SQL DB, you’ve...

Undercover Catalogue 0.4.4 Released – Database Last Accessed Time and NEW Snapshot Module

By

Full documentation on the Undercover Catalogue can be found HERE It’s been a while...

Familiar Sights

By

Yesterday was a long day in London. I arrived late in the am, and...

Read the latest Blogs

Forums

Find the problematic Sql Query Caused Application Crash

By RCRock

Hi, Is there anyway I can find out the sql script ran on a...

Full vs. Incremental Loads – Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Full vs. Incremental Loads –...

Restoring the Resource Database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Restoring the Resource Database

Visit the forum

Question of the Day

Restoring the Resource Database

How can I restore a version of the Resource Database in SQL Server 2022?

See possible answers