Author: Chrissy LeMaire
Original link: https://github.com/ctrlbold/dbatools/blob/master/Functions/CsvSqlimport.ps1
Description: Efficiently imports very large (and small) CSV files into SQL Server using only the .NET Framework and PowerShell
Author: Bill Graziano
Original link: http://www.sqlteam.com/article/fast-csv-import-in-powershell-to-sql-server
Description: Fast export sql query to csv file
Author: Sander Stad
Original link: https://www.simple-talk.com/sql/database-administration/documenting-sql-server-with-powershell/
Description: Get machine information like memory, CPU and disk configuration and output it to Excel
Author: Kenneth Fisher
Original link: http://sqlstudies.com/2016/02/24/powershell-script-to-create-multiple-sql-server-connections/
Description: This script creates a number of connections ($MaxConnections) to a SQL Server instance ($Server) that connect to a random database and exist/run for a certain amount of time ($WaitType/$WaitTime)
Author: Chrissy LeMaire
Original link: https://gallery.technet.microsoft.com/scriptcenter/Reset-SQL-SA-Password-15fb488d
Description: This function allows administrators to regain access to local or remote SQL Servers by either resetting the sa password, adding sysadmin role to existing login, or adding a new login (SQL or Windows) and granting it sysadmin privileges.
Author: Thomas LaRock
Original link: http://thomaslarock.com/2016/03/sql-server-linked-server-connection-test
Description: Test the connection for each linked server defined in a SQL Server
Author: Rob Sewell
Original link: https://sqldbawithabeard.com/2016/03/28/using-powershell-to-set-extended-events-sessions-to-autostart/#comments
Sets Extended Events Sessions to Auto-Start and starts it if it is not running
Author: Derik Hammer
Original link: http://www.sqlshack.com/backup-testing-powershell-part-1-test/
Description: Script will reach out to a sql server central management server, derive a server list and database backup list. Then asynchronously restore them to a test server followed by integrity checks.
Author: Chris Bell
Original link: https://wateroxconsulting.com/archives/sql-server-access/
Description: This script can be used to step through the various levels of security on each of your SQL Server instances