Archive for the ‘free resources’ Category
Send Twitter Update with VBScript
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
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.
http://www.mediafire.com/file/ejnazzdwtwi/SQLPromptSetup.msi
Great Free Icons with no usage restrictions
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.



