Python vs PowerShell DBA Scripting - Python Programming Portal

Python Programming Portal

Python vs PowerShell DBA Scripting

Written by Administrator

Tuesday, 21 August 2007

Ron Dameron recently published an article comparing Python and PowerShell DBA Scripting. He wrote a code in Python and then translated it to PowerShell. He considered few examples like Listing installed hot fixes (DST patch), Checking free space on drives, Finding a database across multiple servers, Checking the version of SQL Server installed.
Python is well known for its easy to read, learn and effective coding features. However, examples and code in this article indicate that task can be completed in PowerShell with fewer lines of code compared to Python.

Windows PowerShell :
Microsoft released PowerShell in the end of last year. Windows PowerShell is a new command line shell and task-based scripting technology.
Windows PowerShell for the first time is included as part of the Windows operating system. Windows PowerShell is one of the numerous manageability enhancements of Windows Server 2008 including the new Server Manager, Server Core, new Event Viewer, new Task Scheduler and new Reliability and Performance Monitor.

Although few examples show that some tasks can be completed in PowerShell with fewer lines of code, Python has many advantages over PowerShell. It good to see Microsoft is inspired from languages like Python and Perl to build PowerShell. PowerShell would certainly help in making life easier for .net developers.

Reference :
>> Comparing Python and PowerShell DBA Scripting
>> Microsoft Windows PowerShell

Related:
>> Python vs Ruby

Add comments:

Comments

You must javascript enabled to use this form

Latest
Scripting Languages See A Cyclic Rise & Fall Python Is The Truly Object Oriented Successor To Perl Dynamic Web Development With The Django Framework

Popular
I'm amazed at how far Python has come Python Interview Questions Incorporating HTML into wxPython-Part2

Copyright 2004 Rightrix Solutions. All rights reserved. All product names are trademarks of their respective companies.
Views expressed at PythonThreads.com reflect the views of the authors alone, and do not necessarily reflect those of PythonThreads.com.