Solved

Scripting Language - Looking for recomendations

Posted on 2014-12-15
3
58 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
issue with beginner powershell script. 5 75
Where do I learn ES6? 3 81
Need help Creating PowerShell Script 4 46
.dn property wont validate - Powershell 2 23
In this tutorial I will focus on how to use WhizBase as a tool for sending ICQ messages to ICQ. Here I will use a new technology in WhizBase, published in WhizBase 5.1 version. In this tutorial I will use 3 files, pager.wbsp for the processing, e…
A quick Powershell script I wrote to find old program installations and check versions of a specific file across the network.
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 …
The viewer will learn how to count occurrences of each item in an array.

730 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