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
In this article you will learn how to use BCP for SQL Server on Linux to export and import data using the BCP command line utility.
2020-01-30
2,617 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