SQL Server Performance Forum – Threads Archive

How VB script can help DBAs to make their job easy

How VB script can help DBAs to make their jobs easier?
What kind of automation jobs can be done using vbscript that cannot be done with
TSQL.
Can you suggest me some good links which can be benificial for DBAs to learn Vb script

There are very many uses for VB or any other programming language with SQL.
It may not replace what can be done in SQL, but it can enhance or put together things currently available. I dont necessarily think this is good reason for DBAs to learn VB script. I think that is more a developer function. For example, most tools you can buy or download to help with sql monitoring, scripting etc, could be done with VB. A dba does not need these tools to do his/her job, although they can make it easier for the DBA to do the job. But the creation of the tools is not a DBA function. In almost all organiztions there is already more work than the DBA(s) can handle, to add to that the requirement that the DBA also do development would likely take away from the necessary DBA functions. However, all that said, I dont think it would hurt for DBAs to have some development training/experience, but it doesnt necessarily have to be VB. Why are you trying to find this? Chris

Actually I have heard from some guys saying that VB script is essential to be a good DBA <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

Agreed with Cris, I don’t think it is an essentil for a DBA. But it is a "nice to have" tool rather than "must have" tool. I know many DBA with out programming ability. but there are doing good job But as Cris said it will not hurt you <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by aaronsandy Actually I have heard from some guys saying that VB script is essential to be a good DBA <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> <hr height="1" noshade id="quote"></blockquote id="quote">

knowing vbscript can help u to point out what the developers have done in their code. it also helps u to distinguish between the uses of sql and vb script.

Firm grasp of concepts as it relates to additional options of SQL Server and other programming lanugagues will help DBA to know the process indepth that is working against the database. Willingness to learn new skills will return good results. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

It depends on the goal. Is your goal to be able to troubleshoot other programmers VBscript code that access SQL Server in some inefficient way or is the goal to build administrative scripts? If it’s for troubleshooting then any language that is used in your environments is good to know. And if it’s for administrative tools/scripts/tasks then any language you are comfortable with will work. VBscript happens to be one of the more common in both cases though but if Perl is your thing then I highly recommend a book by Linchi Shea: Real World SQL Server Administration with Perl
http://www.apress.com/book/bookDisplay.html?bID=171

]]>