Recent Blog Posts
Jan 11
2012
0
comments
An alternative to JsonResult which removes nulls
I have been building an rest api which accepts and returns json. Unfortunately MVC JsonResult lead to double encoding if you are serialising objects.
Jul 17
2011
Fast delete using dynamic partition switching in T-SQL
Dynamic partition switching method for super fast deleting of old data.
Jul 5
2011
Swapping 2 variable values in python
Really impressed with python especially the power and clarity of the syntax.
Jul 4
2011
The house that Wittgenstein designed
This is a very striking building which is perhaps the product of a thought like that expressed in the Tractatus.
Jul 3
2011
Zip and FTP DB Backup using SQL CLR c#
a technique to create, zip and ftp SQL backups using a stored procedure within a standard SQL batch.
Jun 6
2011
C# CLR function to shred Facebook Social Graph json string into table
Finally a perfect use for SQL CLR. A proc which can shred the Facebook social graph into a table must faster than t-sql.