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

Blogs

Flying Halfway Around the World to Australia

By

I leave tonight for Australia. I was in London 3 days ago, so this...

Dealing with Change – Two Resources

By

As I look at the state of information technology today, I see one constant:...

Cloud Databases Made Simple: Creating Your First AWS RDS Instance

By

I recently started full time learning of Amazon Web Services (AWS). I found that...

Read the latest Blogs

Forums

insert duplicate records with new timestamp

By Tara-1044200

how can i insert records from a transaction table into a transaction table with...

Performance benchmarking tools for SQL Server

By MichaelT

Are there any performance test tools that can check the performance of a SQL...

Backing up and Restoring a 3 terabyte database takes over 5 hours

By ericwenger1

I have a 3 terabyte database that is taking over 5 hours to backup...

Visit the forum

Question of the Day

Using Table Hints in a Query

How many table hints can I include in a query?  

See possible answers