Archive | July, 2007

Talk Talk Customer Support Hell Part 2

My friend eventually found out what had gone wrong with her Talk Talk ADSL.

They had disconnected her and will take 14 days to reconnect.

This was not due to lack of payment – they just disconnected the line!  The customer support desks could not find this on their records two weeks ago… 

Read full story Comments Off

DBF File format specification.

This is a full definition of the dbf file format.

However is it worth the effort of $250/seat that is charged for Apollo.NET

Read full story Comments Off

Useful DBA Blog

This is a very useful DBA blog. 

Read full story Comments Off

Udf Oddities

I have been experiencing some wierd udf behaviour.
I have a udf that takes 7.5 mins to run.  The sql inside the udf runs in < 1s.
Run the query under index tuning wizard and it suggests a very odd index.
Adding the index gets the time for both down to < 1s.

I have a second udf that is not as condusive to the index tuning wizard.


Read full story Comments Off

Parallel Thinking

Recently I have been reading up on WPF.  I thought that some of the XAML support would be of use in the business layer.

It seems that I am not alone. Paul seems to take a similar line on domain models.

Read full story Comments Off

Stored Procedure Tuning Tips

This is an article on tuning stored procedures.

This is something that I have been partly sucesfully doing over the last few weeks.

It is an art – you have to guess and test most of the time. 

Read full story Comments Off

Dynamic Type Loading

Here is a very simple sample of dynamic type loading:

==== LoadLibrary.cs ==== 

using System;
using System.Reflection;

namespace LoadLibrary
    class Program
        static void Main(string[] args)
            Assembly ass = Assembly.LoadFile(AppDomain.CurrentDomain.BaseDirectory
                + @”.\SimpleLib.dll”);
            Type type = ass.GetType(“SimpleLib.SimpleClass”);
            object newInstance = Activator.CreateInstance(type);

=== SimpleClass.cs ===

namespace SimpleLib
    public class SimpleClass
        public override string ToString()
            return “I am a simple class”;


Build simple class into SimpleLib.dll

Build LoadLibrary into LoadLibrary.exe

Put SimpleLib.dll into the same directory as LoadLibrary.


Read full story Comments Off

Expressions Bland

Expressions Blend is described as a tool for designers to produce compelling user experience.

Its a shame that is does not apply to the product itself.

The demos are beautiful but have no means of seeing how they work.


Read full story Comments Off

Business Rule Example

This is a business rule example app.

The guy decided to use double entry bookeeping as a sample app. 

Read full story Comments Off

Lightweight Ruby Webserver to list podcasts

Once you get your head around ruby constructs the following was easy to write:

As a benefit it actually displays properly…

require ‘socket’

def latest3podcasts(session, podcast)
session.print “

  • Dir.glob(podcast)[-3..-1].each {|x| session.print “
  • #{x}
  • ” }
    session.print “


port = 8080.to_i
server =‘serveraddress’,port)
while (session = server.accept)
puts “Request: #{session.gets}”
session.print “HTTP/1.1 200/OKrnContent-type: text/htmlrnrn”
session.print “”
latest3podcasts(session, “/storage/podcast/dotnetrocks/*.mp3″)
latest3podcasts(session, “/storage/podcast/hanselminutes/*.mp3″)
latest3podcasts(session, “/storage/podcast/polymorphicpodcast/*.mp3″)
session.print “rn”

Read full story Comments Off