Powershell Day 1

Day 1 Introduction to Powershell

I got inspired by great people like Paul Randal and Glenn Berry and decided to write a blog every day for a month about Powershell, I am learning Powershell, lets see.

PowerShell is the new command-line/scripting environment. The purpose of this is to automate the routine for Microsoft windows any task.

When Microsoft was increasing in enterprise and need to go beyond GUI for enterprise plateform for that it require simmiar programming like UNIX shell programming. As .net and C# are GUI programming which is more of user interface not command-line friendly and existing windows command line was not enough, so Powershell is build . Jeffrey Snover, Bruce Payette, James Truher  are the founding members of Powershell.

With Powershell you can do everything  and manage windows. We can use  .NET, COM (Component Object Model),  ADSI(active directory) and WMI(Windows Management Infrasturcture) objects in Powershell. PowerShell v1.0, released in late 2006,

Powershell is free tool, Powershell 2 is build it and is available with windows 2008 R2

For windows shell, Powershell is the utility.

Run “Powershell” with cmd will get you to Powershell prompt.


Powershell c:\>

For Sql server Powershell utility run “SQLPS” command. Which will be free with sql server 2008 onwords


Ps sqlserver:\>

You can use sqlps to do the following:

  • Interactively run PowerShell commands.
  • Run PowerShell script files.
  • Run SQL Server cmdlets.
  • Use the SQL Server provider paths to navigate through the hierarchy of SQL Server objects


This entry was posted in Powershell and tagged . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.