PowerShell –SQL Automate Tutorial-2

Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

Scenario: PS is most powerful and very helpful tool for windows and SQL server administrator and automation. So its today need to learn at least basic of some PS cmdlets.

Note:- Please click here to get 1st part of PowerShell –SQL Automate tutorial.


In today’s tutorial, we will learn about help cmdlet of PowerShell.

Update-Help
After the help files are installed, you can use the Get-Help cmdlet to display the help topics. You can also use the Update-Help cmdlet to download updated help files so that your local help files are always up-to-date.

InterServer Web Hosting and VPS

GET-HELP
The Get-Help cmdlet displays help at the command line from content in
help files on your computer. Without help files, Get-Help displays basic
help about cmdlets and functions. You can also use Get-Help to display
online help for cmdlets and functions.

To get help for a cmdlet, type:

    Get-Help <cmdlet-name>

You can also do online search for the cmdlet using commnad below

Get-Help <cmdlet-name> -Online

Load Powershell Module:

You can load required module in Powershell for example here we will see how to load module for SQL server so that once it is loaded, we can use these modules to administrating SQL server.

Before this, lets see list of available module for PowerShell.

Install the SQL Server PowerShell module:

Please follow Microsoft Link for installing SQL server PowerShell Module.

Happy Learning!


Before you start some work, always ask yourself three questions – Why am I doing it, What the results might be and Will I be successful. Only when you think deeply and find satisfactory answers to these questions, go ahead.

Chanakya

One thought on “PowerShell –SQL Automate Tutorial-2

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s