Useful links, scripts, tools and best practice for PowerShell
Headers
- Blogs
- Open Source Libraries and Cmdlets
- excelpslib - Excel PowerShell Library (Codeplex)
- Invoke-Parallel - a function that take in a script or scriptblock, and run it against specified objects(s) in parallel (Github)
- PSExcel - a rudimentary PowerShell module for working with Excel via the EPPlus library, with no dependencies on Excel itself (Github)
- ISEScriptingGeek - ISE Add-ons (Github)
- MemoryTools - a set of PowerShell functions for reporting on computer memory utilization and configuration (Github)
- MyUptime - PowerShell module to get uptime, timezone and local time information (Github)
- Rob Sewell PowerShell Functions (Github)
- Adam Bertram PowerShell Scripts (Github)
- PoshRSJob - an alternative to PSjobs with greater performance and less overhead to run commands in the background (Github)
- PSParallel - PowerShell module to invoke scriptblocks in parallel runspaces (Github)
- PSLogging - Easily create and manage logging of events for all of your PowerShell scripts (Github) (by Luca Sturlese)
- Free Videos
- Courses
- SQL Server & Windows Documentation Using Windows PowerShell (by Kendal Vandyke)
- TSQL Code Smells Finder (by Dave Ballantyne)
- Stairway to SQL PowerShell (by Ben Miller)
- SQL Server Health Check Script with Powershell (by Atul Kapoor)
- Universal SQL Server Installation Scripts (by Prakash Heda) (Github)
- Powershell SQL Server Performance Health Check (by Omid Afzalalghom) (Github)
- Performance Analysis of Logs (PAL) Tool (by svenhau and mikelag)
- PSCI - Powershell Continuous Integration (by Objectivity Bespoke Software Specialists) (Github)
- SQLTranscriptase - SQL Server Documentation in Powershell (by Vijay Bandi) (Github)
- SQL Server PowerShell Extensions (SQLPSX) (by Mike Shepard) (Github)
- PowerShell dbatools for SQL Server (by Chrissy LeMaire) (Github)
- Create a Monitoring Server for SQL Server with PowerShell (by Laerte Junior)
- PowerShell SQLPass articles and video
- PowerShell Blog NetNerds
- QS Config (by Derik Hammer)
- Idera 89 Free SQL Server PowerShell Scripts
- Performance Analysis of Logs (PAL) Tool (by Clint Huffman)
- Powershell SQL Server Library (PSSQLLib) (by Sander Stad) (Github)
- Trello Board: Powershell and SQL Client Tools
- PowerUpSQL: A PowerShell Toolkit for Attacking SQL Server (Github)
- PowerShell DBA Reports (Github)
If some procedures or scripts are restricted due to ELUA (or we can not find original author), please email or add issue - we remove/update it immediately. Thanks for understanding and patience.