Scripting Languages

  • I guess I'm trying to figure out where to spend my time going forward. Please add to the list as needed

  • Robert.Sterbal (6/26/2012)


    I guess I'm trying to figure out where to spend my time going forward. Please add to the list as needed

    I guess that depends on what you want to do. This laundry list is all over the place. What do you want to focus on?

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Professionally I help manage 500+ small SQL Server installations. We have 5 to 100 devices per install. I'm trying to automate manual processes and collect data for verification and troubleshooting

  • Robert.Sterbal (6/26/2012)


    Professionally I help manage 500+ small SQL Server installations. We have 5 to 100 devices per install. I'm trying to automate manual processes and collect data for verification and troubleshooting

    Well if that is what you want to continue doing and want to focus on then you could start eliminating stuff from your list. This is not likely to need javascript, Ruby, PHP, Perl, vbscript, Python or BASH. That is pretty much the whole list except Powershell. Now if you are wanting to branch out professionally then you would have to decide what that might be.

    _______________________________________________________________

    Need help? Help us help you.

    Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

    Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

    Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
    Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
    Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
    Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

  • Sean Lange (6/26/2012)


    Robert.Sterbal (6/26/2012)


    I guess I'm trying to figure out where to spend my time going forward. Please add to the list as needed

    I guess that depends on what you want to do. This laundry list is all over the place. What do you want to focus on?

    Then I wouuld probably look at PowerShell.

  • Robert.Sterbal (6/26/2012)


    I guess I'm trying to figure out where to spend my time going forward. Please add to the list as needed

    My personal feeling is that there are zealots of all makes. Asking which ones people use is likely going to get you all sorts of different answers.

    the current "rage" is with PowerShell. That one might actually be around for awhile. Of course, you have to keep it updated like anything else.

    My favorite scripting tool of all time is a combination of T-SQL and xp_CmdShell to gert to either DOS or PowerShell. (see what I mean?)

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Thanks for the input.

    I'm definitely going to do a deep dive on Powershell, as it is very relevant to my current job.

    On a more personal note I'm looking to learn a scripting language that I can deploy on free operating systems (BSD, Linux, etc) so I can run my easily partitioned scripts on multiple machines at the same time. I do a lot of photography and sending the ten or twenty thousand pictures to the appropriate service (facebook, flickr, dropbox, box.net to name a few) via GUI tools is really not practical. Some combination of php (or some other language) and mySQL (or some other free DB) seems like the first platform to investigate.

  • On a more personal note I'm looking to learn a scripting language that I can deploy on free operating systems (BSD, Linux, etc) so I can run my easily partitioned scripts on multiple machines at the same time.

    Python is the one tool that I've used on Windows, Mac and Linux that is both easy to learn, well supported and has a huge number of examples, tools, and APIs that are useful.

  • By the way... I put javascript on the list BEFORE I read this...

    http://www.ewherry.com/2012/06/the-recruiter-honeypot/

    The craziness will probably have died down before I ever learn it.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply