• Expert profile: Mr David Gardiner

    The University of South Australia participates in publishing it’s staff expertise on ExpertGuide.com.au. It’s a site that aggregates expertise from academic and professionals, and is obviously a great resource for journalists.

    Because I’d presented some talks on Internet Safety for Children, I’d added this as an area of expertise, not really thinking about how this might be interpreted by other users of the site (eg. journalists).

    I’ve realised now that this explains the phone call earlier this week, and again today from from a Sunday Mail journalist.

    Consequently, I’ve updated my profile to more accurately reflect what I am an expert in.

    Internet Safety for Children is an interest and a concern of mine, but I’m not an expert in that field.

  • LINQ for SQL at CodeCampSA

    Just in case you didn’t realise, I’m doing a talk on “LINQ for SQL” at this weekend’s CodeCampSA. Yes, I’m the first “real” speaker after morning tea on Saturday!

    I’ll be doing an updated version of the presentation I did for the SQL User Group in February.

    At that time, the latest LINQ for SQL was the May 2006 CTP which installed on top of Visual Studio 2005. Since then Microsoft have released Beta 1 of Visual Studio 2008 which has also incorporated some language syntax changes to Visual Basic related to the LINQ bits. Fabio has listed some of the framework changes since last year.

    Bits that affected my presentation include:

    • The Visual Studio LINQ to SQL Designer now works pretty well (no need to use the SQLMETAL.EXE command-line tool)
    • Overriding insert/update/delete operations now doesn’t use attributes (this is a bit strange) on the methods.
    • Projections in VB don’t need to use New, and you use ‘=’ instead of ‘:=’.

    I also did some testing of SQL generated for SQL Server 2000 versus 2005. It turns out LINQ for SQL is smart enough that it uses 2005 features (eg. ROW_NUMBER) when they will perform better.

  • Microsoft .NET Framework 3.5 June CTP

    Here’s the June CTP release of

    I’m not clear whether these can be installed on top of Visual Studio Orcas Beta 1.