blog

My blog of techy stuff, ranging around SQL (SQL Server, that is), C# and .net, JavaScript and a smattering of stuff about the Orchard CMS (that powers my site) as I get more familiar with it. There's the occasional non-technical post when something is of interest to me that I feel is worth sharing, but they should be few and far between

  • Project Management

    Grand Designs (on Channel 4 on November 2nd 2005) was all about a build in Belfast. After having seen the organised chaos that is many of the other builds that Grand Designs has showcased, this one …

    Read more...


  • Developer (& Tester!) Quality

    Joel of Joel on Software posted an interesting entry a while ago that makes a point about time vs developer resource.

    The part I'm interested in starts about a third of the way …

    Read more...


  • Managing...

    Time -- Time Management Tips for Developers

    Collect all tasks in a to-do list -- I started doing this fairly recently (in part prompted by an internally delivered training course I …

    Read more...


  • What are the INFORMATION_SCHEMA views?

    They're fantastically useful things which make it easy to access metadata in SQL Server in a (theoretically!) version agnostic manner. I've mentioned them (or similar) in SQL Server 2005: sysXXXX …

    Read more...


  • Writing Bug Reports / Defects

    Spurred by: The Perfect Bug

    Having read this blog entry and found it really rather interesting, it's got me thinking about Severity and Priority of defects/bug reports. What's the …

    Read more...


  • Finding the Foreign Keys for a table

    For a while it's been driving me barmy, trying to obtain a list of Foreign Keys which reference a particular table. Below is the end result of my hunting. No doubt the code could be optimised, which …

    Read more...


  • Managing Email

    A couple of good articles regarding the art of managing email. [via: Jonathan Hardwick: Shipping Version One]

    Tips for Mastering E-mail overload

    Change This :: The Tyranny of …

    Read more...


  • Enumerating the databases on a server in SQLDMO/vb.net

    Whilst you could just execute the following TSQL command:

    select name from master..sysdatabases

    to obtain the list of databases on a SQL Server box, it's far more fun to try and do it the SQLDMO …

    Read more...


  • Using SQLDMO in .net (VB.net)

    Using SQLDMO within .net isn't the easiest thing to find information about, so here goes with some documentation.

    The first thing that you need to do is add a reference to the SQLDMO library. With . …

    Read more...