Customising the wHooiz Friendz list

If you look at Nick's blog, you'll see that he has a lot more wHooiz Friendz than me. That's probably because he's a lot more popular than I am. But also, I filter my list to show only a few. If you refresh the page, you'll see more.

You'll also notice that he has a big blue and white title at the top, which currently says "Friendz recently here" (but is subject to change – this comes from the wHooiz script that produces the list). But I don't have that on mine. I have the standard Community Server sidebar heading, but that's it. And here's how I did that… Really simple – I looked at the HTML that's shown, to see that that title bit has an id of whooiz_tr1, and then altered my CSS slightly, adding #whooiz_tr1 { display:none; } to it.

I guess I could've just changed its style to be just like one of my normal sidebar headers, but I actually figured that it would be easier to scrap it completely, and have my own header there. 🙂

Application monitoring in 20 seconds with PowerGadgets

Performance Monitoring is great, but unless you've made a bunch of custom monitors, it doesn't really tell you the health of your application. Well, not completely.

For example, take wHooiz – Cameron and Clarke's profile tool. I'm sure they have various things running to to persuade them that their system is ticking along nicely. But that doesn't tell them whether their marketing is working. It doesn't tell them if their application is actually happy and successful. There may be no 404s in site, but if no-one is using the thing, then they're failing. Luckily for them, they seem to be having a great deal of success. I'm sure if you go there, you'll find out they're giving away a Nintendo Wii soon. But wait until that competition is over before you start using wHooiz, because I want to win it.

To find out if they're doing well, these guys run a query on their database which shows them how many people have registered. Currently it's about 125. If the site is going well, it might be 130 by the time I've finished writing this, and 200 by the time you're reading it. Or maybe my blog is really popular and you're reading this while it's only 131, who knows?… but Cam and Clarke should know. For the sake of their confidence in their application, they should be seeing a number tick over in the corner of their eye… maybe in their sidebar!

And this is where PowerGadgets comes in. And you don't even need a sidebar to have PowerGadgets do its thing – it works just fine in XP as well, floating around the desktop, on top of your applications if you want.

So go and download (and install) the evaluation copy, and walk with me for a moment. Counting the seconds, we…

1… 2… find the "PowerGadgets Creator" in the Start Menu and click it… 4… 5…

Pick "Digital Panel" from the list presented in the screen that opens up, and then the SQL option in the next pane. (Don't bother taking the time to notice that you can very quickly use maps, gauges, charts, or get your data from Web Services or PowerShell – that's not part of the 20 seconds)… 8…

Enter the database connection details (all us developers know how to do this really quickly, right, but let's assume it took you three seconds)… 11… 12…

Now paste in the SQL statement you prepared earlier, something like "select count(*) from dbo.PeopleRegistered". 14…

Ooh, there's the result of the query in a nice digital format… but we're not done yet.

Let's click the "Data Refresh Rate" button, and leave the default of "1 minute" (or whatever you want… 5 seconds if you want to see something happening more often).

15… Change the "Display in" option to Desktop, and hit Save. 17… Give it a name, 18…samplepowergadget

And you're done. Take the remaining time to launch it and see your numbers happily changing each minute.

Ok, so you might want to explore the options some more, and take a whole minute over it. Alternatively, you might want to pipe the results of a PowerShell script straight into out-gauge or out-chart, possibly using the -configure option to give you more options when you do. Or then pipe the result of out-chart into an email, and see it arrive in your Inbox with a pretty graph!

It costs about US$300 for the tools to make this, which is probably worth it when you consider the time you'll save. The licence to display a PowerGadget is about US$70, but if you can show someone this easily that their application is working (or that they're making sales, or whatever), then I'm sure they'll happily part with that too.

The best brands in the world use Microsoft

There's a great site about Vista/Office/Exchange/etc at, and I'm almost in one of the videos there!

of the articles shows a video about Arsenal Football Club, and about
five seconds in it shows a goal from a match against Aston Villa (which
we won 5-0), and I was there on April 1st. There's another goal from
this match right at the end, when Thierry Henry scored an exquisite
goal. Both goals were at the end that I was at, but I'm not in the
camera's view.

Simulation questions in 70-431

Earlier this year I was one of four people who wrote a bunch of simulation questions for 70-431. Today I heard from someone who has sat the exam with that content in it. It's great to get feedback on them, because it really helps Microsoft Learning work out how to improve the exams even more.

If you're reading this and have done the exam with the simulation content, please feel free to drop me a line (rob_farley at me what you thought of them. Don't comment on my blog, because that's public… but feel free to send me an email directly to let me know your thoughts. If you're worried about non-disclosure, you can confirm I've done the exam myself by checking out my MCP transcript – use 707979 and Adelaide to get access.