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,671 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

23,272 reads

Blogs

Daily Coping 24 Sept 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Starting a career in cloud computing

By WojinRina

Hello, As the title says, might you have any advice to starting a career...

AWS S3 Questions

By lucasPeni

Hi all, Just starting out with AWS and had a few questions.. What are...

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers