In memory of my Dad Richard John Orr who passed away yesterday after being hit whilst crossing the road.

 

My Dad was on his way home from playing Bridge his favourite passtime and had just had a nice call from my Mum who was on her way to collect him.

 

We spent a few days together last week as I flew to Hawaii to collect Mum and Dad off a cruise and bring them home.

 

I am surprised at the depth of impact I feel as you think you are prepared as your folks get older.

 

Richard John Orr was a good man with family that were happy to be associated with him.  He was much loved and will be remembered by many.  He had a brilliant mind and was an accomplished engineer and town planner.

 

He had 4 children and 8 grand children.   He was a first grade rugby player and manager for St George.  He was a master at bridge and is sorely missed.

 

Part of me goes with you Dad.

So here is why I got a 29110 error.  TFS 2008 was released before SQL 2008 so it does not support SQL 2008.  However TFS sp1 does.

 

But there isn't an integrated install for sp1 so you have to build it yourself.

 

The basic idea is that you take your install, run a merge with sp1 and generate to a separate directory and then copy it back over the top of your original install.

 

Here is the blog entry that helped though the details are in the TFS help.  I got stuck on accessing the help for a while as I forgot to access the file properties and select unblock.  The web content is blocked by default.

 

 

 

 

Spare me.  I mean how hard can installing TFS be.

 

I worked out my SQL connectivity and my Analysis Services Connectivity.  I installed Reporting Service cool and passed the validations.

 

Did it work, no way.  Error 29110 Reporting Services .... blah blah.

 

My google is burning with the issue but what is the problem.  Stay tuned.

Rob is demonstrating that he really  knows his way around a database execution plan.  His presentation is good.

OK its time  we get into this.   Greg is introducing the subject and Dave Lean is taking it on.  In this case I am a bit nervous of getting involved but I think this will move from scary to standard in the near future.  Bring on Dave's session.

Here we are in Wagga.  At least 100 people getting together in Wagga Waga to talk SQL.  Greg Low has put this all together. I'm giving the refined version of MDX for a SQL Dude course.

 

I'm looking forward to learning and hanging with the dudes and dudets.

Recently I have encountered the Generate Command.

 

It applies a member based set function with a set and then unions the result.  So the following is showing the parents of an Owner based on the Property Owner Lan ID but in this case we don't want the actual member but the parent i.e. the Sales Centre of the Owner where Owner is a Parent Child relationship,