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

15,187 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

Question about deadlock

By sqlenthu 89358

Hello DBAs, I am facing some deadlock issue and after investigation from trace flag...

Get Date Based on TimeOffSet and Day

By Rock

Team I have a table which carries the below columns and values TimeOffSet >...

MSDTC and Always On AG

By VastSQL

Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers