Solved

Powershell for .NET and SQL developer

Posted on 2014-01-27
3
334 Views
Last Modified: 2014-01-31
Though I'm working in .NET application for long time I never use powershell in my applicatinos. I would like to know answers for below questions. Please clarify me.


What is powershell?  Where practically I could use it?

 As a .NET and SQL developer what are the frequently used commands I should know of Powershell?
0
Comment
Question by:Easwaran Paramasivam
  • 2
3 Comments
 
LVL 23

Expert Comment

by:Jens Fiederer
ID: 39812732
Powershell is essentially a more powerful replacement for COMMAND.COM that plays nicely with the Windows architecture.

It would normally be used mostly by administrators -- I have VERY rarely used it as a developer -- but as a developer you might be asked to write "cmdlets" for Powershell (unlike regular executables, these can be loaded and executed in the actual Powershell process without starting up a new process).
0
 
LVL 16

Author Comment

by:Easwaran Paramasivam
ID: 39814010
Thanks. Could you please share the basic commands for a .NET and SQL developers should be aware or know?
0
 
LVL 23

Accepted Solution

by:
Jens Fiederer earned 500 total points
ID: 39814132
You can list all the commands with simply
    get-command

Pretty much all the real basics are what you would expect -- you could do "cd", "dir", "pwd" just like in the regular shell.   You can do variable assignments like
$a = 4
or
$b = dir
and then
write $b (to see the directory you stored)
or do logic like


if ( $a -eq 4) { write $b }

I'd recommend going through an introduction like
http://technet.microsoft.com/en-us/library/hh857337.aspx
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question