Jun 022012
 

Sorry Guys, I ran out of bandwidth last month but I’m still here.
I’ve been getting a few more visits recently so I may start running out of bandwidth more often, sorry about that.
When I can afford to move to a provider with more bandwidth, I shall do so.
Too strapped for cash at the moment though πŸ™

Share
Apr 272012
 

Hey Everyone,

There is a chance that my blog will go down between now and the 1st of May…I’m getting enough visitors to start hitting the monthly bandwidth limit for my webhost. If it does go down, it will be back up by the 1st of May and receiving visitors again πŸ™‚

Just a heads up for any dedicated readers.

Share
Dec 302011
 

So I just created a query that will get today’s date dynamically from the database itself, but I’m sure there must be a simpler way of doing it.
the query I’m using now is :


SELECT
count(Incident_ID)
FROM
INCIDENTSM1
WHERE TITLE = 'Password Reset - Windows Login'
AND
CLOSE_TIME > CAST(DATEPART(year,GetDate()) as varchar)+'-'+CAST(DatePart(month,getdate()) as varchar)+'-'+CAST(DatePart(day,getdate()) as varchar)

Just thought I’d throw this out there in case anyone else needs to do something similar in Microsoft SQL.
If anyone has any suggestions on how to improve that query, feel free to post them in the comments.

Share
May 262011
 

So I’ve decided to rename my network as I’m getting bored of all the hostnames on the computers.
At the moment I’m thinking Transformer names, since I’ve been a Transformers fan for a long long time.
Does anyone have any better ideas ?

So, Autobots or Decepticons ?
Or if you have any other ideas, feel free to leave me a comment.

[suffusion-widgets id=’1′]

Share