Solved

Scripting Language - Looking for recomendations

Posted on 2014-12-15
3
59 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 24

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 12

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

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

Introduction This tutorial will give you a fast look what you can do with WhizBase. I expect you already know how to work with HTML at least, and that you understand the basics of the internet and how the internet works. WhizBase is a server-s…
This tutorial will discuss the log-in process using WhizBase. In this article I assume you already know HTML. I will write the code using WhizBase Server Pages, so you need to know some basics in WBSP (you might look at some of my other articles abo…
Learn the basics of strings in Python: declaration, operations, indices, and slicing. Strings are declared with quotations; for example: s = "string": Strings are immutable.: Strings may be concatenated or multiplied using the addition and multiplic…
The viewer will learn how to count occurrences of each item in an array.

705 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