• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 69
  • Last Modified:

Scripting Language - Looking for recomendations

I am in the windows world and new to scripting.  I am mainly a dba with some sys admin related duties.
What would be the best scripting language to start using.  I would like to be able to extract data from MSSQL
and pull data from active directory.  also automate tasks.

I would need to know.
scripting language.
software for a beginner if needed (free is a big plus)
3 Solutions
VBscript is free. So is Powershell.
For readability reasons, I always use VBscript. The syntax of Powershell makes it a bit harder to read.
As such, there's no software, just use a good text editor.
Since you're a DBA... Microsoft's LogParser.  It's FREE. Not a scripting language but a utility to help your scripting.

It lets you query text-based data like log files, XML files and CSV files, and key data sources of the OS like the Event Log, Registry, file system, and Active Directory.

I don't know if it lets you extract SQL table data. However, per http://technet.microsoft.com/en-us/scriptcenter/dd919274.aspx, it looks like it may:

.sql files can now take parameters, e.g. "logparser -file:myquery.sql?param1=value1+param2=value2"

It also has a COM interface so you can call it from your scripts.
I would (also) recommend PowerShell or VBScript.
With PowerShell you have more options and Microsoft provides good application support for SQL and Active Directory.
VBScript has the advantage that it runs faster and does not use much memory.
With VBScript it's also not necessary to install additional modules like PowerShell does need for easier support with SQL and AD. I like to use both. According to Microsoft, PowerShell is the preferred language to use.

A good Windows editor is EmEditor
If you prefer a free editor, Notepad++ is also a good one.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now