Blog moving to

15 01 2009

This blog will be moving, actually it already has, i’m just keeping the two side by side until the search engines grab a hold of it properly.

Anyways the new URL is:

Pass it around, add comments, use and abuse it and let me know what you want me to cover 🙂


Split SQL Strings

22 12 2008

If you have a need to parse a string array passed in as a variable into say a stored proc, use the following function to split it:

@sInputList VARCHAR(8000) — List of delimited items
, @sDelimiter VARCHAR(8000) = ‘,’ — delimiter that separates items
) RETURNS @List TABLE (item VARCHAR(8000))

WHILE CHARINDEX(@sDelimiter,@sInputList,0) 0

IF LEN(@sItem) > 0

IF LEN(@sInputList) > 0
INSERT INTO @List SELECT @sInputList — Put the last item in
select * from fnSplit(‘1,22,333,444,,5555,666’, ‘,’)
select * from fnSplit(‘1##22#333##444′,’##’) –note second item has embedded #
select * from fnSplit(‘1 22 333 444 5555 666’, ‘ ‘)

Original Article Here :,289483,sid8_gci932171,00.html#

Windows Skydrive to upgrade to 25gig online storage!

21 11 2008

If you don’t know, Windows Skydrive is Microsoft’s offering of free online storage – previously it was only 5gig but now they are upping this limit to 25gig, more than likely to bring them in line with other free online storage providers out there (me cynical, nah!)

Anyways I played about with it a few months ago and promptly left it dead for the following reasons:

  • You can only upload a max file size of 50 meg, pretty useless nowadays
  • There are no tools to bulk upload many files so if you have 1000 files to upload, you had to use their upload form which if I recall only allowed 5 files at a time!!!
  • There is no way to map the service to a drive on your system
  • I’m going to keep an eye on this as it’s something I’m looking at seriously as online backup, I’d like the following features implementing which I feel are definitely required in order for it to be taken seriously by users:

  • Remove the max file size restrictions or at least increase it to something usable
  • Provide an API so that developers like us can write upload tools that actually do what we want them to do
  • Give us a better bulk upload experience
  • Automatic sync would be great
  • Possibly built in encryption (although I would encrypt anything I upload to there anyway) – not that I don’t trust you Microsoft, but I don’t!
  • You can read more at the Windows Team Blog HERE

    I’ve also just discovered Windows Live FolderShare – don’t know anything about it yet apart from the fact it’s about to be replaced by Windows Live Sync in December but i’m going to check it out and see how these services complement SkyDrive………………

    The end of an era – Windows 3.x

    5 11 2008

    Windows 3 splash screen, Microsoft

    Windows 3.x established the look of the operating system.

    An application has expectedly quit.

    Windows 3.x has come to the closing moments of its long life.

    On 1 November Microsoft stopped issuing licences for the software that made its debut in May 1990 in the US.

    The various versions of Windows 3.x (including 3.11) released in the early 1990s, were the first of Microsoft’s graphical user interfaces to win huge worldwide success.

    They helped Microsoft establish itself and set the trend for how it makes its revenues, and what drives the company until the present day.

    High flyer

    For many computer users 3.x was the first Windows-based operating system they used, and the software established the iconography of Microsoft’s flagship product.

    As it was updated the software started to make PCs a serious rival to Apple machines, as it could take advantage of much improved graphics, had a broader colour palette, and could use multimedia extras such as sound cards and CD Rom drives.

    Microsoft maintained support for Windows 3.x until the end of 2001, and it has lived on as an embedded operating system until 1 November 2008.

    Virgin Atlantic jet, Virgin

    Windows 3.x has found a role onboard some long-haul jet aircraft.

    As an embedded system, it was used to power such things as cash tills in large stores and ticketing systems.

    One of its more glamorous uses as an embedded operating system is to power the in-flight entertainment systems on some Virgin and Qantas long-haul jets.

    Tech specs

    Stefan Berka, who runs the GUI Documentation Project, said the important technical innovations in the software were its extended memory that could address more than 640KB and the improvements to hardware support.

    The fact that it was 100% compatible with older MSDOS applications helped too.

    Windows 3.x required an 8086/8088 processor or better that had a clock speed of up to 10MHz. It needed at least 640KB of RAM, seven megabytes of hard drive space, and a graphics card that supported CGA, EGA and VGA graphics.

    By comparison, the Home Basic version of Windows Vista requires a 32-bit 1GHz processor, 512MB of RAM, 20GB of hard drive space, and a graphics card with at least 32MB of memory.

    Windws 98 on production line, AP

    Many people still rely on older operating systems.

    “I haven’t received an e-mail about Windows 3.11 for a long time,” said Andy Rathbone, author of a Dummies guide to the software. “But I wouldn’t be surprised if some people still use it.”

    Sales of the software still pop up on eBay, he said, but not at a price that would tempt him to part with his unopened copy of Windows 3.1.

    Agent Quang from home IT support firm The Geek Squad, said he regularly encountered venerable operating systems in customer’s homes but it had been a long time since he saw Windows 3.x.

    “The majority of machines we run see are running XP,” he said, “Vista is still a bit flaky here and there and people are not comfortable with it.”

    But, he said, Windows 95 and 98 were still popular with some customers.

    “We see them on laptops and people are unwilling to let them go,” he said. “It’s perhaps because in the early days laptops cost a lot more money they do now, and there’s much more perceived value there.”

    Agent Quang’s personal favourite operating system was Windows 98 because, by the end of its life, the software was so solid.

    Old Iron

    He said anyone running an ageing operating system might face problems as they try to find a web browser that could run on it and display the latest online innovations.

    “We had a case a while ago a customer with a Windows 98 machine trying to view her website and the pictures were just not coming up,” he said. “Eventually we had to install Netscape Navigator to get it working.”

    Stefan Berka said he had recently re-installed Windows 3.11 on a computer and was surprised at the results.

    “Personally, I had fun at my last Windows 3.11 test installation to make it a useful desktop operating system again,” he said.

    “With patched SVGA driver for 1024×768 resolution, Internet Explorer 5, WinZIP, VfW and Video Player, it was still useful,” he said. “The desktop was ready after a few seconds loading time.”

    Said Mr Rathbone: “Windows 3.11 would still work reasonably well today, provided it only ran software released around the same time.”

    He cautioned against anyone considering returning to the olden days and using it as their mainstay operating system.

    He said: “I wouldn’t connect it to the internet, though, as it’s not sophisticated enough to ward off attackers.”

    Original article from BBC News Website :

    Unique view of concorde

    4 11 2008

    Created with dumpr.netphoto fun

    Rubik Cube Wedding picture on Concorde ± Manchester Airport October 20th 2008

    4 11 2008

    Create your own Rubik’s Cube

    WordPress 2.7: Coming Soon

    31 10 2008

    Just Spotted this on Janes Blog, hope she doesnt mind me putting it here 🙂

    As you may know, we’ve been working behind the scenes on the design and development of version 2.7 of the WordPress software that powers your blog. The administration interface you’re used to will be changing as a result of your feedback and the results of the usability testing we conducted over the summer. Version 2.7 is due to release officially on November 10, but in the meantime, we’re posting sneak previews of the look and functionality to come. So far we’ve covered the new navigation system and the new Dashboard. If you want to get an early idea of what you can expect come November, head over to the blog and check out The Visual Design of 2.7 and The New 2.7 Dashboard.

    We’ll be publishing more descriptions of how things will work over the next couple of weeks so that when the change comes it won’t be a complete surprise. We’re also working on new Help materials that you can use for reference (replacing FAQs, screencasts, etc.) while you adjust to the new structure. Overall, the response so far is that the new interface is easier to use, and that it’s faster to access the screens people use most, so hopefully once you’ve checked out the posts linked above, you’ll be as excited for the launch of 2.7 as we are.

    More from Janes original post here

    What really gets my goat about the latest ‘credit crisis’

    28 10 2008

    Is the fact that it’s purely down to greedy banks and corporations trying to get rich and greedy with our money and then when it all goes tits up going back to their £5 million palaces and enjoying the money they have made whilst the likes of normal people like you and me have to work out butts off to stay afloat.

    When will people realise that crap governments, poor bankers, shitty sharedealers and most importantly fat cats like oil sheiks, energy bosses etc are the main cause for all this upset and do something about it?

    Why the hell should oil production be tapped down just because the price of a barrell has dropped – simply so the sheiks can rip us off with higher prices and line their million pound loos with more gold embossed wallpaper (maybe they use it to wipe their asses as well?)

    Why should energy bosses be pulling in close to a million pounds per year and then tell us we need to pay more for gas and electricity – you really are not worth paying even a quarter of what you earn so give some back!

    I could go on and on here, maybe I should just call it quits for now but I don’t think i’m alone in my thoughts here!

    I like you

    29 09 2008

    I like you

    Originally uploaded by

    I like you I do, honestly I do, fancy a date?