dbatools

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)

2020-06-30

4,062 reads

Exporting Data with PowerShell

  • Article

Recently I had the need to help someone download some data from SQL Server as a part of an automated process. In this case, the person wanted to use PowerShell (PoSh), since they were performing a few other actions with PoSh as well. This article is a short tutorial on exporting data from SQL Server […]

5 (8)

2020-01-02

12,008 reads

Blogs

Requesting Comments on the SQLOrlando Operations Manual

By

For the past couple weeks I’ve been trying to capture a lot of ideas...

Ignoring Comments in SQL Compare

By

Recently I had a client that wanted to know how they could use SQL...

PASS SQLSaturday’s I will be speaking at

By

I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that...

Read the latest Blogs

Forums

vipcontentonline

By vipcontentonline

a hit freelancers swear by exercises — washing your face, putting on real garments...

Rules in PostgreSQL

By sabyda

Comments posted to this topic are about the item Rules in PostgreSQL

Ordering with NULL

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Ordering with NULL

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers