Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Pioneering with PowerShell

By Phil Factor,

 One of Brent Ozar's observations following the recent TechEd North America conference was that "there's a huge demand for good PowerShell basic training". Given Microsoft's strong conservatism, it has been surprising to see radical languages such as PowerShell and F# appear, and gratifying to see so many IT professionals realise that in PowerShell, we have, at last, the fabled 'glue' to allow applications, COM processes, .NET assemblies  and frameworks to cooperate in producing workflows.

For example, several pioneering Database Developers have used PowerShell to automate the database deployment process; Exchange Admins have brought the complexity of the maintenance tasks under control, and PowerShell is now established as the natural way of scripting Windows admin and monitoring tasks. Exchange and SQL Server have pioneered the use of PowerShell's hosting mechanism to expose their management interface as a series of Cmdlets, and other servers are following suit with PowerShell interfaces.

PowerShell has slipped into its current role through pretending to be little more than a DOS Batch-processing replacement or 'task-automation framework'. In fact, it is a language that outsmarts Perl and Python and Ruby. PowerShell's designers were veterans of the previous generation of scripting language, and were able to leapfrog much of the spadework by using what was already there in .NET. Like Perl, PowerShell allows a number of different approaches to achieving an aim, and enables the command-line-jockeys to write terse scripts as accessible as Klingon, whilst allowing perfectly conventional and maintainable language-conventions, or clever object-oriented scripting.

Although PowerShell was limited in being slow to execute, it is now being re-implemented to use the DLR, which means that scripts and functions are now no longer interpreted every time they are run, but are compiled, executed, and cached.

For Windows to have a powerful scripting tool, better than the UNIX equivalents, is somewhat of a novelty. It is going to continue to cause radical changes to Windows server applications, and the tools we use to administer them. Even the desktop should no longer be immune to change, and we expect to see some imaginative ways of creating applications that can be extended via PowerShell. Who needs the unlovely VBScript anymore?

Phil Factor.

Total article views: 170 | Views in the last 30 days: 1
Related Articles

Scripting Language in DTS

Scripting Language in DTS


Powershell script to allow you to login to any instance or sqlserver

A small powershell script to grep your instances and log you in to sql.


PowerShell – Program List – 32/64 Bit – Local/Remote Machies

This Powershell script list all the installed application on both 32 and 64 bit applications, partic...


Scripting SQL Agents Jobs using Powershell

The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job....


Can i use any other language in SSIS Script task ?

Can i use any other language in SSIS Script task ?

database weekly    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones