Category Archive: Programming

Jul 21 2010

Really?

Really_20100716_1611.png

In this day and age with security and all, why does this Microsoft provided Windows Phone training kit default it’s installation path to the root?

Permanent link to this article: http://ramblinggeek.co.uk/2010/07/really/

Sep 01 2009

Windows Home Server Add-in

Here in the UK we had a bank holiday yesterday which of course meant we had 3 days off.  So I spent some time with the wife over the last few days and decided that I would embark on new project. Last week I was looking at the plug-ins for Windows Home Server.  I came …

Continue reading »

Permanent link to this article: http://ramblinggeek.co.uk/2009/09/windows-home-server-add-in/

Jan 13 2008

T-SQL: Calculate Hours, Mins and Secs from StartTime and EndTime

select   sum(TotalSeconds) / 3600 as Hours,   (sum(TotalSeconds) % 3600) / 60 as Minutes,   sum(TotalSeconds) % 60 as Secondsfrom(select ArrivalTime, DepartureTime, DateDiff(second, ArrivalTime, DepartureTime) as TotalSeconds from SSRwhere CustomerID = 10) xThanks to this site for the heads up.

Permanent link to this article: http://ramblinggeek.co.uk/2008/01/t-sql-calculate-hours-mins-and-secs-from-starttime-and-endtime/

Feb 08 2007

T-SQL Queries

I was trying to figure out how to get a T-SQL to allow a user to enter part of a name to query on, for example the user could enter ML, click a search button which would return all companies with the letters ML in. I Googled this and looked on MSDN, to no avail, …

Continue reading »

Permanent link to this article: http://ramblinggeek.co.uk/2007/02/t-sql-queries/