Moritz Stefaner is a genius

The Six Degrees of Separation Facebook application

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.

Identifying slow blocking queries on SQL Server

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.


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)

The ‘Six degrees of separation’ Facebook application is 4th fastest growing app of the week

Exponetic’s first Facebook application, Six Degrees of Separation is apparently the fourth fastest growing app over the past week, according to Adnomics. The full league table is as follows:

Weekly Movers & Shakers
1 TextMeNow
+7,031 users (86.8%)
2 Cartoonify Me
+65,895 users (69.2%)
3 Gross Out!
+130,448 users (31.2%)
4 Six Degrees
+6,979 users (30.5%)
5 PickOff
+4,721 users (21.5%)
6 How Sexy Is Your Name Calculator
+28,735 users (19.0%)
7 Cartoon Friends
+8,732 users (18.8%)
8 mySI
+22,281 users (11.6%)
9 Class Notes
+8,372 users (9.3%)
10 Golf Buds
+16,378 users (6.8%)

Hopefully the trend will continue and I can keep adding new features.

The “Six Degrees of Separation” application

Exponetic Facebook developers

“Six Degrees” application statistics on Adnomics

The “Six Degrees of Separation” application

Facebook’s new ‘Invite friends’ tag

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:


(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


Six degrees of separation

Exponetic’s first Facebook application passes 5000 users

We’ve started developing Facebook applications at Exponetic and our first properly launched project, “Six degrees of separation” has passed 5000 users in under 9 days of live time. The growth has been quite amazing and still going.

Next steps are to do a bit more development on this app and there are a few more in the pipeline

Exponetic Facebook application development, London

The “Six degrees of separation” Facebook application