Using SQL and want to know how many times 'http' appears in a string using about one line of code? Find out by creatively using the replace() function.
Declare @myStr varchar(1500), @countStr varchar(100) Set @myStr = 'https://www.buydrugshere.com go here! https://www.onlinemortage.com right there!' Set @countStr = …
Read More- Last night I got locked out of my Compaq DL360's iLO. I searched the web to find how to reset the Administrator password and read that, for the most part, I'd have to be at the console. Bah! My servers are in San Jose and I'm up here in San Francisco, I didn't want to make a trip just to reset my passwords. I continued …
Read More I used the following code a while back as part of a solution to automate the banning of spammers via their IP address.
'Here, we will pretend this is an imported list Dim XMLarr(1) XMLarr(0) = "65.19.238.21" XMLarr(1) = "198.31.175.100"
Set objIIS = GetObject("IIS://localhost/w3svc") …
Read MoreThis script should work right out of the box..
<% Call getNews(10)
Sub getNEWS(howManyResults) myRSSfile = "https://rss.news.yahoo.com/rss/tech"
Set xmlHttp = Server.CreateObject("MSXML2.XMLHTTP.4.0") xmlHttp.Open "Get", myRSSfile, false xmlHttp.Send() myXML = xmlHttp.ResponseText
Set …
Read MoreI'm surprised this isn't built in.. I had the hardest time finding how to convert ATOM time (found in many RSS feeds) to something human-readable. The cleanest solution I have found thus far is this:
That outputs "04.22.06" but you can use any of the formats available from php date().
Here is basically the …
Read More- I have a another blog that mentions random words like "daughter","school", "dirty", "bad", "dog", "herself", "year", "nasty" and "old." Until I started revewing my HTTP referers, It never even occured to me that nasty perverts …
Read More I released my first Wordpress plugin last night! It's a script that hides/unhides and slightly formats blocks of code. I use it heavily on this site. Here's an example:
a.quickcode { padding-left: 20px; background: url('/wp-includes/images/quickcode.gif') no-repeat; }
You can read more abou the plugin here: QuickCode.
Read MoreRecently my Exchange server got pounded by spammers that were attacking my NDR (non delivery report) capabilities. Turning off NDRs helped 75% and I explored Exchange quite a bit along the way to figure out that last 25%.
It seems that I had 180 emails stuck in my queue. I was looking at my logs and ethereal and it …
Read More- This may only be useful for wscript.exe so it may not have universal appeal but I'll list it anyway. The first script is to be inserted at the top of the wscript file you'd like to monitor. The second file is to be run as a scheduled task. SQL Server is used to keep track of the PIDs. SQL Server Express is free so you …
Read More