Solved

Scripting Language - Looking for recomendations

Posted on 2014-12-15
3
55 Views
Last Modified: 2014-12-29
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)
0
Comment
Question by:jamesmetcalf74
3 Comments
 
LVL 35

Accepted Solution

by:
Kimputer earned 167 total points
ID: 40500561
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.
0
 
LVL 23

Assisted Solution

by:NVIT
NVIT earned 167 total points
ID: 40500646
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.
0
 
LVL 11

Assisted Solution

by:zalazar
zalazar earned 166 total points
ID: 40501053
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
https://www.emeditor.com/
If you prefer a free editor, Notepad++ is also a good one.
http://notepad-plus-plus.org/
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
This tutorial will discuss fancy secure registration forms, with AJAX technology support. In this article I assume you already know HTML and some JS. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you mig…
Learn the basics of if, else, and elif statements in Python 2.7. Use "if" statements to test a specified condition.: The structure of an if statement is as follows: (CODE) Use "else" statements to allow the execution of an alternative, if the …
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…

861 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now