PowerShell KIT

Useful links, scripts, tools and best practice for PowerShell

Table of Contents

• Repo Folders and Fles
• PowerShell Web Resources
• PowerShell and SQL Server
• License

Repo Folders and Files

• PowerShell Tools
• Articles
• Scripts

PowerShell Web Resources

• Blogs
  • SS64.com PowerShell
  • Adminarsenal.com PowerShell
  • PowerShell.org Articles
  • Simple Talk PowerShell
  • SQLServerCentral.com PowerShell
  • Hey, Scripting Guy! Blog
  • Microsoft Script Center
• 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)
  • PSScriptAnalyzer - PSScriptAnalyzer is a static code checker for Windows PowerShell modules and scripts (Github)
• Free Videos
  • Jeff Hicks YouTube Channel
  • Don Jones YouTube Channel
• Courses
  • Pluralsight PowerShell Courses Paid

⬆ back to top

PowerShell and SQL Server

• 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)

⬆ back to top

License

MIT

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.