Blog moving to http://blog.xploiter.com

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:

http://blog.xploiter.com

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

Si

Advertisements




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:

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

BEGIN
DECLARE @sItem VARCHAR(8000)
WHILE CHARINDEX(@sDelimiter,@sInputList,0) 0
BEGIN
SELECT
@sItem=RTRIM(LTRIM(SUBSTRING(@sInputList,1,CHARINDEX(@sDelimiter,@sInputList,0)-1))),
@sInputList=RTRIM(LTRIM(SUBSTRING(@sInputList,CHARINDEX(@sDelimiter,@sInputList,0)+LEN(@sDelimiter),LEN(@sInputList))))

IF LEN(@sItem) > 0
INSERT INTO @List SELECT @sItem
END

IF LEN(@sInputList) > 0
INSERT INTO @List SELECT @sInputList — Put the last item in
RETURN
END
GO
–Test
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 : http://searchwindevelopment.techtarget.com/tip/0,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 : http://news.bbc.co.uk/1/hi/technology/7707016.stm





    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 WordPress.org 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 http://en.blog.wordpress.com/2008/10/21/wordpress-27-coming-soon/