Month: September 2007

I was thinking about how to best represent connections between people in my Six Degrees of Separation Facebook application and Paul Crabtree recommend I get in touch with Moritz Stefaner as he had something that would fit very nicely indeed.

And he most certainly did; the relation browser was exactly what I wanted to do, but better. If you have a Facebook account, install the application, and go to the Show Network tab you’ll see what I mean.

This piece of SQL is perfect for finding which query is running at any particular time, especially if you want to find what it is that’s running very slowly.

sp_who2

This should return a list of what’s running, including process ids (in the first column). Find out what’s causing all the trouble and enter it’s id after spid = below:

DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM
  master.dbo.sysprocesses WHERE spid = 55
SELECT * FROM ::fn_get_sql(@Handle)

Everyone’s been either copying and pasting or writing from scratch some code to add “Invite friends” to their Facebook apps, but now there’s a simple tag that they’ve provided. It’s currently in beta and, knowing Facebook, is bound to change and break everything a few times, but it’s very easy to use:

"
image="http://apps.exponetic.com/itrust/
_img/iTrust-logo-magenta-small.gif">
  

(Note the slightly dodgy tag inside the content attribute.)

We’re now using it at Exponetic on our second Facebook application, called iTrust.

Exponetic, Facebook developers in London

iTrust

Six degrees of separation