Powershell FAQ for the SQL Server DBA

26 August,2013 by Jack Vamvas

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


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Powershell FAQ for the SQL Server DBA


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer