crribs.com

the blog of brad shultz, systems design, RETS development, ETL, scripting, and windows task scheduler stuff

Archive for the ‘free resources’ Category

Send Twitter Update with VBScript

without comments

I was thinking of using Twitter as a kind of ‘syslog’ for all of the scripts we have running (via the task scheduler) all over the enterprise. There is no centralized logging implemented. Ive made some attempts via text files, sql server, the event log, etc., but nothing has taken hold as – easy to implement, universal, and straightforward. This is the visual basic script I came up with to upload the messages.



'**************************************************************************
'* Scriptname: PostToTwitterSimple.vbs
'* TWITTER STATUS UPDATE
'* Brad Shultz - crribs.com
'**************************************************************************
strUsername = "username" 'Username
strPassword = "password" 'Password
strMessage = "This is a test twitter update from a vbscript." 'Message for twitter

strTwitterXMLResponse = SendToTwitter(strMessage, strUsername, strPassword)

'postback what you sent to twitter
MsgBox strTwitterXMLResponse, VbOkOnly, "TWITTER STATUS UPDATE"

Function SendToTwitter(strMessage, strUsername, strPassword)
Set objHTTP = CreateObject("Microsoft.XMLHTTP")
objHTTP.open "POST", "http://twitter.com/statuses/update.xml", false, strUsername, strPassword
objHTTP.send "status=" & strMessage
SendToTwitter = objHTTP.responseText
Set objHTTP = nothing
End Function

Red Gate SQL Prompt Freeware – Intellisense for SQL Server Tools

without comments

In the spirit of sharing, and noticing that Red Gate Software’s SQL Prompt is up to $295 dollars for a single license, I’d like to offer this freeware/beta that Red Gate released to the public right after it acquired the SQL Prompt software from a company (who was giving it away for free).  This application brings intellisense/code completion to Sql Server- Management Studio, Query Analyzer, Editpad (I think), etc.  They realized that they were going to have to make substantial changes to the codebase in order to optimize it to their standards; so in the meantime, the current version of SQL Prompt was offered up for free.  I havent been able to find this anywhere else, so- here it is:  the original freeware version of Red Gate Software’s SQL Prompt.  Its a beta type version, but works very well as far as I’ve used it.  It requires no license because it was released as freeware.  Download it here.

red gate software's sql prompt

Red Gate Software's SQL Prompt - the freeware edition; Intellisense for SQL Server!!!

http://www.mediafire.com/file/ejnazzdwtwi/SQLPromptSetup.msi

Great Free Icons with no usage restrictions

without comments

www.iconpot.com

Tons of excellent free icons, usable in personal/commercial apps, websites, etc. and you dont have to provide back-links or credit to the author.  Was searching and searching for icons for my scheduled task management application and found the best icons here.  Awesome resource.

Written by bshultz

March 26th, 2009 at 12:18 am

Posted in free resources

Tagged with , ,