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.
2020-06-30
3,340 reads
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 […]
2020-01-02
7,036 reads
If you have a list of striped backup files, how can you find the latest backup set? Steve Jones uses dbatools and PowerShell to automate this process.
2019-10-03
1,559 reads
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
I recently needed to ensure that a Power BI imported dataset would be refreshed...
Hi all, I need to migrate a SQL 2012 database that has a few...
Comments posted to this topic are about the item Controlling Intelligent Query Processing Features
I have this function, but I wanted to pass a table so as to...
Ask SSC