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)

You rated this post out of 5. Change rating

2020-06-30

5,938 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

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

Need help on query - DATEDIFF

By Adelia

Hello, I want to have value Month ago Year ago So far, I've this...

The Fake Speakers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Fake Speakers

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

By Erin Dempster

Comments posted to this topic are about the item Stairway to Database DevOps Level...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers