PowerShell

SQLServerCentral Article

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

Technical Article

Post SQL Server Installation steps with PowerShell

  • Script

I bet, each DBA would change some settings after the SQL Server installation as per their company standard . I wrote this PowerShell script for one of my client who has below standards: Port should be 1433, static Disable SQL telemetry* & SQLWriter services Change recovery model to FUll for all databases except tempdb and […]

5 (2)

2020-07-02 (first published: )

1,656 reads

Blogs

Daily Coping 26 Nov 2021

By

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

Daily Coping 25 Nov 2021

By

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

3-2-1 Backup Rule for Data Protection in SQL – What Is It & Is It Relevant?

By

In the event of a disaster leading to database unavailability, restoring backups is the...

Read the latest Blogs

Forums

Trouble connecting MYSQL in SSIS

By yrstruly

I connect to MYSQL in SSIS with MYSQL data provider. I am getting the...

Which version of SQL should I use?

By curtisharrington

I see SQL as a query language, used to store and retrieve data. However,...

It's All About the Gratitude

By Grant Fritchey

Comments posted to this topic are about the item It's All About the Gratitude

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers