Sony does it again

I was a fan of the last Bravia advert partly because it featured José González but also because I was left wondering whether it was a computer render or really happened (aparently they really did it) but the new Sony Bravia advert is incredible, ok there are a few computer GFX effects in there to remove peoeple etc but oh my word...

The new Sony Bravia advert: www.bravia-advert.com/paint/thead/full/

Gazumped

As some of you know, we’re selling our lovely house 68 Campbell St (www.68campbellst.co.uk). The house has served us well in the past as there’s an office at the rear of the property that we can run the business from and plenty of room for all my CD’s and Stacey’s shoes.

We’ve also found our next place and all was progressing fine until the other day (now a couple of weeks ago) we were called and told that the buyers had pulled out just before the point of exchange. Obviously they’re perfectly at right to do so but man it’s got my back up. We’ve done all the surveys on the next house, sorted all the legal mumbojumbo and were ready to complete within a week, that left us nearly at square one.

A couple of weeks have now passed and luckily we’re in a position to keep this place to rent it out and still buy the next house which is great news, but if you’re out there reading this, you’re really lost out on a lovely house and I just don’t believe the excuse “It’s an old property” –well der!

I feel sorry for anyone else out there who has been gazumped, I hope it all worked out for you in the end.

Blogging and competition

One of the reasons I started this blog was because I felt I often came across nuggets of information that someone else out there may find useful in some small way and that I should share the information where possible. I also wanted a place to store all those little gems that I’m forever forgetting. That and I am forever asked similar questions that I think the “masses” (all three of you) would like to hear about.

For quite some time I’ve been writing sets of articles that I was hoping to raise the profile of The Site Doctor with but as with many things in atm it seems they’ve been slow in getting finished. I have however been collating the various snippets together and collaborating with a number of sources and nearly every time I speak to a new “source” I get asked the same question “why would you want to write about this stuff –it just increases your competition”.

That never fails to make me chuckle to myself (not at you mind), I say why not? No offence but if we’re that unconfident in our knowledge that a few articles about common (and often simple) issues people run into that will suddenly make my competition take over then so be it, but personally I like to feel I’ve got enough knowledge to share and not feel threatened –perhaps the wrong tack to take but hey!

I also feel that by sharing the information with other people (not just developers, there’s stuff here for everyone) that in my own small way I’m making the web a better place –even if I’m not personally writing the code something here may have influenced you –even if it’s just answering a simple question you’ve been tearing your hair out over such as “Do pineapples grow on bushes” –yes they do, you can see photographic proof here.

Anyways, that’s my 2p worth, if you don’t feel secure enough to share your findings that’s up to you!

Stored Procedure to assign permissions

This is a useful stored procedure for assigning permissions to users quickly and easily. We tend to assign a new login to each application we develop, this way we limit the damage possible in the event of a username/password compromise.

Note 1: In addition, we tend to prefix our database objects with useful prefixes to group relevant tables, i.e. if we had login information stored in the database we may use “Login_” as the prefix, using this method with this Stored Procedure to assign permissions you can easily select the relevant objects. So you could alter the stored procedure a touch:

I’m a bot! –According to Google Anyways

While fitting my new chipset cooler fan this morning I was checking out an error message on Google (which as it turns out I knew the answer to) and I was presented with a CAPTCHA image –I guess Google’s getting a lot of automated requests. This was using the built in Firefox search box but then I got it again on the PC using Google’s search box!

String.Format and Input string was not in a correct format Error

I ran into (another) interesting error today when using String.Format¹. I was getting the error message "Input string was not in a correct format.". In this instance I was calling the content from an XML file, the data was wrapped in CDATA tags so there shouldn't have been an issue with line breaks etc. On investigating the error further I found it was being caused because the content was a HTML page. More specifically, the String.Format error "Input string was not in a correct format." was being caused by the CSS declaration's curly braces.

To work around the method perceiving them as placeholders, simply replace each curly brace "{" with double braces "{{".

To replicate the error:

The fix in place:

¹The String.Format method accepts a format string which can include place holders (designated by the curly braces {} and a number that refers to the location of the item that should appear in the list). A quick example of String.Format:

Would produce: "This is some text the date is 02/10/2006"

Useful Visual Studio Plugin

On surfing around the net the other day looking for a replacement to Visual Studio 2003’s clipboard monitor I stumbled across this excellent Clipboard manager plug-in for Visual Studio 2005. As his blog was offline at the time I wasn’t sure exactly how to use it but now I’ve had a play I’m not sure I’ll be able to do without it!

Check out the Clipboard Manager plug-in at
http://www.csharper.net/blog/clipboard_manager_upgraded_to_package.aspx

For those of you interested, the plug-in monitors the clipboard activity allowing you to resurrect previous clipboards and make them current and even locking items so you can use them at a later date. I’ve found it incredibly useful when testing sites as it allows me to keep common messages on the clip. Downside is you have to have Visual Studio open at the time so I’ll have to look into a standalone version.

Here are a few shots of it in “action”:

The items that have been added to the clipboard in the past show up in the list at the top and there's a small preview window below (which I think you can select parts out of). You can also remove all items from the history by clicking the icon in the top left.

To re-select an old item double click it and it's instantly the main item! The currently selected item is the one in black text with a green arrow next to it.

The context menu offers a number of extra options including the ability to lock and unlock an item, this means when you restart your computer the item is still in the history -great if you have common items such as test credit card numbers! If you want to remove a single item from the history, you can do that using the context menu too. I've not yet used the "Save to File" or "Search Online" items.

Update: There does seem to be some sort of glitch with it, I think my history has got corrupt at somepoint so when I clear all the unlocked items new items weren’t getting caught anymore. I've found two solutions: The first is to restart Visual Studio, the other is to unlock all items and clear the history completely. This seemed to sort it. I did also note that I had one blank item at the top of the list so I guess that's what was causing it.

IIf Issues

Sean Ronan (from Activepixels.co.uk) was asking me the other day why he was receiving a “Cannot convert ‘’ to DateTime” when writing:

Thanks to Doug Setzer from 27Seconds in pointing him in the right direction, unlike C#’s ability to write:

(TrueFalseStatement ? TruePart : FalsePart)

VB’s IIf is a function not a statement so unlike C#’s equivielent which is run un-evaluated, VB’s IIf function evaluates both sides of the statement regardless of whether the statement is true of false.

Yet another reason to use C# IMNSHO

Remembering your age

Ok, I think this has to be the most random post yet, I'm forever forgetting how old I am so popped onto Google and got a little calculator to tell me, the result was 24 (I was pretty darn sure about that already) but what I did find out was that I was born on a Thursday, thinking about that old Wives' rhyme I had to find out what I am:

• Monday's child is fair of face,
• Tuesday's child is full of grace,
• Wednesday's child is full of woe,
• Thursday's child has far to go.
• Friday's child is loving and giving,
• Saturday's child works hard for a living,
• But the child born on the Sabbath Day, Is fair and wise and good and gay.

So apparently I've got far to go, I hope it means I'm going to do well in life rather than I'm going to have to travel far but only time will tell!

Giant Bug Invades Germany

I was sent this link by Craig this morning, it's most ammusing and yet another reason not to goto Germany... :)

http://maps.google.com/maps?hl=en&t=k&q=Germany&ie=UTF8&z=18&ll=48.857699,10.205451&spn=0.002404,0.006738&om=1

It got me wondering how they take these photos, I always assumed it was digital sent down to NASA (or similar) but having an in-focus insect on the shot is most intreging, even if it was crawling across during post-processing it would be black and not in focus.

Perhaps there really is a 50m bug in Germany, or perhaps it's just another rouse like the guy that wrote f**k in the field.

National Canoe Finals Bedford

For those of you interested, the photos from the Hastler Finals (National Canoe Finals) are now online, taken a few days but oh well that's life

Photos from the Bedford Finals - http://www.thesitedoctor.co.uk/photoalbum/default.aspx?fld=photos/Canoeing/Hastler%7EFinals%7EBedford%7E2006_09_16_17

Again it's on the old album for now so I apologise.

On the whole the race went ok, Sam paddled very well but I had to spend most of my time bracing against the incredible wash -at times the water was coming over the front of the boat and into Sam's cockpit. Pat and Paul had a bad experience with the start gun going before they managed to get to the line -despite my comments to the starter that not everyone was there. The organisation of the race was terrible, the "accomodation" (one toilet) wasn't great which was a shame but all was soon forgotten when we were off the main canal without the wash it was a nice race.

We're still awaiting the results but I'll post them here when they're online.

SQL Server a memory hog? No, not at all

Craig found an amusing dity today, he was messing around with the settings in SQL Server Express and noticed these memory settings:

For those of you who don’t want to deliminate it, that’s:

• 2,147,483,647 Megabytes
• 2,147,483 Gigabytes
• 2,147 Terabytes
• Or 2 Petabytes!!

One does have to wonder what sort of super computer Microsoft are expecting to have run the database. It's certainly future-proof that's for sure. I'd love to have 1TB of RAM, let alone 2PB! So the next time you wonder what’s taking up all the memory, best check SQL Server –you might just find that lost Petabyte…

BTW if this blog post is still around when Petabytes are as common as Mega and Gigabytes are now then feel free to lean back in your chair and recollect “the good ol’ days” when computers only had 200-300GB of disk space and a couple of Gig’s RAM.