Powershell Frequently asked questions .   Contact me for any Powershell questions or SQL Server issues

Explore this Powershell FAQ or search sqlserver-dba.com for hundreds of answers to common Powershell problems for DBAs.

1)     What are typical tasks Powershell can assist the DBA?

SQL Server Administration  - example Find TCP Port used by SQL Server

Server Administration – example List Event Log Messages

System Monitoring and Performance  example Number of physical processors with Powershell – number of cores

Security Management – example Report Login failed messages

Reporting - example Create an Excel Chart

Utilities - Connect to Linux

2)     Where can I get a list of free Powershell Scripts to use?

There are plenty of Powershell scripts available in forums and blogs. There is an extensive list of  scripts on Powershell Scripts

3)     I want to learn Powershell, How can I start?

 The key tool for learning Powershell is to discover some key cmdlets that will act as a gateway to deeper learning of Powershell . Read  Expand your Powershell mind – Three key cmdlets